Re-Establishing Old References

BrianExcel

Well-known Member
Joined
Apr 21, 2010
Messages
975
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!
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Have you considered switching to early binding?

Then you wouldn't need references.
 
Upvote 0
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)...
 
Upvote 0

Forum statistics

Threads
1,215,055
Messages
6,122,902
Members
449,097
Latest member
dbomb1414

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top