Macro question URGENT !!!

WarDeathAngel

Board Regular
Joined
Jul 9, 2004
Messages
64
Hey,

I know I might not be in the good server, but I need a macro... in word... and as far as I know, there is no Mr.Word :)

Here is the question. I'm at work and I need to print a batch of photos with the title of the file below it. I don't have any program to print in batch and I know there is a way to make a little prorgam in VB to be able to print images in word with the filename below it. The photos need to be 1 per page and they must fit the whole page (I have both landscape and portrait photos (so put the portrait in portrait and "rotate" the landscape ones). All the files are in the same directory. And the paper is Letter.

I already have a macro that does that but cannot paste it in all because of copyright. I does everything but putting the landscape photos in full page (it only fit them on the portrait page)... any idea ?

Here is a part of the code that might help.. (I'm not sure)

The code before is juste to choose the folder and the image extension


Selection.InlineShapes.AddPicture FileName:=.FoundFiles(I), LinkToFile:=False, SaveWithDocument:=True
Selection.TypeParagraph
Selection.TypeText Text:=Dir(.FoundFiles(I))
Selection.TypeParagraph
If I = .FoundFiles.Count Then Selection.TypeBackspace
Next I
End If

Thanks a lot

WDA
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,224,851
Messages
6,181,394
Members
453,034
Latest member
mikdadhussain

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top