+ Reply to Thread
Results 1 to 2 of 2

Ler valores de um site da net que necessita de password

  1. #1
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Ler valores de um site da net que necessita de password

    I have a table of various investments and would like to know how I can put some cells to read data from a site that needs login to give these values.

    It's possible ? It's safe ? How do I do ???

    Thank you very much
    Last edited by Vinhas; 12-18-2019 at 12:14 PM. Reason: In Inglish

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Ler valores de um site da net que necessita de password

    Hi, welcome to the forum.
    I suggest you Google for this, there are many ways to link a a site and enter the needed credentials. It's as safe as your file if it's protected or others can simply read the username and password, these are NOT encrypted.
    So no, it's not safe but you can hide and lock all VBA code for viewing and editing with s strong password, it can be cracked but still, it will need some extra skills to do so
    Boa sorte
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. [SOLVED] GetData to password protected site
    By sick stigma in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2018, 10:25 AM
  2. VBA- Automate web query on password protected site
    By Analyst77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-11-2016, 03:01 PM
  3. Password automation for .RefreshAll when linking to FTP site
    By Muzza68 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2012, 03:36 AM
  4. Web Querying a Password Protected Site
    By alex0128 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2012, 03:32 PM
  5. Import from Password Protected Site
    By JennyT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2009, 06:59 AM
  6. Import Web Query from site with Password
    By dstein in forum Excel General
    Replies: 3
    Last Post: 04-16-2008, 11:41 AM
  7. [SOLVED] using strDb to connect Excel to an FTP site w/password
    By VBailey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2005, 05:05 PM

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