Replies

I have office xp developer and vb6 pro. My users have w95 and office 97, they don’t have access at all, just word and excel97. So I am trying to develop a front-end in vb6 for them because when I try to make a run-time version of my access xp database it won’t run on their computers.

I am using a DAO control on my vb6 form connected to my mdb which i converted to access 97. Then i put text boxes so my users can enter data into the tables of my mdb. I want them to enter data for each project they work on. The projects have client name and job number. More than one project can have the same client and the same job number. I have a separate tblPROJECT, tblCLIENT and tblJOBNO in my mdb.

How can I make a drop-down box that holds the clients names and allows the user to enter a new client if it’s not in the box? Or, is there a better way to do this in VB6.

I appreciate any help or suggestions. Thank you very much.

I am pasting the link from excel into powerpoint. The graphs are in made in excel and linked to view in ppt.

I’ve just been on the phone with microsoft and they think it is a video driver problem.

The only pc we can run this file more than 4 times is on a 850mhz, 500mg ram, 16mg video, w2000, excelxp and pptxp. It won’t work on an NT, 128mg ram, 400mhz, 8mg video ram OR a W98, 128mg ram, 800 mhz, 8mg video ram or any w95 pcs.

I just got Office xp Developer and my IT dept said that Office 2000 was not going to be sold anymore. We’re still on Office 97 with Win95 and in the next 6 mos we’re upgrading the whole company (1000+) to Office xp and Win2000

Thanks. I really don’t know how to do a append query. I have table1 and table2 and i just want to put them both together. thanks

This code works great from an excel file that i have open. I run it from ppt.

Sub find_replace()
Dim sld As Slide
Dim shp As Shape
Dim i As Integer
Dim txtRng As TextRange
Dim foundText As TextRange
Dim replaceText As TextRange
Dim code As String
Dim pptApp As PowerPoint.Application
Dim xlApp As Excel.Application
Dim xlBook As Object
Dim xlSheet As Excel.Worksheet
Dim myArray(1 To 359)
Dim intCell As Integer
Dim market As String

intCell = 0
i = 0

Set pptApp = GetObject(, “PowerPoint.Application”)

Set xlApp = GetObject(, “Excel.Application”)
xlApp.Visible = True
Set xlBook = GetObject(, “Excel.Application”)
xlBook.Windows(1).Visible = True
xlBook.Worksheets(1).Select

‘ActiveWorkbook.Worksheets(“Text”).Select

‘ fill array with first row in Excel

For i = 1 To 359
code = “<>”
myArray(i) = xlBook.Cells(i, 1)

For Each sld In Application.ActivePresentation.Slides
For Each shp In sld.Shapes
If shp.HasTextFrame Then
Set txtRng = shp.TextFrame.TextRange
Set foundText = txtRng.Find(FindWhat:=code)
Set replaceText = txtRng.Replace(FindWhat:=code, ReplaceWhat:=myArray(i))
End If
Next shp
Next sld
Next i
‘Next intCell

MsgBox (“FindReplace is Finished”)
market = InputBox(“filename = “)
pptApp.ActivePresentation.SaveAs (“P:market & “.ppt”)

pptApp.ActivePresentation.Close

End Sub

This save my ppt file. I don’t want to close the excel file that I have open. I want to open, however, a different one and run a macro in it. I then want to close it. Then I want to go to the first excel file (that stayed open) and run a macro in it. I want to keep it open

Now I want to go to a ppt file and open it. I want to enable macros, yes, and update links, yes. How to i do that in powerpoint. Thank you for the help.

Thanks for the code. I found a way to name my text range in ppt. Now I want to look through my active presentation and find the text range i’ve named txtRng1. Once I select it I want to search for <> and change it to something contained in a cell in Excel.

How do i select a text range called txtRng1 in ppt? Thanks for the help.

We’ve found Word to be unstable when we’re trying to put charts in from Excel. They move, change size etc. and we haven’t had good luck. It’s much more stable in PPT. If I have too, however, I will do it in word if I can’t think of anything else.

Even in word, tho, how do you do a booklet? thanks

Publisher doesn’t have vba so I can’t make it link to Excel. I’m trying ClickBooks2000 now to see if that works.

Never even crossed my mind. I will look at it. I just need to be able to merge excel data and graphs into some other program. I’ll try it and see. Thanks