with files

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Your code not pass ..
in:Filenames = Application.GetOpenFilename("test files
(test.*),test.*", , , True)
occur run-time error 1004:
Method 'GetOpenFilename' of object ' _Application' failed.
info:
I've files test.* in the same folder.
What doing GetOpenFilename?
i've excel and win 2k.
Regards
Mark
 
Mark,
It seems that function Excel function does not support using wildcards in
the extension. If you cannot get it to work, the API route will work.

NickHK
 
just skip the filter part in getopenfilename
-----Original Message-----
Your code not pass ..
in:Filenames = Application.GetOpenFilename("test files
(test.*),test.*", , , True)
occur run-time error 1004:
Method 'GetOpenFilename' of object ' _Application' failed.
info:
I've files test.* in the same folder.
What doing GetOpenFilename?
i've excel and win 2k.
Regards
Mark

.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GetOpenFilename ERROR 3
Application.top=0 fails 3
Chdir does not seem to change the current directory -- ?? 5
Problem with "Application.Goto Reference" code line 4
GetOpenFilename returns a string rather than an array 9
Run time error 2
Unexpected Error 3
GetOpenFileName bug 5

Back
Top