#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default saving

apply office 2003 changes to memory stick & hard disk at the same time
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default saving

Sub BUandSave2()
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="G:\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Edit for your mem stick drive letter.

Mine is G:


Gord Dibben MS Excel MVP

On Tue, 17 Jul 2007 23:58:01 -0700, rouna
wrote:

apply office 2003 changes to memory stick & hard disk at the same time


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Saving fak119 Excel Discussion (Misc queries) 1 August 28th 06 08:36 AM
Saving help Murhfeeh56 Excel Discussion (Misc queries) 0 June 21st 06 12:10 AM
Saving gregory.barrett Excel Discussion (Misc queries) 0 March 13th 06 10:29 PM
Saving a sum fishy Excel Worksheet Functions 1 May 19th 05 04:47 AM
Saving Jason Zischke Excel Discussion (Misc queries) 1 March 23rd 05 04:19 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"