VBA Macro to pull data from secure website to excel

Tags:
Microsoft Excel
SAP SuccessFactors
VBA
I have code to pull general data from a website into Excel using a macro, e.g. yahoo finance quotes. But, is it a possibility to pull data from a secure website (one that requires login) to automate a report? The link provided was close, but I don't understand how to pass the parameters in. Also, when I run this I only get a dialog box with an "X" and nothing else... An edit: I am pulling from SAP SuccessFactors I can get the macro to pull a PDF, associated with a URL, but it won't grab an ad hoc Excel report. If anyone has any ideas that would be great!

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Post your code if possible so we can take a look. Strange that you say it can grab a PDF but not an XLS.
    84,910 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: