Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All,
I am hoping someone can help me. Over the last few years, I have developed an extensive list of programs in VBA under Excel to automate various business tasks. These have always worked fine. Recently I had to re-install Win2k to a new hard drive (I corrupted my registry on the old installation). I have reloaded Office (2000 Pro) and copied over all of my spreadsheets. Everything looks ok, however, when I try to run one of my programs, it bombs with a message stating "Compile error. Can't find project or library." I am sure that I haven't reinstalled something correctly, but don't know where to look. Two other things that may or may not be relevant. One, I had VB6 installed on the old harddrive but not on the new one. I just purchased vb.net and have not yet installed it, but I can't figure out why that would cause the problem. Shouldn't the installation of VB6 or VB.Net be irrelevant? Two, when the code aborts, it is highlighting a line that reads "Rundate = Mid(Data, 43, 22)" with the MID highlighted. Don't know if either of these is an issue, but once again, I can't figure out why they would be. Any help is greatly appreciated. I've got some Managers waiting to hear what their monthly rankings are and this is holding up the whole process. Thanks Doug Wills |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy excel program to new hard drive | Excel Discussion (Misc queries) | |||
HARD DRIVE | New Users to Excel | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
Erase Hard Drive | Excel Programming |