Results 1 to 19 of 19

Search & copy data from any of 100 columns in closed WorkBook without opening it

Threaded View

  1. #1
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Red face Search & copy data from any of 100 columns in closed WorkBook without opening it

    Hi everyone,

    I urgently need a kickstart with VBA code.

    With value from a cell in Active Sheet, Search & Copy data from any of 100 columns in closed WorkBook without opening it, and then paste it to nth row of Column x in Active Sheet.

    Any help will be greatly appreciated!!
    Last edited by Winon; 12-13-2011 at 08:27 AM.

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