Zack Barresse

Hey long time no talk... I was needing a bit of help on this:

Sub ExportGraphics()
Dim x As Long
Dim y As Long
Dim i As Integer
Dim objText As Object

For x = 1 To ActivePresentation.Slides.Count
' Call ActiveWindow.Selection.ShapeRange.Export("C:\Graphics\" & x & ".jpg", ppShapeFormatJPG)
Call ActivePresentation.Slides.Range.Export("C:\Graphics\" & x & ".jpg", ppShapeFormatJPG)
Next

End Sub


I have one graphic on each slide and I want to have the vba loop thru and export each graphic to the folder.... I can get it to work on one slide if I select the graphic (and use the commented out line) but thats timely if i have a deck that is 25 slides or more...

can you help?

Hello Zack
Let me know if I'm asking too many questions. I recently got Excel 2007 and I'm trying to convert from Lotus and want to sort of copy the macros I'm using in it. When I copy the macro's from here to the spreedsheet, I add commands and see what happins. I'm wearing out the record button!

Mike

Hi Zack
I have had a look at this thread How do you pull info from a seperate doc using variables as described.
http://forums.techguy.org/business-a...ml#post7000111

The guy on this thread IMHO needs a self driven macro for what he is trying to do.

Are you able to help.

Cheers
Les

Hey Zack, Thanks again for the help. The reason I didn't ask you about "message boxes" is because I wanted to start a new thread since it was about something different..

Mike

Thanks for your help with that email code, it's really working great!

Is this where you are hanging nowadays? I haven't seen a recent post from you anywhere but here:-) Glad to see you are still around. Hope the training is going well.

Zack,

My name is Diego. I am extremely impressed with the solutions you have posted. I tried to modify one of them:

http://forums.techguy.org/business-a...s-using-3.html

to suit my needs, but I am clueless with these things. I was wondering how I might modify this code to automatically send me an email when if the date listed in "column J" is the same date as today. Also that it email me once only.

Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this. It needs to do this even if I am not at my computer.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks Zack. I appreciate your help!

Hi Zack

I am Bharath ...I am new to thus forum......I have a vba problem......I posted it in the forum....Please have a look at it and help me to do it
http://forums.techguy.org/business-a...le-change.html
OBP got all the details from me......He told that u are an expert in VBA....I have posted all the details in the thread ...Please have a look at it and ask me if you have some clarification

Thanks
Bharath

Zack, there are a couple of Excel questions on the Software Development forum that you might like to look at.

Tony

LOL, man of few words huh?