+ Reply to Thread
Results 1 to 2 of 2

VBA - How to Login to a Website and get CSV file

  1. #1
    Registered User
    Join Date
    12-20-2021
    Location
    Germany
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    1

    Question VBA - How to Login to a Website and get CSV file

    Hi all,

    for a daily work report I need to login to an internal Website and download a csv file. The code below is working for other websites without any login data. Can anyone help me with my issue?

    Please Login or Register  to view this content.


    Thanks in advanced

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: VBA - How to Login to a Website and get CSV file

    This is code that I used to login to a site and download a file. The name of the objects and data fields need to be found - use "Examine code" on the page where you login.... It may be complicated by needing to automate clicking the save button in a pop up window.

    You could also talk to your IT department and have them run a script that copies the file into a folder every day, where you can just grab it.

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automate website login where the website only allows manual input of username/PW
    By whiterabbit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2018, 12:00 PM
  2. Website login popup comes up blank in VBA "edit web query" - webpage login problem
    By GaryTheGolfer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2016, 05:08 PM
  3. Login into website
    By jharaldson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2013, 10:55 AM
  4. [SOLVED] VBA to Login to website
    By IanHyman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 03:27 PM
  5. Using vba to login into a website
    By Jack7774 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2013, 11:35 AM
  6. website login through vba
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2012, 09:32 PM
  7. Website login help
    By davemaddocks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 10:59 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1