O
orliotis
Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I'm trying to paste data from one worksheet into another using AppleScript. The trick is that the pasted data has some blank columns mixed in, and the destination worksheet has formulas in those same columns. I need to paste the data so it doesn't erase the formulas.
When I do this manually using the Paste Special dialog box (with the Skip Blanks option selected), it works perfectly. When I try to do the same using AppleScript, the empty columns are pasted and all the formulas are erased.
Here's the AppleScript I'm using for the paste:
paste special range "A1" with skip blanks
I've tried it in both Excel 2004 and Excel 2008 and get the same results with both.
Does anyone know how to get Skip Blanks to work correctly using AppleScript?
Thanks,
Brian
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I'm trying to paste data from one worksheet into another using AppleScript. The trick is that the pasted data has some blank columns mixed in, and the destination worksheet has formulas in those same columns. I need to paste the data so it doesn't erase the formulas.
When I do this manually using the Paste Special dialog box (with the Skip Blanks option selected), it works perfectly. When I try to do the same using AppleScript, the empty columns are pasted and all the formulas are erased.
Here's the AppleScript I'm using for the paste:
paste special range "A1" with skip blanks
I've tried it in both Excel 2004 and Excel 2008 and get the same results with both.
Does anyone know how to get Skip Blanks to work correctly using AppleScript?
Thanks,
Brian