Consulting

Results 1 to 3 of 3

Thread: [VBA] Reading a file from the server

  1. #1
    VBAX Newbie
    Joined
    Aug 2012
    Posts
    1
    Location

    [VBA] Reading a file from the server

    Hi,

    As in VBA (without additional controls full VB) to read the contents of the file set on the server?
    eg file.txt to domain.com

    Or, how to check whether a file exists on the web site?

    Thank you for your help

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location

  3. #3
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,645
    [VBA]
    sub snb()
    msgbox createobject("scripting.filesystemobject").opentextfile("\\domain.com\file. txt").readall
    end sub
    [/VBA]

Posting Permissions

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