I have fuel meteres at unattended sites where my customers dispense fuel. I
am wanting to gather the meter readings on a spread sheet. I then want to
reference to that sheet comparing it to later readings to determine the
amount of fuel dispensed. I can make it work by entering formulas in the
spreadsheet, but when I try to make the formula accept the file name I
generate by entering the date, it doesn't work.

=+B6-[10.28.2005.xls]Sheet1!B6..

I've tried building the file name "10.28.2005" but it will not work in the
formula.

Any help I could get with this would be most apprecaited...

Thanks
NJ