+ Reply to Thread
Results 1 to 3 of 3

File import - select file and import sheet(1) from closed workbook

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    382

    File import - select file and import sheet(1) from closed workbook

    Hi!

    I am currently fighting with an import from a closed workbook. I am trying to open a closed workbook via from the filepicker and then have it copy all cells from the first sheet into my currently open workbook. once done, close the selected workbook again.

    However, I am struggling with switching back and forth from the newly opened workbook and the master one. Anyone mind giving me a hand on making this work properly without having to use the workbook filenames please?

    Please Login or Register  to view this content.
    Thank you very much,

    A2k

  2. #2
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    382

    Re: File import - select file and import sheet(1) from closed workbook

    ok, after putting some more efforts into this, i found a solution which is bringing me closer to my target, but still doesnt work due to definition problems with the master workbook and the newly opened one.

    Please Login or Register  to view this content.
    Any help is much appreciated!
    Thanks,

    A2k
    Last edited by Armitage2k; 08-22-2011 at 01:33 AM.

  3. #3
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    382

    Re: File import - select file and import sheet(1) from closed workbook

    ... i hate syntax and VBA for not pointing at it....

    code works now, thanks for no help -_-
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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