Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Marco
My Visual Basic Marcos in excel 2003 do not function
after upgrading from Windows 2000 to Windows XP professional. I reduced the Marco security level but still get the following error message, "Can't find project or library" after hitting the F9 (calculate now). How do I use the Browse dialog box to find the missing reference ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Marco
In the VBE click Tools-References - one of the libraries should have
"Missing" next to it. -- If I've mis-understood the question please tell me. HTH ijb Remove nospam from my e-mail address to talk direct Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help "Andrew" wrote in message ... My Visual Basic Marcos in excel 2003 do not function after upgrading from Windows 2000 to Windows XP professional. I reduced the Marco security level but still get the following error message, "Can't find project or library" after hitting the F9 (calculate now). How do I use the Browse dialog box to find the missing reference ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Marco
Andrew,
Alt F11 to open the VB editor. Select the workbook or add-in that is causing the problem. On the menu, look at Tools, References and look for something marked as missing. Robin Hammond www.enhanceddatasystems.com "Andrew" wrote in message ... My Visual Basic Marcos in excel 2003 do not function after upgrading from Windows 2000 to Windows XP professional. I reduced the Marco security level but still get the following error message, "Can't find project or library" after hitting the F9 (calculate now). How do I use the Browse dialog box to find the missing reference ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Marco
Make sure you reset before looking for the reference - you may need to
browse to find it and the type of file you are looking for may be the .xla type. Andrew Bourke "ijb" wrote in message ... In the VBE click Tools-References - one of the libraries should have "Missing" next to it. -- If I've mis-understood the question please tell me. HTH ijb Remove nospam from my e-mail address to talk direct Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help "Andrew" wrote in message ... My Visual Basic Marcos in excel 2003 do not function after upgrading from Windows 2000 to Windows XP professional. I reduced the Marco security level but still get the following error message, "Can't find project or library" after hitting the F9 (calculate now). How do I use the Browse dialog box to find the missing reference ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Marco
I apologize for breaking in but I have seen the "missing"
references before and wondering why it happens and how to fix it??? -----Original Message----- In the VBE click Tools-References - one of the libraries should have "Missing" next to it. -- If I've mis-understood the question please tell me. HTH ijb Remove nospam from my e-mail address to talk direct Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help "Andrew" wrote in message ... My Visual Basic Marcos in excel 2003 do not function after upgrading from Windows 2000 to Windows XP professional. I reduced the Marco security level but still get the following error message, "Can't find project or library" after hitting the F9 (calculate now). How do I use the Browse dialog box to find the missing reference ? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Programming | |||
Visual Basic | Excel Programming |