Working with files in directory...
 

Hello,

I need write VB script like that:
I have a directory with some worksheets. I need open first do something
close, then open second do something close, then ...
So I know path of a directory and I just need open gradually all worksheets
in this directory (I dont know names and I dont know count of ws).

Can you help me?

thanks a lot Tom

Working with files in directory...
 

Hi Tom

Look here for a example
http://www.rondebruin.nl/copy4.htm
Or
http://www.rondebruin.nl/copy3.htm

If you need more help post back

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


"Tom" wrote in message ...
Hello,

I need write VB script like that:
I have a directory with some worksheets. I need open first do something close, then open second do something close, then ...
So I know path of a directory and I just need open gradually all worksheets in this directory (I dont know names and I dont know
count of ws).

Can you help me?

thanks a lot Tom