4

Is it possible to read data from another closed excel workbook using excel office script? Thanks Suji

Suji
  • 87
  • 2
  • 8
  • If "excel office script" refers to VBA the answer is yes. You can also retrieve data from another workbook using script in other coding languages, including Excel worksheet functions. – Variatus Jan 03 '21 at 09:16
  • No... I am referring to Excel office sciript.. not VBA. – Suji Jan 03 '21 at 09:26
  • what do you want to do? Grab a table? – Ethan Jan 04 '21 at 17:24
  • Yes grab data from table. – Suji Jan 05 '21 at 02:21
  • 1
    any updates 2023? – sutan Jan 11 '23 at 10:37
  • Same request: I’d like my Office Script to run on two Excel Workbooks at once, one being format and formulas reference, second being data destination. Power Automate is not able to act as bridge for such transfer. – Joël May 05 '23 at 12:51

1 Answers1

3

This is only possible through Power Automation at this point. You'll have to run your script in a flow and feed the data from another workbook through a second script.

This article/video explains it all (video is bit grainy -- but you have full code samples here). Let me know if this solves your scenario.

https://github.com/sumurthy/officescripts-projects/tree/main/Event%20Cross%20Reference

Sudhi Ramamurthy
  • 2,358
  • 1
  • 10
  • 14