Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro (can do a save as.
Hello could some one please tell me if it is possible to get a macro to do a "Save As" . What it will have to do is save as a given date which will be at all times in cell B1. I can get macros to do most things but I have yet to learn how to do a save as. Thankyou Paul Maynard -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=501004 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro (can do a save as.
Hello Paul,
Just use ActiveWorkbook.SaveAs HTH Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro (can do a save as.
Carim Wrote: Hello Paul, Just use ActiveWorkbook.SaveAs HTH Carim Hello Carim I know this may sound like a stupid question, but when say use the ActiveWorkbook.SaveAs are you referring to File/SaveAS? -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=501004 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro (can do a save as.
What he means is that in a sub-routine or a function:
public Sub SaveMe() ActiveWorkbook.SaveAs end sub This sub-routine will prompt the user for the name and location in which to save the current workbook. I do not have access currently to VBA help files, but there are some other things you can add at the end of the SaveAs feature that will allow you to name the file with todays date and remove the user interaction in naming the file. But you have to be 100% sure of where you want to store your files as compared either to the current location of the workbook that is doing all the grunt VBA work, in relation to the current users system setup, or the network that the file(s) are being stored on. "paulrm906" wrote: Carim Wrote: Hello Paul, Just use ActiveWorkbook.SaveAs HTH Carim Hello Carim I know this may sound like a stupid question, but when say use the ActiveWorkbook.SaveAs are you referring to File/SaveAS? -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=501004 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro (can do a save as.
Hello Carim I am no expert when it comes to actually writing a macro but I will give it a go. So again thankyou very much for your help and support. Paul Maynard QUOTE=GB]What he means is that in a sub-routine or a function: public Sub SaveMe() ActiveWorkbook.SaveAs end sub This sub-routine will prompt the user for the name and location in which to save the current workbook. I do not have access currently to VBA help files, but there are some other things you can add at the end of the SaveAs feature that will allow you to name the file with todays date and remove the user interaction in naming the file. But you have to be 100% sure of where you want to store your files as compared either to the current location of the workbook that is doing all the grunt VBA work, in relation to the current users system setup, or the network that the file(s) are being stored on. "paulrm906" wrote: Carim Wrote: Hello Paul, Just use ActiveWorkbook.SaveAs HTH Carim Hello Carim I know this may sound like a stupid question, but when say use the ActiveWorkbook.SaveAs are you referring to File/SaveAS? -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=501004 -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=501004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
Save As Macro | Excel Programming | |||
Prompted to save changes after macro save - why? | Excel Programming |