Open file using path and filename data in cell

[ourmick]

Please
I would like to open files using the data in a single cell.
The cell contains both the file path and the file name. (which can change)

eg cell A1 contains the following

s:\emc1\2009877.csv

how do i open this file using a macro

Cheers
ourmick

 

[Richard Schollar]

Hi

It can be as simple as:

Workbooks.Open Range("A1").Value

 

[Azerty99]

How the heck? I wanted to know exactly this, and you post and answer in my time frame. The Matrix is at work again.

 

[ourmick]

Thanks Richard
Your code looks for the correct file but for some reason the file can't be seen.
It comes up with runtime error 1004 and says to check the name and path even though the file is definately there.
I am trying to open up a csv file from within excel, does need need any further code??
Thanks

 

[Richard Schollar]

Shouldn't need anything else. What happens if you go to the Immediate Window in the VBE (open up with Ctrl+G if it isn't open) and type in:

?Dir("s:\emc1\2009877.csv")

(or whatever value was in A1). If the file exists this will return the filename "2009877.csv".

 

[Kenneth Hobson]

You may need to qualify by worksheet or maybe even workbooks as well. Otherwise, it is working from the ActiveWorkbook and ActiveSheet.

Workbooks.Open Worksheets("Sheet1").Range("A1").Value

 

[ourmick]

Thanks
when i do this nothing is returned?
I've just open the file using normal excel "open" command no problem, just to double check the files ok
Thanks

 

[Richard Schollar]

If you are getting nothing returned by Dir then it suggests that whatever you have in A1 is not a valid path/filename. Check it very carefully against the file's path/name in Explorer.

 

[ourmick]

Sorted!
It was the formatting of the data in the reference cell that was wrong
Cheers for the help