Just so I know it is something that can be changed.
One of our servers when you go to export uses the IP address in the popup window. http://xxx.xxx.xx.xxx/qvprint/xxxxxxxxx.cvs.
So where the heck can you change that? :-)
Okay I found the problem and the solution.
In the registry:
There is a key "ServerTepURL " One of ours had the HTTP://ip address/Qvprint and the other just had http://ServerName/qvprint The one with just the server name wasn't the FQDN and dns didn't know what to do with it. Once we changed it everythign worked grea.
Use below macro to exort all the sheet objects on excel, just change sheet name with yours
'Export objs to excelTest
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
set s=ActiveDocument.Sheets("PG EIR")
for i=0 to s.NoOfSheetObjects-1
for i=1 to s.NoOfSheetObjects-1
str1 = "CH0" & i
if err.number > 0 then
msgbox "Error occured "