Referencing a workbook

[dnicholsby]

Hello,

I'm having some trouble referencing a workbook. My current macro is as follows:

Please Login or Register  to view this content.

I want to reference the JRH Data Input Analysis sheet as users may rename the file.

I tried using

Set wbThis = Activeworkbook

and then replacing Workbooks("JRH Data Input Analysis.xlsm").Activate with Workbooks(wbThis).Activate

but that didn't seem to work. Any suggestions?

PS. I know my code isn't great but its my first time using vba

[Norie]

If you really need to activate the workbook referred to by wbThis drop the Workbooks bit.

Please Login or Register  to view this content.

PS If wbThis actually refers to the workbook the code is in you can use ThisWorkbook to refer to it.

[dnicholsby]

Thanks! If you can see any issues with my code I would also appreciate any pointers to tidy up for future reference!