Macro Halt

[DeborahP]

I have a macro that imports a file from Excel and adds the data to an exisiting table. The macro has worked for years. Last week, our wonderful IS department rebuilt several computers and now the macto will not PASTE APPEND in the existing table. WHY??? Is there a reference missing?

Please provide any suggestions.

Thanks,
Deborah

 

[jfgambit]

Check your References under Module Design...Tools

Is the Microsoft Excel 9.0 Object Library checked?

Not sure if this will help, but its a start.

Also, check the path where the file exists, did the wonderful IS people change, rename or moce a directory??