Posted to microsoft.public.excel.programming

andycharger[_9_] andycharger[_9_] is offline

external usenet poster

Posts: 1

Code to automatically overwrite?

I need to save my spreadsheet as part of my macro. The trouble is, th
worksheet already exists. How can I automatically get my sheet t
overwrite?

This is what I was using:
[vb]
ActiveWorkbook.SaveAs Filename:="C:\LEXPM1a.xls"
FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False
_
CreateBackup:=False
[/vb

--
Message posted from http://www.ExcelForum.com

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
VBA to automatically test for file, update, overwrite	Brent E	Excel Discussion (Misc queries)	3	October 22nd 08 11:00 PM
Automatically starting code	Richard	Excel Worksheet Functions	3	February 8th 06 02:33 AM
Automatically running code	Richard	Excel Worksheet Functions	1	February 7th 06 09:35 PM
Running Code Automatically	Bruno[_2_]	Excel Programming	2	January 31st 04 06:26 AM
VBA code to automatically close file	Kevin	Excel Programming	4	November 6th 03 04:18 PM

All times are GMT +1. The time now is 09:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us