Export report to a micro-enabled Excel workbook

  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi, I am using Accounts Enterprise 2017 desktop.

I can export a AR Ageing Detail report to an existing Excel workbook (.xlsx file), but not a micro-enabled workbook (.xlsm file).  Could anyone confirm if this is the case that Reckon export does not support .xlsm file type?

Thanks, 
Teresa 
Photo of Teresa Huang

Teresa Huang

  • 510 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Malcolm McMaster

Malcolm McMaster

  • 322 Points 250 badge 2x thumb
Yes Teresa, It appears that Reckon will not allow export to Macro enabled workbook. For what it's worth I just dump the data into a blank workbook, copy the data range & paste to the macro driven data file.
Photo of Teresa Huang

Teresa Huang

  • 510 Points 500 badge 2x thumb

Thanks Malcolm, you saved me the hassle to investigate other possible reasons why I couldn't do it.

Yeah, looks like exporting to new file then copy/paste is the only way to go :-)

Photo of Malcolm McMaster

Malcolm McMaster

  • 322 Points 250 badge 2x thumb
Depending on the frequency & amount of data, you could resort to ODBC connection to your data file. That takes care of everything, provided your file copy is ODBC enabled ( there is a fee payable ).