Posted to microsoft.public.excel.programming

Barb Reinhardt Barb Reinhardt is offline

external usenet poster

Posts: 3,355

Stuck on SaveAs FileFormat in Excel 2007 VBA

I have the following line of code that just keeps kicking me out of Excel.

oWB.SaveAs Filename:=aWBName, FileFormat:=FileFormatNum

In this case,

aWBName = "myName.xls"
FileFormatNum = 56

What am I missing?

I'm saving the workbook to ths same folder as the original oWB so am not
including the path.

Thanks,
Barb Reinhardt

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Save as, changing default fileformat in Excel 2007	Anne Schouten	Excel Programming	4	March 31st 09 08:06 PM
SaveAs Filename and FileFormat in Vs2007	RobN[_2_]	Excel Discussion (Misc queries)	4	July 14th 07 01:21 AM
SaveAs Filename:=filename, FileFormat:=xlCSV	Teddy[_3_]	Excel Programming	2	May 29th 07 02:34 PM
Excel SaveAs not using specified FileFormat	NancyTG	Excel Programming	2	February 22nd 07 11:27 PM
Please add this in excel 2007 if not I am stuck with 2003	Jerry Stone	Excel Programming	5	June 17th 06 06:42 PM

All times are GMT +1. The time now is 03:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us