variable file name

Hey, I'm trying to edit the following VBA code so that the file I open becomes variable: Sub ReinvestmentIncome_Check() Dim wb As Workbook Dim Lmonth As Date Dim Smonth As Date Dim Yr As Date Dim Syr As Date Lmonth = ActiveSheet.Range(A2).Value Smonth = ActiveSheet.Range(B2).Value Yr =...

Hi, I am working on a file which is a consolidation of different sources, after this process I have to add columns from other sub-files by either vlookup or index formula in VBA. My question is, how to get the below formula in a loop so that "Book1" and "Sheet1" are picked up from a list of...

Hello all I started to learn VBA code on Excel 2010 10 days ago and have "successfully" written the following basic code: This works great for what I need it to do except for the final line :( For the life of me I cannot seem to be able to close the variable defined workbook....I always get...

Hello, I try to write this macro which could enable me to open files according to cells value I chose previously in my active workbook (In "Inputs" sheet to be accurate). These files I want to open are closed and under other folders. Here is my code but I have this message poping up "Type...

Hi there, I have a problem I've been trying to work out for a while, I'm trying to switch between workbooks, Workbook1 with the code in will have a constant name, the name of workbook2 will change every time the report is run (on a weekly basis). I've got workbook1 to open workbook2, and can do...