Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As B2
Hi
try: dim fname Dim fpath fpath="c:\Daily Group Summary Reports\" with activeworkbook fname=.worksheets("sheet1").range("B2").value .saveas fpath & fname end with -- Regards Frank Kabel Frankfurt, Germany Wonderful, Thanks Frank. Also, how can i modify this to save in a particular folder. for instance: save as c:\Daily Group Summary Reports\fname or something... thanks. --- Message posted from http://www.ExcelForum.com/ |
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) | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |