Relative Content

Tag Archive for excelvbams-word

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