Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having a problem using getopenfilename function. It runs OK the first
time, but when I go to re-run this routine it does not return an "array" and the routing does not run a second time. Can't figgure out the behavior. Has anyone seen this? ++++++++++++++++++++++++++++++++++++++++++++++++ fileToOpen = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , , , True) If IsArray(fileToOpen) Then ' if no files selected, then do nothing, otherwise, run the routines below ***** AND THEN I MANIPULATE THE DATA HERE ***** fileToOpen.Close End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming |