Re-Establishing Old References

BrianExcel

Well-known Member
Joined
Apr 21, 2010
Messages
958
hello -

A while back I wrote a workbook that was working well for me. Then my laptop crashed. I was able to retrieve some data, including the old workbook, but since the OS and Office Suite all had to be completely reinstalled and reconfigured, now when I try and run the workbook, I get error messages on certain code blocks saying I don't have the right references installed.

Is there any way to determine what references are needed in an easy way?

Also, dumb question, but is there any downside to just checking/enabling them all?

Thanks!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
Have you considered switching to early binding?

Then you wouldn't need references.
 

BrianExcel

Well-known Member
Joined
Apr 21, 2010
Messages
958
I'll have to look up what that means - thanks for the tip!

I have heard the terms "Early Binding" & "Late Binding" before in reference to another macro that I found (ShipTrack for Excel), but I have never investigated what exactly that means, or how to accomplish it.

Any links you could point me to? (Yes, I know Google is my friend)...
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,335
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top