| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save Workbook
Hi I want to create a macro that Saves the workbook with the value of cell.. However I want the user to be able to choose the destination but not the filename. How can I do this? And it would also be great to set a defult save folder for the user. i.e. When the user saves the document through my macro, it then save the chosen destination folder, and stores this for next time the macr runs... So next time he wants to save, it automatically chooses this folder.. -- Ctec ----------------------------------------------------------------------- Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774 View this thread: http://www.excelforum.com/showthread.php?threadid=52955 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Using interop.excel to open a workbook, the workbook doesn't ask to save changes. | Excel Programming | |||
| Help on Workbook close and workbook save events | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
![Ctech[_135_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
