Recent content by jpjones23

Here's the code I've developed thus far. Sub ChangeHyperLinkData() Dim oSld As Slide Dim oAgenda As TextRange 'Stop ActiveWindow.View.GotoSlide Index:=ActivePresentation.Slides.Count Set oSld = ActivePresentation.Slides(ActivePresentation.Slides.Count)...

Sdeen, Here's the code I use to populate a variable with the data found at a bookmark. Dim Qscale0 As String Dim Qscale1 As String ' Field definition ' Each question or statement has 32 possible ratings. There are 4 importances and 8 scale rating. ' The field names are defined as such. '...

Thank you PH. I'll look into the Tags Collection. Jeff

I have 150+ presentations, each with three hypertext links in a TextFrame object. I need to modify each of these links. I have a couple of VBA wonderings. First, with MS Word I have the normal.dot file and with MS Excel I have the personal.xls file. Both hold macros or VBA code that can be...

Thank you Tony. The function works like a charm. I just need to keep my fingers crossed that people using it have the correct object libraries. For example, I developed the macro using the MS Project 10.0 Object Library. Today a user couldn’t get the macros to work. In looking at th problem...

LOL. Thank you Tony. I use the following in MS Excel "workProducts = Application.GetOpenFilename(Title:="Add Work Product(s)...", MultiSelect:=True)" (no quotes)and it works just fine. In MS Word I use the following. Dim FOrecord As Object: Set FOrecord =...

Has anyone managed to the standard file open window to display via VBA in MS Project? I have no problems with MS Word or MS Excel but Project throws up an error stating that the object doesn't support this method. So much for consistency across MS apps. ;-) Hoping, Jeff