View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
 
Posts: 238
Default 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?