Opening of specific files

[b_abdelhamid]

Hi,

I am willing to create a procedure that opens specific .xls files from
a folder, for exemple all files with their name beginning with ABC
(file ABCblabla1.xls, file ABCblabla2.xls, etc...). Or maybe just
opening files whose name contain ABC. Could someone help me on that?

thx,

bigben,

 

[Ron de Bruin]

Hi bigben

You can adapt code you find here

Try
http://www.rondebruin.nl/copy3.htm

This example maybe
http://www.rondebruin.nl/copy3.htm#range2

 

[b_abdelhamid]

Thx Ron, this helps a lot! That is what I needed!

cheers'

BB