"Gina Whipp" <No***********@InViruses.com> wrote in message
news:eF**************@TK2MSFTNGP12.phx.gbl...
Just curious did you check your References... I got caught on that
yesterday and as it turned out, I did have a reference issue. (I use
similar coding to open Word and don't have any problems.)
Yup, umpteen times. Set and reset. As a matter of fact the code I posted
uses late binding, so refs shouldn't be an issue should they? In fact in the
actual code I use early binding, but it has exactly the same result. I tried
every single way I could think of of resetting the refs. Unselecting them,
browsing to the directory where the library lives, etc. etc. Also I got the
same result in a brand new mdb which was created with the libaries as they
are - cause I know you can get problems if you compile one machine and then
run on another machine where the libraries are in a different place.
Although it would appear to be a refs issue I'm really not sure it was. But
then who knows? As I said it works now I've uninstalled Norton Internet
Security.
Cheers, Mike