View Single Post
  #10   Spotlight this post!  
Unread 07-11-2014, 09:59
indieFan indieFan is offline
RoboDox and LVHS - Missing you!
FRC #5941
Team Role: Engineer
 
Join Date: Jan 2002
Rookie Year: 2001
Location: Seattle (was SoCal, then SA,TX))
Posts: 382
indieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond repute
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.