Hi All,
So my problem is I have this existing macro to pull a sheet from another workbook in to the active workbook. All works perfectly in 2003, I have just upgraded to 2013 and it won't work, keeps saying Can't find the file, but if I open it in 2003 it does it perfectly.
Any help getting this working would be great. I have searched the forumns but have come up empty handed.
Please Login or Register to view this content.
Thanks,
This is how I would write that:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi There, Thank you for your reply.
This line keeps throwing me the error;
I have tried it both ways you suggested and then took out the "/" that I had in the file path but it throws the same errror either way.Please Login or Register to view this content.
Thanks
You can add this line above that:
Examine that popup carefully, see if you can spot the naming error.Please Login or Register to view this content.
Thank you for this!
This has helped me track down the naming error. Basically now 2013 requires the extension to be present in this case .xls must be added.
Thank you for this!!
An alternate idea is to keep the filename as is and add the .xls in the code:
Please Login or Register to view this content.
Yeah thats what I did.
Thank you so much for the help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks