Using GetOpenFilename

[treva26]

I have a macro where I use this to open a file:

FName = Application.GetOpenFilename

Later in the macro I need to activate the window of that file again (after activating another one) with this:

Windows("im453.txt").Activate

How can I use the FName variable to do it without hard coding the name?

I think the problem is that the FName contains the full path, so how do I delete the left characters of FName up until the last "\" and call it FName2?

[rylo]

Hi

It may be easier to create another variable and populate it when the workbook is opened.

So if you use Fname when you open the required file, then immediately it is opened do something like

Please Login or Register  to view this content.

You can then use Fname2 to activate that workbook at some later time.

HTH

rylo

[treva26]

Brilliant, thank you so much