Share via

How open a workbook from excel office script

Raúl Andrés Duque Murillo 236 Reputation points
2021-08-06T23:15:53.787+00:00

Hello,

I'd like to process SEVERAL workbooks in the same folder of the web excel file where I'm running the script (excel office script) to consolidate information from several sources however, I couldn't find a way to do it since the Workbook object doesn't have an Open method or similar.

Any suggestion?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,076 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nancy Wang 116 Reputation points Microsoft Employee
    2021-08-25T01:06:10.757+00:00

    Hi Raul! Your question reminds me of a sample scenario we've included in our documentation - see here: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/automate-tasks-on-all-excel-files-in-folder. Could you let me know if this fits what you're looking for?

    -Nancy from the Office Scripts team

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.