Opening of specific files
 

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,

Opening of specific files
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message ups.com...
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,

Opening of specific files
 

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

cheers'

BB


Ron de Bruin wrote:
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


--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message ups.com...
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,