Object required (Error 424)

[Adrianna]

I don't know why I'm getting this error. maybe it's because I'm trying to do something last minute. I was just going to shut the warnings off in my Macro, but my brain is to foggy and I can't seem to remember how to get that to work. I thought I could just RunCode (DoCmd.SetWarnings = False) and they would be off.....so I'm writing the import and update query into my VB, but I keep getting this darn error:

Object required (Error 424)

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "COOPtbl1", COOPtbl.xls, True, ""

Any ideas?


Oh yeah...and all of the links for the procedures to combine an append and update macro into a single update query are all dead links. If anyone wants to refresh my memory...I'd appreciate it!

 

[pdx_man]

Access is currently looking in your default folder for the file. I would fully qualify the path to the XL file and make sure that I had it within double quotes:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "COOPtbl1", "C:\MyXLFiles\COOPtbl.xls", True, ""