Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have found that on my computer it works fine but on the new computer it
does not. here is the code. I feel that it must have to do something with the security settings? I can prdoduce this error by this code. Private Sub CommandButton1_Click() fsindex = "http://xxxxxxxxxxxx:8508/passthru/consumer?name=FS%20-0869-0028" ActiveWorkbook.FollowHyperlink Address:=fsindex, NewWindow:=True ActiveWindow.WindowState = xlMaximized End Sub "Nick Hebb" wrote: I don't think it's a macro problem. I think it's because you are opening an Excel file that isn't on your computer. Have you ever clicked on an Excel or Word document link on the internet? It gives you the option of saving it or opening it directly. If you open it directly, you'll get the prompt you described above. It sounds like Excel 2003 doesn't think the network server is in the trusted zone. One possible workaround would be to change the script to: - copy the file to a local directory - open the local copy - make the changes - save it back to the original directory If you can't solve this another way, it's worth a shot. ----- Nick Hebb BreezeTree Software http://www.breezetree.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |