VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

**bensox** · 08-30-2012, 07:20 AM

Hi, new comer to VBA here - I have created a macro that navigates through a website but I can't get the macro to open or save the download (a csv file) when the 'Open or Save box' appears, please could anyone provide me with an example code/expression? Would the source code from the website in question be relevant to this?

**Kyle123** · 08-30-2012, 08:03 AM

It would be helpful, certainly. Do you have to log into this website?

**bensox** · 08-30-2012, 08:33 AM

Kyle123, Yes the website does need a username and password. I have managed to add these into my code so that it logs in automatically (attached image shows a screen shot of where the macro gets to - its the Open that I want to 'click'). I have attached the source code to this reply - I'm not actually sure if the website manages the download or my internet browser (Naïve, I know

)

Screen shot where current macro gets me to.png
Source code for website.txt

**Kyle123** · 08-30-2012, 08:52 AM

Ok what's the link/button you press to initiate the download from the site - can you post the source here.

It isn't in the text document you uploaded, the table is loaded separately from the source data

**bensox** · 08-30-2012, 09:26 AM

Kyle123, thanks when I hover over the download to csv button I see

Please Login or Register  to view this content.

- does this work for you?

**Kyle123** · 08-30-2012, 09:58 AM

ok, just for sh*ts and giggles, try this, just a hunch. You'll need to fill in your username and password as well as set a location for where you want the csv saving

Please Login or Register  to view this content.

If this doesn't work we'll try and battle through ie

**bensox** · 08-31-2012, 03:57 AM

Morning Kyle, when I run the code you provided I get "Run-time error '3001' (Arguments are of the wrong type, are out of acceptable range, or are in conflict..) - this is at the

HTML Code:

.
Please could you check?

**Kyle123** · 08-31-2012, 04:01 AM

It's difficult for me to check since I can't access the site

Try this:

Please Login or Register  to view this content.

edit- Did you add in your username and password?

EDIT - EDIT - actually scratch the above, just try changing:
Dim resp As String to Dim resp() As byte

**bensox** · 08-31-2012, 05:38 AM

Brill, that works a treat! Thank you for your speedy and knowledgable help.

**Kyle123** · 08-31-2012, 05:40 AM

Glad it's working

VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Re: VBA code to 'click' Open in the Open or Save dialogue box on a webpage?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions