| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as
What is wrong with the following line of code?
I would like it to save a copy of the current workbook to the directory listed with the name as todays date formatted dd-mmm-yy TIA ActiveWorkbook.saveas ("C:\Documents and Settings\ThoemmE1 \Desktop\Shares\Web Query Data\UK Shares by Sector\" & Format(Date, dd-mmm-yy) & ".xls") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
| Save As - Multiple Sheets fails to save as text file | Excel Programming | |||
![Edgar[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
