Thread: Save as (filename,fileformat) from Word VBA will not work
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default Save as (filename,fileformat) from Word VBA will not work
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


Reply With QuoteReply With Quote