Opening an Excel Spreadsheet from Access with VBA
Hi Brad,
Try objExcel.enableEvents=false before opening
Put to true again when finished
Regards
JY
"Brad" wrote in message
ups.com...
Thanks Andi
I didn't want any of the links/references to update though.
If I run the code above in Excel with UpdateLinks:=0 I still see values
in my column but if I run it in Access I lose the values....
|