Can anyone see any obvious reasons why this macro would not work. It work fine on about half of the computers here, but some people are having issues and the debugger is highlighting the red code. Also is there a way to extract the file extension from the file being used so the .xls part works for a macro enabled work book?
Please Login or Register to view this content.
Last edited by Lacaycer; 10-03-2012 at 11:40 AM.
What's the error message? What version of Excel are they running?
Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
Entia non sunt multiplicanda sine necessitate
Macro was created using excel 2007 and is failing on 2 machine that run 2007. When it does fail there is no error message, the debugger opens and the section of code in red is highlighted yellow.
The macro works flawlessly on the machine it was written on and on machines running excel 2010.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks