An automated database was made on a personal computer that is connected to a network.
Part of the automation requires Access to manipulate Excel by creating a new workbook, creating a new web query and parsing the data from the query.
There is error code in place in case the web query doesn't work (file doesn't exist, time-out, etc.)
On the personal computer, the code works fine.
The database was then moved to a server with the same OS and same versions of Excel/Access.
On the server, when an error occurs during the web query (file doesn't exist), an Excel event/error pops up (Http/1.0 404) and when the user clicks "OK", then the error code is ran (instead of having the created event/error ignored and having the error code run without "user input")
Anyone seen anything like this and know how to fix it? Is it an Excel option set on one computer that is missing from the other?
Thanks in advance,
FUBAR
Part of the automation requires Access to manipulate Excel by creating a new workbook, creating a new web query and parsing the data from the query.
There is error code in place in case the web query doesn't work (file doesn't exist, time-out, etc.)
On the personal computer, the code works fine.
The database was then moved to a server with the same OS and same versions of Excel/Access.
On the server, when an error occurs during the web query (file doesn't exist), an Excel event/error pops up (Http/1.0 404) and when the user clicks "OK", then the error code is ran (instead of having the created event/error ignored and having the error code run without "user input")
Anyone seen anything like this and know how to fix it? Is it an Excel option set on one computer that is missing from the other?
Thanks in advance,
FUBAR
