Best way to obtain File name

I am writing code that opens up other workbooks and copy/pastes the charts into my original workbook.

Currently, my code looks like this

Please Login or Register  to view this content.

This is problematic, as if the length of the file name ever changes, my macro won't be able tot open the file properly. Is there a better way to do this?

My thought was, maybe theres some way to associate the file location with a wildcard, e.g.

Please Login or Register  to view this content.

where the wildcard is the file name, then I could say

Please Login or Register  to view this content.

where the wildcard is the EXACT wildcard from GrabFileLocation.




This is just a thought on how to best call a filename. If anyone has a better idea, please let me know. Thanks!

Why are you truncating what's returned from Applicaton.GetOpenFilename?

You need the whole path and filename to open the file.

Why not just open the file with the entire string returned from GetOpenFilename?

If you want to get the filename sans path then there are various ways, here's one.

Please Login or Register  to view this content.

Where do you get that error?

If it's in subsequent code then I would suggest you create a reference to the file when you open it and use that when you want to refer to the file rather than trying to use the name.

For example.

Please Login or Register  to view this content.

Actually the (MRB) is a typo.

This is how the code should look,

Please Login or Register  to view this content.

and with that you could then use the reference MRB like this in the rest of the code.

Please Login or Register  to view this content.

Probably best to start a new thread.