Posted to microsoft.public.excel.programming

Barb Reinhardt Barb Reinhardt is offline

external usenet poster

Posts: 3,355

Saveas error

I have the following bit of code

aWBname = aWB.Name
aWBname = oWB.Path & "\" & aWBname
Application.DisplayAlerts = False
aWB.Close savechanges:=False
oWB.SaveAs Filename:=aWBname
Application.DisplayAlerts = True
oWB.Close
--
HTH,
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
SaveAs error handling	jnf40	Excel Programming	1	August 31st 06 08:46 PM
error with saveas....	jeramie[_2_]	Excel Programming	2	March 13th 06 10:38 AM
SaveAs causes 0x800A03EC error	Justin Young	Excel Programming	0	May 25th 05 06:29 PM
SaveAs Error	Steven K	Excel Programming	1	September 17th 04 05:41 PM
Error on SaveAs Macro	Kevin	Excel Programming	1	December 3rd 03 03:58 AM

All times are GMT +1. The time now is 09:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us