I'll refer to the post I had posted previously, see post #4.
http://www.vbaexpress.com/forum/show...bscript+out+of
I had gotten around the error after tweaking the code a little.
[VBA]SheetName = Workbooks("MTO").Sheets(SheetNo).Name + ".DAT" [/VBA]
By throwing ".DAT" (File Extension) out.
Now I felt my program would do OK but I tested it on yet another machine and the same error 9 would come but the program would execute. What I found is little strange but seems to solve problem for me.
Just on a hunch since it involved file extensions. I went to
Windows Explorer >> Folder Options >> View Files >> And checked in
Hide Extensions for known file types. (See Attached Screenshot)
And the problem disappeared. I hope this might help someone so posted. Probably, we can have a section (sub-forum) as "LESSONS LEARNED", (I hope nobody minds my over-enthusiastic comment from wrong perspective!).
Regards,
Reply With Quote