+ Reply to Thread
Results 1 to 1 of 1

Is it possible to write macro to access multiple workbook in a directory

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Red face Is it possible to write macro to access multiple workbook in a directory

    Hi all,

    new to VBA, help needed

    I need to search for text in multiple workbooks, The problem is file names of excel sheet change, is there some way to make excel to refer to workbook without using their names. Then the text I want to search is arranged as list in a column, i want excel to take up one value at a time and search it in all workbook, if a match is found i want it to copy paste the the value in the same row(next row value) to column next to text in master workbook.

    I could not find out examples for my requirement, i have seen a macro in which workbook can be accessed by using file path and assigned to workbook variable, by referencing to the workbook variable a search can be performed, in my case i have search for text in multiple workbooks and workbook numbers and file name will vary.

    I am not able to figure out coding for this...
    Last edited by Manoj Vasanth G; 04-11-2014 at 02:25 AM. Reason: trying to explain my requirement more better

+ 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. Multiple user write access to an Excel 2010 file
    By musik7 in forum Excel General
    Replies: 1
    Last Post: 03-21-2014, 01:24 PM
  2. [SOLVED] Macro to Import Multiple TXT Files into workbook - User to select files/directory
    By saber007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2013, 08:43 PM
  3. Macro To Save Worksheet into same directory as workbook
    By SilverFox in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2011, 07:32 AM
  4. [SOLVED] Unshared workbook allowing write access to more than 1 user
    By al_mac75@yahoo.com in forum Excel General
    Replies: 0
    Last Post: 08-02-2006, 10:20 AM
  5. Multiple Write Access Enable for Excel
    By ravenshroud@gmail.com in forum Excel General
    Replies: 3
    Last Post: 09-23-2005, 03:05 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