Looking for an open .csv file

Hi everyone,

I'm trying to write a macro that will swap from Excel to an *open* CSV file, and copy its contents into the current spreadsheet.

The CSV file doesn't have a fixed location, or have a fixed file name, so I can't simply loop through files in a folder, or call the filename directly.

I was hoping to use:

Please Login or Register  to view this content.

but it seems like the CSV file isn't counted as a Workbook.


I could get the user to save the CSV file somewhere fixed, but I want to try and make it user-interaction free as possible.


If it helps, the CSV file will be the only one open (i.e. there is no chance of getting mixed up between two) and it's file name will always begin with "LM".


Any ideas?

@Leith - alternatively, perhaps the CSV opens in another instance of Excel?
He might be able to find it through Excel.Application, but without knowing the full name, I don't know how to loop through the instances. Can you help?

The CSV file opens in Excel.

If I reference the file name directly, it works fine, however I have no control over what the file name will be other than beginning with "LM"

Ryan

So I don't think the different instance of Excel is the problem, they both show up in VBA:

Untitled.png

I made the little program shown in the screenshot to practice, but it returns "Cut Pad Price Calculator v4.23 PRO" twice, and that's it.

I've tried @Leith's code:

ActivateInstance 0 (Nothing happens)
ActivateInstance 1 (Nothing happens)
ActivateInstance 2 (Last active window maximizes)
ActivateInstance 3 (Out of range error)

Can I target an open file using *.csv?