Activating CSV window

[Matt]

Hi

Having a problem activating a csv file, the file is open but I'm getting a "subscript out of range" error when the code runs.

Windows("Exercise Data.csv").Activate

When I manually go through the process there is no problem.

Any ideas?

Thanks

Matt

 

[Ivan F Moala]

On 2002-09-06 05:24, Matt wrote:
Hi

Having a problem activating a csv file, the file is open but I'm getting a "subscript out of range" error when the code runs.

Windows("Exercise Data.csv").Activate

When I manually go through the process there is no problem.

Any ideas?

Thanks

Matt

Matt try Windows("Exercise Data").Activate