Hi. I have a workbook with a table that is updated daily with a row of figures. The first column of the table contains specific dates relating to the financial year. The table is used by another worksheet to vlookup data for a range of dates such as a fiscal month. I'd prefer not to add new data (e.g. for a new day) by simply inserting a blank row. The file that I extract the data from (e.g electricity, gas, steam meter readings) is a DBF file. The DBF file has a different name each day e.g 2003 02 14 0000 (Wide).DBF I've managed to create a macro (using a string denoting the file path and date as file name etc.) to open up the relevant DBF file but the only way I can get it to run is by changing the long date format on the global settings of my computer to match the date and time format of the DBF file e.g yyyy mm dd hhmm. So far as the macro is concerned I'm having trouble in changing the dim date property to match VbLongdate. Is there anyone who can help please. Many thanks in anticipation.