Hello,
I am having problem to run the below macro with excel 2010 and 2013. It does work under Excel 2007 though. Can you help me to understand what is wrong with the macro?
Run-time error ´1004´:
Microsoft excel cannot access the file 'C:\C1C24100'. There are several possible reasons:
º The file name or path does not exist.
º The file is being used by another program.
º The workbook you are trying to save has the same name as currently open workook.
thanks,HTML Code:
Graig
Which OS are you using?
If posting code please use code tags, see here.
I am running windows 7
try this
Please Login or Register to view this content.
Regards,
Nandkumar S.
---------------------------------------------------------------
Don't forget to Click on * if you like my solution.
same error. I changed the path : Const spath = "c:\" to Const spath = "c:\temp" as my C:\ drive is protected
try to changing drive as d:\
or check the range"EVNAME"
code is working for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks