LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default hard drive swap means vba code isn't running

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy excel program to new hard drive tfosurf Excel Discussion (Misc queries) 4 April 14th 09 04:14 PM
HARD DRIVE DENISE New Users to Excel 7 March 11th 09 08:06 PM
Links to mapped drive change to refer to local hard drive SueD Links and Linking in Excel 1 May 8th 08 11:42 AM
Can I save to hard drive AND my flash drive at the same time? Gizelle Excel Discussion (Misc queries) 3 July 24th 06 08:27 PM
Erase Hard Drive Mark C[_4_] Excel Programming 2 February 27th 04 09:24 AM


All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"