Can anyone spot why the below code is giving me an error?
Set rng = Workbooks("\\Michael\Trading\Fuel\Fuel_Data.xls"). Worksheets("Fuel
Data").Range("A1935:A4000")

Also, must the workbooks be open if i want to get the program to find a date
and get the corresponding data?