|
Re: Non-Robotics: VBA for Excel?
I had it written at one point as "workbooks(2).saveas filenametosave fileformat:=51". That still wasn't working.
What did resolve the issue was no longer minimizing the workbook. It now works on 2013. My guess is that because the macro workbook is open and maximized at the time of running, minimizing the first file renders it inactive. Still not sure why the "Workbooks(2).saveas" didn't work.
Thanks to everyone for the suggestions and ideas.
|