Hi,

Im trying to write a piece of code which will open a txt file. the following code works for the first part of what i am trying to do:

Workbooks.OpenText Filename:= "C:\VisionMate Database\Rack_1_20040715-105339_.txt"

The file location can vary and the actual path to the correct file is stored in cell A1 in sheet1 in the workbook. How do i replace the filename in the code above to read the file path that is stored in cell A1.

Anyhelp will be greatly appreciated!

Thank you