Problem in Passing URL to Browser

[PraveenKadkol]

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]

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)

[PraveenKadkol]

Thanks NICO I will try and will let you the know,

[PraveenKadkol]

Hi Nico5038,

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

5 stars for you......

[nico5038]

Glad it worked, success with your application !

Nic;o)

[PraveenKadkol]

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]

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)