I have an Access Application which opens an Excel Workbook and performs an operation to open and run a worksheet.

It works fine on the local machine, but fails over the network with Access VBA.

But the same code for the network path works fine when ran directly from Excel VBA.

This is the network path used in both apps.

MySheetPath = "\\GunSlinger764\Development\DST\jtraylor\PackList\_packing-list-log-newtest2.xls".

Is there something special I need to do in Access to get this path to work.

Any and All help is appreciated.

The error Access gives is..

run-time error '432'

Filename or class name not found during Automation operation.

I have checked from both Access and Excel and the file does exist on that path for machine GunSlinger764.

Thanks

cplmckenzie