Need help for VB on Excel

Valfdum
05-30-2008, 01:09 AM
Hi,
My name is Flavien, i'm a french student (that's why i don't speak english very well, and maybe why i didn't post in the right forum.. ?! :o ) and i'm using VB on Excel in a work experience.
In this training, i have to modify a "Macro" and my problem is that i don't succeed a task.
In summary, i have a window opened with different types of files to open (here: ".txt", ".ascii") and i would to only have this sort of files: ".txt" and "_2.ascii" to open.
So in my window i just want to see "filename.txt" and "filename_2.ascii".
I don't know if i'm really clear but do you have codes for that??? :-\ :(
Please help me, i'm a looser! :rolleyes:
Thx very much guys:chuckle:

Colin Legg
05-30-2008, 03:27 AM
Hi Flavien and welcome to the forum. :)

Please be sure to read the posting guidelines (http://www.xtremevbtalk.com/faq.php?faq=evbf_faq#faq_evbf_rules).

In your Excel VBA helpfile, look up the GetOpenFilename Method and pay particular attention to the FileFilter argument. ;)

Colin

Cas
05-30-2008, 05:50 AM
Note, however, that the standard dialog only lets you filter on the extension, not part of the file name, so "*_2.ascii" is rejected. If you could change the naming scheme to "*.2.ascii" it would work, but I'm guessing that's out of your hands? :-\

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum