Hi I am new to the macro and VBA world, but have picked up a lot from reading these forums so far. I am in need of some specific help though.

I have a macro called "CombinePenult" in workbook "experimental_form.xls" that basically is copying and pasting information from Sheet1 to the "name" sheet. That information is then copied. I usually have multiple experimental_form (ie. red1_form.xls, red2_form.xls) workbooks on my desktop minimized and actively pull them up, input a csv file, then run macro "CombinePenult". I then manually go to a second workbook "APS_date_company_datasummary.xls" and run macro "jak".

What I want to do is run the "CombinePenult" macro and have it activate the other workbook "APS_date_company_datasummary.xls" and then run macro "jak". I think I know how to do this if the "APS_date_company_datasummary.xls" file name doesn't change, however with each day and company the file name has to change. Is there a way to do this without having to edit the macro everytime. I was thinking if it could just look for the word datasummary in the name that would work since that part of the name never changes, but I am unsure how to do that or if it would work. The macro that works if the name doesn't change is listed below:

Please Login or Register  to view this content.


This worked when I tested it out, but again the name of the file "APS_date_company_datasummary.xls" changes regularly. Thank you in advance for any and all help! If there is anything else to help the macro as well please share as I am new to this and want to learn more about this.

Thanks,

Josh