I have piece of software that creates an excel workbook when data is input into software. I can set this software to update this excel document at set intervals.
I am trying, without very much success at the minute, to set up a new excel workbook to get all data from worksheet within this workbook, also in regular intervals.
I can locate to it fine, with normal formulas, but can not get the data to refresh for me. Any ideas??
Have figured it out in Office 07 for windows, using workbook connections which works great and exactly what I want to do … but this software is based on the Mac OS X operating system, any help would be great as I am starting to tear my hair out now
Thanks
I’m not sure what you are looking for:
Native Excel function can pull data from another workbook (e.g. =SUM([Workbook2.xls]Sheet1!A1:A10))
or even a closed workbook =SUM(‘Macintosh HD:Users:merickson:Desktop:[Workbook2.xls]Sheet1’!A1:A10)
Or are you looking for something like this
tell application "Microsoft Excel"
set sourceWorkbook to workbook "Workbook1.xls"
set destinationWorkbook to workbook "Workbook2.xls"
set sourceCell to range "A1" of sheet "Sheet1" of sourceWorkbook
set destinationCell to range "A1" of sheet "Sheet1" of destinationWorkbook
set value of destinationCell to get value of sourceCell
end tell
Or are you looking for the refresh all command, which updates the native Excel formulas that look to closed workbooks (among other things)?
refresh all destinationWorkbook
Thanks for this I think its both that will help me. Will give them a try