Let me know about point #2 and I will steer you to some code to get started. I have found these to be a little clunky from a programmatic standpoint. If this is all happening on your local disk, then it is much more manageable.įinally, the word document is going to use a series of content controls (text boxes, drop downs). In practice, it can be very, very difficult especially if multiple users are deploying the Word document from various locations with various levels of access to the data source. Secondly, the "heart" of your code would be a connection between your Word document and your data source. I would migrate it to Access or an SQL database. Extensive data should not be housed in Excel. On the File menu, click New and then click. NET, follow these steps: Start Microsoft Visual Studio. To create a new Word document by using Automation from Visual Basic. Insert tables, format tables, and populate the tables with data. Browse and modify various ranges within a document. This is a bad idea for reasons unrelated to the VBA code you would need to write. Insert paragraphs with text and formatting. My short answer is that it is quite complicated.įor starters, you are using Excel to function as a database. I have built several applications that function in the manner that you describe.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |