Zack Barresse

Hi Zack,
I saw you defined the following as public in CuriousHank's post
Public Const NL As String = vbNewLine
Public Const DNL As String = vbNewLine & vbNewLine

I use a selfmade function named NLF() that allows for as many newlines as the integer you pass to it.
Empty is only one and works fine. Maybe you can use it too., just an idea.

Function nLF(Optional t As Integer) As String
Dim x As Integer, nLFa As String
If t = 0 Then t = 1
For x = 1 To t
nLFa = nLFa & Chr(13)
Next x
nLF = nLFa
End Function

Cheers,

Hans

Yo, baby. I just got that sharing violation thing in Excel. I figured I was stuck with it. I finally figured out the problem. I had once skyped the file to our workgroup here at work. Not everyone had downloaded it, so Skype somehow kept the file in use, but I didn't figure that out until I'd saved the file to a new name, blah, blah, and then tried to delete the file. It said Skype was using it. ARGHH!!! Just thought I'd start to spread the word that this is ONE way, at least, that the sharing violation is received. xxxooo

Do you know of a way to run a sub off of a click within an X and Y coor. in edit mode in PPT???

I know where my button will be and I just want to fire an action after they click in that general area...

HI Zack

My Name is Jenn. I have posted to the Business Applications forum regarding an Access Database. Slurpee55 stated he worked on a database a while ago, that would be very similar to what I'm looking for. I was wondering if he would be able to provide a copy of your database, with or without test data.

Thank you for your time.

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