title: Controlling Excel workbook from Access 2010 VBA
body: <p>I have a situation very similar to the following post:</p>
  
  <p><a href="https://stackoverflow.com/questions/9974250/access-query-to-excel-2010-to-create-a-graph-via-vba">Access query to excel 2010 to create a graph via vba</a></p>
  
  <p>In my case, I export a table, but I want to do a lot more to the Excel file. </p>
  
  <p>First I want to rename the tab on the first sheet of the Excel file, since it exports with the funky table name. So, instead of "tblThisIsMyTable", I'd like to change it to "MyTable as of (add a date variable here)"</p>
  
  <p>Secondly, I need to create a Pivot table and make a copy of the Pivot table on another tab, to change one of the parameters.</p>
  
  <p>My question is, can I record a macro in Excel to do the basic steps and drop that code into my Access VBA?</p>
  
  <p>I hope I was clear enough and thanks for any help you can provide.</p>