B
bpr
Hi all,
I have a document which contains data without any formatting.(here it
is input.xls)
Another document named newt.xls does not contain data but has various
formattings such as
width of various columns,outlines of various cells. (no merging of
cells is there)
I can manually copy from input.xls and paste special in newt.xls. It is
copying successful.
But when I tried to do it in apple script it is not happening.
It is not throwing any errors.
I am attching the script snipet
....
activate
open workbook workbook file name "Bishnu's HD:input.xls"
select worksheet "Foglio1"
copy range range "A1:IV65536"
open workbook workbook file name "Bishnu's HD:newt.xls"
select worksheet "Sheet1"
display dialog 1
paste special range "A1:IV65536" what paste values
...
when I replace newt.xls with a simple plain document the above script
is running fine.
Any help regarding this greatly appreciated!
Cheers
Bishnu
I have a document which contains data without any formatting.(here it
is input.xls)
Another document named newt.xls does not contain data but has various
formattings such as
width of various columns,outlines of various cells. (no merging of
cells is there)
I can manually copy from input.xls and paste special in newt.xls. It is
copying successful.
But when I tried to do it in apple script it is not happening.
It is not throwing any errors.
I am attching the script snipet
....
activate
open workbook workbook file name "Bishnu's HD:input.xls"
select worksheet "Foglio1"
copy range range "A1:IV65536"
open workbook workbook file name "Bishnu's HD:newt.xls"
select worksheet "Sheet1"
display dialog 1
paste special range "A1:IV65536" what paste values
...
when I replace newt.xls with a simple plain document the above script
is running fine.
Any help regarding this greatly appreciated!
Cheers
Bishnu