Re: Save as (filename,fileformat) from Word VBA will not work

Guest

Posts: n/a

23rd Apr 2012

A simple look at 'SaveAs' in the VBA online help would quickly answer
this for you!

xlBook.SaveAs filename:=naam, fileformat:=<xlFileFormat>

...where <xlFileFormat> is one of the listed filetype formats
available in the version of Excel you are automating.

*Note*
There's no spaces in the syntax for the argument value pairs!

parameter1:=parameter1value, parameter2:=parameter2value

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

« Stock expiry projection | Count occurances in a range. »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2003 Save and Save As do not work for any documents or new on	Tom Arant	Microsoft Word Document Management	3	28th Apr 2008 01:12 AM
Using VBA - save an open word document with "Save As"	nxqviet	Microsoft Access	0	10th Jan 2007 05:07 AM
Clicking save results in both 'save as' word and save as draft	=?Utf-8?B?aGI=?=	Microsoft Outlook Discussion	0	15th Nov 2006 02:14 AM
Word 2002 save as menu says save as web page instead of just save as?	Gary	Microsoft Word Document Management	1	28th Jul 2006 03:26 PM
Word shows "save" and "save" in drop down menu- no "save as"	=?Utf-8?B?SmVubmlmZXJL?=	Microsoft Word Document Management	4	26th May 2006 06:21 PM