![]() 'Now store that variable value in to a cell range ![]() 'To Store all the content of that word Document in a variable Set objDoc = ("C:\Users\Vish\Desktop\New Microsoft Office Word Document.docx") 'Open a Word Document and Set it to the newly created object above 'Create a New Object for Microsoft Word Application To work the below code you need to Add the reference of Microsoft Word in your Excel Workbook.Īpplication.DisplayAlerts = False 'Disable all the Alerts from excelĪpplication.ScreenUpdating = False 'After opening Word Doc, Document will not be visible Opening an Word Document is more like Excel Workbook only. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active Worksheet in a particular Cell. I am going to write few articles about Word from Excel Macro. As many of us want to deal with Microsoft Word Document from Excel Macro/VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |