Command Line to convert from MDB to XLS using MS Access 2003

All replies

• 

  

  0

  Sign in to vote

  Hi,
  
  One of the procedures we have found out is that by using a macro TransferSpreadsheet. Then we use the command line switch /x to obtain the xls file but the issue with this procedure is that we will have to make the macro manually.
  
  Is there anyway in which we can save the macro individually and then use that macro on any mdb file to obtain the xls file.
  
  Thank you,
  CED

  Thursday, June 18, 2009 7:41 AM
• 

  

  0

  Sign in to vote

  I'm sorry, but this is really off-topic in the VSTO forum. VSTO is a technology that runs in-process with some Office applications for the purpose of extending the UI. Access is not one of those applications.
  
  I recommend you try the Access programming newsgroup. You'll find a link in the forum's Please Read First message.

  ---

  Cindy Meister, VSTO/Word MVP

  • Marked as answer by C.E.D Thursday, June 18, 2009 1:27 PM

  Thursday, June 18, 2009 9:27 AM
• 

  

  0

  Sign in to vote

  Ok, sorry for the inconvenience caused and thank you for the link.
  
  Thank you,
  CED

  Thursday, June 18, 2009 10:46 AM