Hi, Having just executed a do.cmd transferspreadsheet called say "My_New_Sheet" how can I select the sheet to start formating it. I can open a new workbook and sheet with dim and set obj etc.
the line syntax I need is maybe something like
set objExcelSheet = objExcelWookbook.Worksheet ???? name??