How to refer to other workbooks Vba

[Emeng]

Hi
I am creating a macro enabled workbook with an active x control which is to rearrange a separate spreadsheet downloaded from SAP. Part of the process involves opening a third workbook and importing a sheet named equal to the value of a cell in the second workbook. I am wondering how to refer to the other workbooks. I have not created any code for this as yet so nothing to upload, but asking for general information.
Thanks & regards
Mark

 

[NARAYANK991]

Hi Mark ,

I think your thread title should read : How to refer to other workbooks using VBA ?

The VBA to open a workbook is outlined here :

http://msdn.microsoft.com/en-us/library/office/ff194819.aspx

http://stackoverflow.com/questions/12951946/excel-vba-open-workbook-perform-actions-save-as-close

Narayan