Default file location

Question

Hi All,

I have a macro that exports a Quicken report to .xslx then updates an Excel spreadsheet.

Today, after an upgrade, when I have the Quicken report open, the "Export report data to different formats" link consistently opens in the wrong file location, which messes up the macro.

Is there a way to specify a default file location for this action?  Otherwise, I have to re-do the macro which I'd like to avoid.

Many thanks community!  :)

John

Chris_QPW · Answer

On the subject of what is the default location for the exported Excel report, it seems to be the same folder as where the data file is.  There isn't any way to change this default other than moving the Quicken data file to another folder.

jvoorhes · Answer

thank you both--I run the macro with Quicken already open; it's first step is to put the focus on Quicken.

So, I did make it work with a slightly cheesy workaround--the macro overwrites an Excel spreadsheet then saves it.  The macro wants this spreadsheet to be third in the list so I just created two empty Excel spreadsheets in the new file location called A.xslx and B.xslx which seems to be working.

q_lurker · Answer

My preference has always been to copy the report to the clipboard, switch to Excel file, then paste the report starting at the desired upper left cell.  No quicken-generated .xlsx file is needed.  Would that help?