<div>
Put me on the right track, solved now, many many thanks
</div>


Put me on the right track, solved now, many many thanks

<div>
<div class="content wysiwyg-content">
Hi, Having just executed a do.cmd transferspreadsheet called say &quot;My_New_Sheet&quot; how can I select the sheet to start formating it. &nbsp;I can open a new workbook and sheet with dim and set obj etc.<br />
the line syntax I need is maybe something like<br />
set objExcelSheet = objExcelWookbook.Worksheet<wbr /> ???? name??<br />
Help!
</div>
</div>


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??
Help!

MS Access vba how to select excel sheet following docmd.transferspresdsheet

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.