Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetSaveAsFilename/GetOpenFilename
In my macro to save column data to disk, I use "FileName =
Application.GetSaveAsFilename(". The window comes up and the "File name:" box is blank. If I click on a file name, it moves over to the "File name:" box. Totally expected. In my macro to open a file and move data to a worksheet, I use "FileName = Application.GetOpenFilename(" The window comes up and the "File name:" box is blank. I click on a file name, and nothing..;( The box remains blank. Is there a fix for this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetSaveAsFilename/GetOpenFilename
I believe that the GetSaveAsFileName anticipates that the user will change
the file name and therefore sets focus on the name box so that a new name can be entered. Conversely, the GetOpenFileName anticipates that the user will click the Open button once a selection is made and therefore does not set focus to the name box since the selected file is highlighted and focus is set to the Open button. "Fan924" wrote: In my macro to save column data to disk, I use "FileName = Application.GetSaveAsFilename(". The window comes up and the "File name:" box is blank. If I click on a file name, it moves over to the "File name:" box. Totally expected. In my macro to open a file and move data to a worksheet, I use "FileName = Application.GetOpenFilename(" The window comes up and the "File name:" box is blank. I click on a file name, and nothing..;( The box remains blank. Is there a fix for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GetSaveAsFilename | Excel Programming | |||
GetSaveAsFilename | Excel Programming | |||
GetSaveasFileName | Excel Programming | |||
GetSaveAsFileName | Excel Programming | |||
GetSaveAsFilename | Excel Programming |