Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel VBA fails when opened from network drive
The error does not occur when the spreadsheet is opened from a network drive using Excel 2003. Anyone know if there have been a bug fixes in the latest Excel 2002 SP3 hotfix package for Excel crashing when spreadsheets ae opended from a network drive?- w0374
- Post #4
- Forum: Microsoft: Office
-
Excel VBA fails when opened from network drive
VBA does start to run so I do not believe this is a macro security issue - for information it is set to medium The VBA code runs until it reaches the 4th from last line r = MsgBox("No more matches found", vbInformation, "Find") It performs the MSGBOX and then Excel crashes with a popup window...- w0374
- Post #3
- Forum: Microsoft: Office
-
Excel VBA fails when opened from network drive
Hi, I have a spreadsheet that runs a macro to search the current worksheet for the text entered in a text box. The code runs OK when the spreadsheet is opened from a local drive but fails unexpectedly when the spreadsheet is opened from a network drive. Any ideas what maybe causing this...- w0374
- Thread
- Replies: 3
- Forum: Microsoft: Office
