Consulting

Results 1 to 2 of 2

Thread: Simple code that refreshes link to another excel file with Password

  1. #1

    Simple code that refreshes link to another excel file with Password

    Hello,

    I have a code that opens other files in order to update links. There is one password also.
    See below:

    Sub OpenTheTemplate()
    Dim filename As String
    Workbooks.Open (ThisWorkbook.Path & "" & Range("x16").Value & ".xlsx"), Password:="BT2023", writerespassword:="BT2023"
    End Sub

    I was wondering if there is one existing that just "refreshes" links instead of opening the files each time

    Many thanks for help :-)
    Last edited by Aussiebear; 11-24-2022 at 01:05 PM. Reason: Added code tags to supplied code

  2. #2
    VBAX Regular
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    35
    Location
    How to attach file: How to upload your attachments (vbaexpress.com) To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Posting Permissions

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