Dan, When Monarch exports out to an excel spreadsheet, it names the range it just exported. You can only append to that spreadsheet only to the bottom of the named range and everthing below that needs to be blank in order for the export to work.
Have you modified the original spreadsheet so the named range does not include everything in the range? If it doesn't, just modify the named range to include everything. Also, the original named range must be set as wide as your append export. Or if your first export just included headers and no data that will be another reason for it to fail. In that case, you need to overwrite the sheet.
Those are the main reasons why some of my append exports fail.
Does this help at all?
Hi Ralph, thanks for responding.
I kinda understand about the named ranges, but I'm not quite sure it it replies. We are extracting information from reports on a daily basis and accumulating the results in Excel. There are no changes within Excel from daya to day. In most cases the worksheet is never even opened between processes.
So I can see the named ranges, what can I do about them?
If you aren't modifying or using the files in between exports, you really don't need to do anything to the named ranges. They should be OK.
Are you running a script to export these or are you doing this manually is my next question.
Do you have problems appending the filters mannually? If you are running a script, is it a vb script or command line? Also which version of Monarch are you using?
If you are running a command line script, I believe you could append to files with Version 7 or newer. I don't use the command line function so I can't be of much help myself but others can help. If you are using vb script, only the jetexport command will allow you to append and you need Monarch 6 Pro or newer. This is what I use quite a bit and only had problems when trying to append to a sheet that had the header only. In that case I have to overwrite that sheet.
Hope this helps.
Dan, You say you can export and append 2 filters manually separately it works fine but you have problems when you try more than 2. Boy, you got me stumped on this one why you have problems doing it manually with what info you have given me.
Maybe someone else has more experience on this and has experienced this problem and has a solution for you.