A
Alan
I invoke GetOpenFilename() with the multi file select
option set to True. It should return an array, but I
receive a single string. The code is:
WorkBookL = Application.GetOpenFilename _
("Excel Files (*.xls), *.xls", , _
"Add Form to Report", , True)
It was returning an array earlier and working properly.
I use the file selector elsewhere in my application.
Could that cause a problem?
I also noticed the "ChDrive" and "ChDir" appear to work
on the first invocation for GetOpenFilename, but later
GetOpenFilename invocations will pickup where the
previous GetOpenFilename stopped. Is there a way to
specify the initial folder for each invocation of
GetOpenFilename?
thanks.
option set to True. It should return an array, but I
receive a single string. The code is:
WorkBookL = Application.GetOpenFilename _
("Excel Files (*.xls), *.xls", , _
"Add Form to Report", , True)
It was returning an array earlier and working properly.
I use the file selector elsewhere in my application.
Could that cause a problem?
I also noticed the "ChDrive" and "ChDir" appear to work
on the first invocation for GetOpenFilename, but later
GetOpenFilename invocations will pickup where the
previous GetOpenFilename stopped. Is there a way to
specify the initial folder for each invocation of
GetOpenFilename?
thanks.