Copying table data from Word into Excel
It’s been years since I’ve done VB and I’m having trouble figuring out why I’m not capturing the correct content.
Copying table data from Word into Excel using Visual Basic
It’s been years since I’ve done VB and I’m having trouble figuring out why I’m not capturing the correct content.
Creating word document with photos and descriptions with VBA
I am trying to create a word document report that includes photos with an associated description using Excel VBA. The photo names are in column A and the descriptions are in columns B:I of the excel spreadsheet. The current macro opens the FileDialogFolderPicker and the user pick the folder that contains the pictures they want. The macro picks the associated picture based off the photo name in coulmn A then creates the word document and inserts the photos and descriptions. I am having trouble with inserting the correct photos and descriptions into the word document in the correct locations. I would also like to lock the aspect ratio of each photo and be able to specify the size of the photo in inches. I have included photos of what is currently happening with the word document and also what I would like the final result to look like. Any help would be greatly appreciated.
WordApp.Documents.Content.Find isn’ working
I am new to VBA programming and I have a problem. I am trying to automatice words documents. I have a template document with generic names and I need to use a VBA code in excel to replace those generic names with concrete names. The problem is when I use the .Find function either way it does not work. I made a simple example in which I printed on the debug screen a couple of lines that does not use the mentioned function but when I use it, it does not print. That is to say the result of the following code is this:
Texto a buscar: NOMBRE
Reemplazo: hello
VBA: How to Read Mail merge fields from TextBox Shape
I’m using below code to read and manipulate the Merge Fields but it is not getting the merge fields from textbox used in the word document, I am using excel VBA to read the word document.