+ Reply to Thread
Results 1 to 3 of 3

open files by VBA

  1. #1
    Registered User
    Join Date
    11-04-2016
    Location
    US
    MS-Off Ver
    general
    Posts
    3

    open files by VBA

    Hello,

    i am trying to open an exist file but i want to open it inside a certain workbook (which i create it in before ) and also ( inside a certain sheet)

    Please how can i do that

    because the most of methods which i've tried that creating a new workbook to open the file but i don't want that.

    Thanks in advance
    Moelsayed

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: open files by VBA

    Tried to import the file? See the Data tab on the ribbon.
    If it's a textfile that's pretty easy.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    274

    Re: open files by VBA

    Any clue as to what type of file you are trying to open, i.e., Workbook, Text, CSV, etc.?

+ 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] Open excel files, copy sheet 1 to new location and close original files
    By ghostly1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2015, 11:48 AM
  2. macro to open files and copy specific sheet into new workbook (have open files part)
    By dangerdavedsp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2015, 02:23 PM
  3. Replies: 0
    Last Post: 04-13-2013, 10:45 AM
  4. [SOLVED] Open all files in a SharePoint folder (Problem: Files open out of order)
    By holmstarrunner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 10:13 AM
  5. Replies: 1
    Last Post: 01-31-2012, 09:07 PM
  6. A Macro to open 2 linked files copy 3rd files Input sheet
    By barrha0b in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2010, 09:53 PM
  7. Macro to open *.dat files and save as .txt (comma delimited text files)
    By YehWei@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2005, 01:55 AM

Tags for this Thread

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