Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I currently have code that when the macro is executed, allows the user to
choose the file needed to write data to. I wrote it this way as I will be sending the file out to multiple locations and cannot control where the user may place the file. Here is the code that allows the user to choose the location and filename: Do fName = Application.GetOpenFilename Loop Until fName < False Set BonusFile = Workbooks.Open(Filename:=fName) What I would like to do is have the user, on first use of the macro, go to the location where they initially saved the file and open it, but then have a message box open and ask the user if they would like to save this path and filename as the default location and filename. If they answer yes, the macro would save the specific path to the file and then specific filename in the macro and have the macro use this path and filename in the future without the user having to open the file manually again. There would probably need to be a trap so that if the file is renamed or moved after the location is created, the macro would go back to letting the user once again choose the location and file, but when chosen, would then ask if the user wants to set the path and filename again. Can you help with this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using filename retrieved from GetOpenFilename | Excel Discussion (Misc queries) | |||
Separating Location and Filename in a cell | Excel Worksheet Functions | |||
"the file already exsists in this location do you want to replace. | Excel Discussion (Misc queries) | |||
Formula to replace invalid filename characters | Excel Worksheet Functions | |||
Find & replace a value in an unknown cell location | Excel Discussion (Misc queries) |