Need a way to select 'Type' options when doing 'SaveAs'

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
jwobrien2
Newbie
Posts: 4
Joined: Sat Dec 12, 2009 9:58 pm

Need a way to select 'Type' options when doing 'SaveAs'

Post by jwobrien2 » Sun Aug 08, 2010 11:04 pm

I am running a script on Windows 7 using the Excel application in MS Office 2010.
I wrote a script which uses the 'Visual Basic' command "xlSheet.SaveAs filename" and it works OK. however, it always saves the Excel file in the
*.xlsx FORMAT.
I need to be able to do the 'SaveAs' but with the OPTION to save in the Excel 97 (older) format of *.xls, but do not know how to get at hose 'Type' OPTIONS in the 'SaveAs'

Can you Help?

Thanks,
John
helpJOB

Me_again
Automation Wizard
Posts: 1101
Joined: Fri Jan 07, 2005 5:55 pm
Location: Somewhere else on the planet

Post by Me_again » Sun Aug 08, 2010 11:37 pm

Maybe this article will help you.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts