Connecting Tech Pros Worldwide Forums | Help | Site Map

Problem in Passing URL to Browser

Newbie
 
Join Date: Oct 2006
Posts: 14
#1: Jan 19 '07
I am facing probem in VBA while passing URL to a browser,

I am using below code to pass the URL, but my problem is in cmdline string I have 1351 characters, while running below code i am getting error message becuase, the maximum char it is passing is 1023, is there anyway i can fix this issue.


Application.FollowHyperlink cmdline


Thanks in Advance.

nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
#2: Jan 20 '07

re: Problem in Passing URL to Browser


Did you try to place a webbrowser control on a form and then:
me.webbroswer.navigate URL:=strYours

You can manipulate the control to open in a new form.

Just a thought, but max length can be a problem for a browser....

Nic;o)
Newbie
 
Join Date: Oct 2006
Posts: 14
#3: Jan 22 '07

re: Problem in Passing URL to Browser


Thanks NICO I will try and will let you the know,
Newbie
 
Join Date: Oct 2006
Posts: 14
#4: Jan 22 '07

re: Problem in Passing URL to Browser


Hi Nico5038,

Great It worked fine, thanks for the info it helped me very much.

5 stars for you......
nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
#5: Jan 22 '07

re: Problem in Passing URL to Browser


Glad it worked, success with your application !

Nic;o)
Newbie
 
Join Date: Oct 2006
Posts: 14
#6: Jan 25 '07

re: Problem in Passing URL to Browser


Hi NICO5038

Hope all is well

By using WebBrowser.Navigte Str I am downloading my source file , is it possible to save as the file automatically without any prompt message like open or Save message?


Thanks in Advance.
nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
#7: Jan 25 '07

re: Problem in Passing URL to Browser


Best to post a new Discussion/Question so others can have a look too.
Never tried this, I did use the document object to extract a selected string fom a page, but that's all I know.
For intercepting a download I'm afraid some system .dll's need to be used.

Nic;o)
Reply