+ Reply to Thread
Results 1 to 2 of 2

Open Https excel file giving user and password

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    México
    MS-Off Ver
    Excel 2007
    Posts
    1

    Open Https excel file giving user and password

    I want to open an excel file from https giving user and password, without popup asking for user and password, I amd using this code:

    strFileName = "https://a.b.net/sites/xyz/File1.xls"
    Set wbFile = Workbooks.Open(strFileName)

    Thanks in advance

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Open Https excel file giving user and password

    Welcome to the forum.


    Note to other Mod: Copy is in the proper subforum now thanks.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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. Open workbook from vba with password if another user is in file
    By jvbeats in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2013, 09:52 AM
  2. Replies: 2
    Last Post: 01-19-2013, 09:13 AM
  3. Show/hide sheets on file open based on user password
    By allar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2011, 12:41 PM
  4. Replies: 0
    Last Post: 04-26-2006, 10:25 PM
  5. excel hangs after giving File Open
    By Harpinator in forum Excel General
    Replies: 1
    Last Post: 04-20-2006, 12:40 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