Specifically in the SSIS Script task code below, I can't seem to figure out how to open the file as a Workbook object when it sits in Blob Storage. Have tried a few options including Powershell commands in Azure Batch Service, PowerShell in Function App, Data Factory running SSIS package and script task. There is no VM to work with in the equation. The workbook has embedded SQL with saved credentials. I have a client request to automate a RefreshAll on each worksheet on an Excel workbook that is stored in Azure Blob Storage. Use the locals window to inspect the late binded objects. Set WordDoc = (".\TestReadWordDoc.docx")įrom there you can go on. Set WordApp = CreateObject("Word.Application") The correct code see below: Option Explicit You don't need the application object to create your word app. I'm sorry there was a big mistake in my first answer. Then you have to loop over the paragraphs importing the text to your excel spreadsheet or iterate through all of the file text and then catch the patterns you search for. Content property you have access to all of the text in the file. So in case you can see the other members of the document obejct here: įor example with the. myParagraphs = myWordDoc.listParagraphsĪs described in the ms office dev center: ĭon't know if this is exactly what you need. Now you can access a list of numbered paragraphs in the document obejct. Set myWordDoc = myWordApp.open "your file path goes here" Set myWordApp = Application.CreateObejct("Word.Application")
You can create a WordApplicaiton object and then open your desired document. Assuming yout are using the excel vba editor.
0 kommentar(er)
