VBA Excel opening a file

[rjenkins5]

Hi I am trying to open up a workbook based on a cell path.

How do I do this. The reason I have it in a cell is because part of the file name will change each month.

Thanks

Ross

 

[Ruddles]

If the path is in A1 and the filename is in sFilename, then this should do it:-

Workbooks.Open (Range("A1").Value & "\" & sFilename)

If the filename is in A1 and the path is in sFolder, then this should do it:-

Workbooks.Open (sFolder & "\" & Range("A1").Value)

 

[Ruddles]

If the folder and/or the filename change each month in a deterministic sort of way - like maybe they're based on the date - then you could do away with having the value in a cell at all.

For example, if the filename is always in the format Timesheet for August 2011.xls, you could do:-

Workbooks.Open (sPath & "\Timesheet for " & Format(Now(), "mmmm yyyy") & ".xls)

If it's for a previous month, it's possible to subtract a month from the date without too much difficulty.

 

[rjenkins5]

Hi thanks for this. If file path and name are together I just do the following?

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

Thanks

Ross

 

[Ruddles]