Re: Using VBA to open another File AND reference/activate a sheet in that file from c After opening the workbook, it will be the ActiveWorkbook so you can simply Activate the sheet as referred to in the cell of the workbook containing the code. Hi, How can I save only the active sheet of a workbook in VBA?
I am currently using the following VBA code in Excel for MAC 2016: Sub MailWorkSheet Dim SourceWb As Workbook, DestWb As Workbook, sh As Worksheet Dim strbody As String, TempFileName As String If Val(Application.Version) ' strbody = strbody & 'Hello:' & ' & ' & 'XXXXXXX.' & ' & ' ' & ' & 'XXXXXXX.'