LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default VBA problem

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colon at the end of excel file name(ex: problem.xls:1, problem.xls financeguy New Users to Excel 2 January 15th 10 01:15 AM
Started out as an Access problem. Now an Excel problem RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM
problem with a conditional max problem Brian Cornejo Excel Discussion (Misc queries) 1 February 18th 05 06:25 PM
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? OCI Excel Programming 0 May 16th 04 10:40 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"