I've not been able to get around this problem using TransferSpreadsheet. I
cobbled around it by pushing the data over one cell at a time. It works but
is very slow relative to TransferSpreadsheet. Anyone have a suggestion how
I might speed up the process?
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:oA**********************@newssvr28.news.prodi gy.com...
I'm using TransferSpreadsheet to transfer data from A2K to an Excel
spreadsheet that has some pivot tables in it. It seems like it is
working, but when I open the spreadsheet, it gets an error (always asks if I want
to send a message to Microsoft). I can't figure out how to get the data into
the spreadsheet. Anyone run into this or have a suggestion?