Morgan

11 years agoFrequent Contributor

# Open Office

I am trying to open Open Office, click a specified tab in a specific document and copy all data on that tab. In Excel, this seems to work great but I am having difficulty getting this to work in Open Office (or I'm just not thinking clearly today). Any ideas?

Working Excel script looks like...

bk := AppPath +'Resources\Table.xls';

Excel := Sys.OleObject('Excel.Application');

Excel.Visible := True;

While not Excel.Visible = true

do delay (500, 'Waiting for Excel to open');

Excel.Workbooks.Open (bk);

Working Excel script looks like...

bk := AppPath +'Resources\Table.xls';

Excel := Sys.OleObject('Excel.Application');

Excel.Visible := True;

While not Excel.Visible = true

do delay (500, 'Waiting for Excel to open');

Excel.Workbooks.Open (bk);

- Hi Morgan,

I did not work with Open Office, but hope that this might help: http://smartbear.com/forums/f75/t59967/oleobject-libre-office/