vba to prompt to select all excel version files

[kiran5]

Hi everyone,
We use the below code to prompt a window to select all excel 2003version files for further consolidation etc...

Now we have to select all xls, xlsx & xlsm files consolidatiob

Please guide me as how can I include all the other extensions to show in the above code.

Thanks in advance for the lighr.

Rgds,
K

 

[kchiba]

Hi Kiran,

where is your code?

kanti

 

[kiran5]

z = application. getopenfilename (filefilter:= "Excel files (*.xls), *.xls", multiselect:=true)


Oops funny, I didnt even paste it!!!

 

[kiran5]

I got it... I just have to put * after xls


Thanks!

 

[kchiba]

Hi Kiran,

change the *.xls to

*.xl* in both cases

cheers

kanti