Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Connection (2003)

    Dear all,

    I want to open an Excel file on a remote server. This server is protected by username and password.

    How can I connect - using VBA - to this Server, using an address like:

    173.45.22.3MyDir

    TIA

    Wolf

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Connection (2003)

    This code should do the trick (paste in normal module, check out last sub (OpenRemoteFileOnNetwork) for how to use:

    Very long piece of code moved to attachment by HansV
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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