Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog
Script Center >
> 
> 
vba in excel 2010

Answered vba in excel 2010

  • Sunday, February 10, 2013 4:55 AM
     
     
    Sign In to Vote
    0

    Hi,

    I want to write a batch scripting that would automatically open all excel files placed in one folder, then using a main excel file , which consists of names of employees and the other excel files name try to do a match process based on first name , last name, full name,employee id.if a match is there it should go the main excel file and under the file name it found a match it should mark a yes, or else mark a no if all the criteria ia met.or else just put a manual search required.

     

All Replies

  • Sunday, February 10, 2013 10:20 AM
     
     Answered
    Sign In to Vote
    0

    I recommend you do this:

    1. Write at least some of the code in VBA.
    2. Post the result in an Excel forum and ask for help with the finer points.
     
  • Sunday, February 10, 2013 11:30 AM
     
     Proposed
    Sign In to Vote
    0

    Hi,

    I want to write a batch scripting that would automatically open all excel files placed in one folder, then using a main excel file , which consists of names of employees and the other excel files name try to do a match process based on first name , last name, full name,employee id.if a match is there it should go the main excel file and under the file name it found a match it should mark a yes, or else mark a no if all the criteria ia met.or else just put a manual search required.

    1.  This cannot be done wit a batch script.  You need to use PowerShell or another real scripting language.

    2.  Your question is very hard to understand.  You need to think through it carefully and repost with a clear and complete question.

    3.  We do not write scripts on demand.

    ¯\_(ツ)_/¯