| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set a macro in excel to save to a web site
Hi there,
I have a macro which saves my workbook to a web site and send me an email notification this is done. What I am going to need however is to have the file name change each time it is saved to my location so it is not being overwritten before I can pull the information. Any ideas would be greatly appreciated. Thanks, Mary -- MT |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a macro in excel to save to a web site
have the macro do a saveas and give it a unique name.
-- Regards, Tom Ogilvy "Mary Thomas" wrote: Hi there, I have a macro which saves my workbook to a web site and send me an email notification this is done. What I am going to need however is to have the file name change each time it is saved to my location so it is not being overwritten before I can pull the information. Any ideas would be greatly appreciated. Thanks, Mary -- MT |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a macro in excel to save to a web site
Will that change the name each time a user opens the file and runs the macro?
I was thinking of adding a date or more than likely a number to the end of the filename that would change (advance or count) each time the macro runs. -- MT "Tom Ogilvy" wrote: have the macro do a saveas and give it a unique name. -- Regards, Tom Ogilvy "Mary Thomas" wrote: Hi there, I have a macro which saves my workbook to a web site and send me an email notification this is done. What I am going to need however is to have the file name change each time it is saved to my location so it is not being overwritten before I can pull the information. Any ideas would be greatly appreciated. Thanks, Mary -- MT |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a macro in excel to save to a web site
If you follow your idea and give SAVEAS such a filename (with date (and time
if it is done within the same day)), then yes, it will be saved with the new name. -- Regards, Tom Ogilvy "Mary Thomas" wrote: Will that change the name each time a user opens the file and runs the macro? I was thinking of adding a date or more than likely a number to the end of the filename that would change (advance or count) each time the macro runs. -- MT "Tom Ogilvy" wrote: have the macro do a saveas and give it a unique name. -- Regards, Tom Ogilvy "Mary Thomas" wrote: Hi there, I have a macro which saves my workbook to a web site and send me an email notification this is done. What I am going to need however is to have the file name change each time it is saved to my location so it is not being overwritten before I can pull the information. Any ideas would be greatly appreciated. Thanks, Mary -- MT |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a macro in excel to save to a web site
Ok, Thanks Tom, I thought that should work.
How do I format the date and time in the macro so that it changes each time? Mary -- MT "Tom Ogilvy" wrote: If you follow your idea and give SAVEAS such a filename (with date (and time if it is done within the same day)), then yes, it will be saved with the new name. -- Regards, Tom Ogilvy "Mary Thomas" wrote: Will that change the name each time a user opens the file and runs the macro? I was thinking of adding a date or more than likely a number to the end of the filename that would change (advance or count) each time the macro runs. -- MT "Tom Ogilvy" wrote: have the macro do a saveas and give it a unique name. -- Regards, Tom Ogilvy "Mary Thomas" wrote: Hi there, I have a macro which saves my workbook to a web site and send me an email notification this is done. What I am going to need however is to have the file name change each time it is saved to my location so it is not being overwritten before I can pull the information. Any ideas would be greatly appreciated. Thanks, Mary -- MT |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a macro in excel to save to a web site
Assume you will have a name like Mybook200607100830.xls (July 10, 2006,
8:30AM) sName = thisworkbook.Name sName = Left(sName,len(sName)-16) sDate = format(Now,"yyyymmddhhmm") Thisworkbook.SaveAs thisworkbook.Path & "\" & sname & sDate & ".xls" just do demo some of the code from the immediate window: sName = "Mybook200607100830.xls" sname = Left(sname,len(sname) - 16) ? sname Mybook ? sname & format(Now,"yyyymmddhhmm") & ".xls" Mybook200607251444.xls -- Regards, Tom Ogilvy "Mary Thomas" wrote: Ok, Thanks Tom, I thought that should work. How do I format the date and time in the macro so that it changes each time? Mary -- MT "Tom Ogilvy" wrote: If you follow your idea and give SAVEAS such a filename (with date (and time if it is done within the same day)), then yes, it will be saved with the new name. -- Regards, Tom Ogilvy "Mary Thomas" wrote: Will that change the name each time a user opens the file and runs the macro? I was thinking of adding a date or more than likely a number to the end of the filename that would change (advance or count) each time the macro runs. -- MT "Tom Ogilvy" wrote: have the macro do a saveas and give it a unique name. -- Regards, Tom Ogilvy "Mary Thomas" wrote: Hi there, I have a macro which saves my workbook to a web site and send me an email notification this is done. What I am going to need however is to have the file name change each time it is saved to my location so it is not being overwritten before I can pull the information. Any ideas would be greatly appreciated. Thanks, Mary -- MT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for Excel site similar to "The Word MVP Site" | New Users to Excel | |||
| Can a Macro open workbooks on a SharePoint Site? | Excel Discussion (Misc queries) | |||
| Access a internet Web Site uisng a macro done with excel | Excel Programming | |||
| Macro to go a WEB site and enter a password | Excel Programming | |||
| Save to FTP site through a macro | Excel Programming | |||
Linear Mode
