+ Reply to Thread
Results 1 to 9 of 9

Looping a proprietary Add-in to process multiple files

  1. #1
    Registered User
    Join Date
    10-07-2009
    Location
    Rhode Island
    MS-Off Ver
    Excel 2003
    Posts
    6

    Looping a proprietary Add-in to process multiple files

    I have a proprietary Add-in that processes a data file, but the Add-in can only process one file at a time. I have many files I need to process and it's too time consuming to do each one manually. Is it possible to write a macro to loop the Add-in so that it can process every file in a selected folder? I've never programmed in VB, but I have some experience in C++, MATLAB, and Python.

    This is the rough algorithm of what I'm looking to implement. I have no idea about the syntax I am supposed to use or where to even start the code. Any help is much appreciated

    1. Select folder containing files
    2. Loop begin
    3. Select file to process in Add-in
    4. Run Add-in
    5. Save and close file
    6. Increment to the next data file in folder
    7. Go back to step 3 until all data files in folder have been processed
    8. Loop ends

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Looping a proprietary Add-in to process multiple files

    Welcome to the forum.

    It would depend on the interface the add-in provides.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-07-2009
    Location
    Rhode Island
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Looping a proprietary Add-in to process multiple files

    Thanks. I'm not sure what you mean by the interface though. I can get into the Add-in's modules through the VBA Editor, but I really don't know what to do or what to look for once I'm in there.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Looping a proprietary Add-in to process multiple files

    Me either without seeing the code.

  5. #5
    Registered User
    Join Date
    10-07-2009
    Location
    Rhode Island
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Looping a proprietary Add-in to process multiple files

    Can I PM you the Add-in if you're interested?

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Looping a proprietary Add-in to process multiple files

    No, but you can post it here.

    How many procedures are there? if there is just one (that would make life too easy), maybe just post the signature (the Sub or Function declaration).

  7. #7
    Registered User
    Join Date
    10-07-2009
    Location
    Rhode Island
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Looping a proprietary Add-in to process multiple files

    There are 16 modules, 4 forms, and 2 excel objects in it. I apologize for being a total neophyte, but where are subs or function declarations usually found? Is there generally a "main" program or module where you would call up the functions being used? If so, is there a way to tell which file it is? There are no modules with the name "main" or anything that would jump out as the "main" program.

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Looping a proprietary Add-in to process multiple files

    If the code is proprietary, I suggest you hire a consultant with appropriate credentials. There's no way (for me, anyway) to do this by remote control.

    You could post in the Commercial Services exchange for help for a fee -- it's accessible only to mods. But while I trust my compatriots implicitly, that would not extend to sharing highly sensitive data of any type, a view I'm sure would be shared by your company.

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Looping a proprietary Add-in to process multiple files

    I don't think you can actually access the addin. I would be surpised at a proprietary ddin being unprotected & the code open for viewing.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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