Zack Barresse

Hi Zack,

Thanks so much for responding. I can't post the link, but I can email you the file. Will that help? Yes, this is the only file for which I have received that error message. I was using Excel 2007 and not the viewer. Yes, this was the only version of Excel 2007 on my machine. I haven't tried to view it on another laptop. The file is a template I downloaded from Microsoft Templates. It allows me to keep track of the time and projects so that I can bill my clients properly. I don't recall exactly what I have already tried. I do know that there were other threads with this same problem and I tried the solutions listed on them. Thanks. Please help if you can!!!

You replied to one of my threads about making toggeling form buttons and posted 2 different methods. I got the one for the CommandButton to work. I can't get the FormsButton to work. The words change but not the colors. I would like to use that one in my forms that I am making. Can you help me getting it working.

Danny

Thanks for getting the word out on my problem.

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!