Opening file with file path and partial name

[bocaj315]

I have a Macro that opens specific workbooks, copies data from them, and pastes it into a master workbook. The problem is that the names of the workbooks I need to open will constantly change; however, the last few letters will always be the same. For example, I will have workbooks 130058_IP.csv 130059_IP.csv

I was wondering if there is a way to open a workbook using its file path and "_IP.csv"

ANy help would be great!

[patel45]

the workbook with macro must be in the same folder of csv files, otherwise you have to change .InitialFileName

Please Login or Register  to view this content.

[bocaj315]

Thanks, is there a way to open it without prompting the user to do so?

[daverunt]

I found this works for me. (But doesn't if I try and do it all in one line of code.)

Please Login or Register  to view this content.

[bocaj315]

It prompts an error saying it can't open it because it's read only or encrypted but I know its not.

[daverunt]

I don't know why that is.
Is there more than 1 file that fits the name?

[bocaj315]

well there's an _IP-STATS but I changed the file name to _IP-STATS so there would be no chance of a duplicate file but it still gave the same error

[bocaj315]

The weird thing is that the error says excel cannot access '130058'. The document may be read only or encrypted

[daverunt]

If you step through the code in the editor using F8 then hover over the filename what filename do you see?

[bocaj315]

it says it's empty, the filePath is there though

[daverunt]

I don't know how much coding you do so don't be offended by stupid questions/suggestions.

Initially it will be empty. Step through to the Workbooks.Open line with F8 and then hover over the filename on the previous line. If it's still showing "" then it hasn't found a matching file in the directory.

[bocaj315]

Yeah I did and it's still showing empty. The file is there though so why is it saying empty. Could it be something with the syntax you used for

Please Login or Register  to view this content.

[daverunt]

OK I get the warning you stated previously re: encrypted/read only if I omit the last backslash in the filepath.

it must be "C:\junk\" <---backslash.

[bocaj315]

I'm using a different path which doesn't have a backslash at the end it still doesn't work

[patel45]

with path need backslash, otherwise you can not solve