Export report to a micro-enabled Excel workbook

Teresa Huang
Teresa Huang Member Posts: 30
edited August 2017 in Reckon Accounts (Desktop)
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 

Comments

  • Malcolm McMaster
    Malcolm McMaster Member Posts: 17
    edited August 2017
    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.
  • Teresa Huang
    Teresa Huang Member Posts: 30
    edited August 2017

    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 :-)

  • Malcolm McMaster
    Malcolm McMaster Member Posts: 17
    edited August 2017
    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 ).