VBA code to read/write in Addtl workbook

[StanSz]

I've got a workbook ("Main" workbook) in which I do a series of calculations -- no problem.

On one worksheet of this Main workbook I want to enter in a Cell the Name of another Workbook, ("Addtl workbook name) and in an adjoining cell the name of a Worksheet in this other workbook. I want to access these cell references via VBA code to enable me to both read and write into several cells on that indicated worksheet in the "Addtl" workbook.

I'd prefer to not change the Active worksheet from the "Main" workbook, so that I'm sure of getting back where I want to be after the few reading and writing work in the Additional workbook.

Entering the Addtl Workbook name and worksheet name in cells would allow me to easily change the names as desired and yet be sure that the VBA code continues to work since the code would be getting the names (path) by reading the cells.

I'm getting very confused in trying to write the VBA code.

Any comments or suggestions.

Thanks

Stansz

 

[StanSz]

I'm getting very confused in trying to write the VBA code.


Let me clarify: I'm confused in writing the VBA code to assembly the path to read the cells of the worksheet on the Addtl workbook.