Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I automate the saving of a worksheet?
I want to automate an excel spreadsheet with a Macro. The macro I currently have in the sheet is asking the user if he/she wants to save the worksheet. If user indicates yes, I want to save the sheet but only using the information that is in cell A1 (the information in this cell is different everytime the user opens the document) Thanks in advance for any comments!!! -- maacmaac ------------------------------------------------------------------------ maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=465783 |
#2
|
|||
|
|||
I would think your macro would contain something like:
with activeworkbook .SaveAs Filename:="c:\yourpath\" _ & .worksheets("sheet1").range("a1").value, _ fileformat:=xlWorkbookNormal end with But it would depend on what's in A1, too. But remember that there are characters that are not allowed in a filename (slashes come to mind). maacmaac wrote: I want to automate an excel spreadsheet with a Macro. The macro I currently have in the sheet is asking the user if he/she wants to save the worksheet. If user indicates yes, I want to save the sheet but only using the information that is in cell A1 (the information in this cell is different everytime the user opens the document) Thanks in advance for any comments!!! -- maacmaac ------------------------------------------------------------------------ maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=465783 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Keeping Worksheet tab colors when saving as web page | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |