title: Using MS Access to run code in excel vba
body: <p>I pull a query off SQL Server using an access front-end. I then export the recordset to a new Excel workbook. I want to then use excel to run code that I have in Access. It simply loops through cells and adds formatting and checks for a certain value. I can run it from access which will it has the workbook opens loops through fine. However it is painfully slow. </p>
  
  <p>If I go into excel and paste the code that access is running for the formatting and check. It runs within seconds. But running it from access takes over 10 minutes. </p>
  
  <p>Anyone got any ideas if this can be done? </p>