• Quick note - the problem with Youtube videos not embedding on the forum appears to have been fixed, thanks to ZiprHead. If you do still see problems let me know.

Excel VBA help

ihaunter

Undead Skeptic
Joined
Apr 16, 2004
Messages
380
Don't know if anyone can help me, but I can't find anything through google that seems to fit this problem.

I'm trying to make an Excel VBA macro to help pull info from various report files and but them on a spreadsheet for balancing at work. I hammered out some code that does the job pretty well, there are a few tweaks that I want to add, but it works. For me anyway. The problem is, if the spreadsheet is opened with someone else logged into windows, when they run the program, they get a Run-time error 52: Bad File Name or Number just trying to show the form. I can run it fine on any PC as long as I'm logged in.
This would seem to suggest some sort of permissions issue, but I can't find anything to change.
 
Never mind, found the error. I had an form initialize sub routine that had the problem.
 

Back
Top Bottom