$$Excel-Macros$$ Change Slide in PowerPoint when Copying Charts from Excel in VBA

2009-09-14 Thread Rjorg
Hi, I have a template in PPT that I copy charts from Excel every month. I am trying to create a macro that will do this automatically for me. Unfortunately, I am unable to make the macro change slides. I am able to copy and paste the chart, but then cannot move onto the next slide. I also do not

$$Excel-Macros$$ Re: Find Date Macro

2008-11-01 Thread Rjorg
r m/d/yy or mm/dd/yy > > Manish > > -Original Message- > From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] > > On Behalf Of Rjorg > Sent: Saturday, November 01, 2008 3:58 AM > To: MS Excel & VBA Macros > Subject: $$Excel-Macros$$ Find Date

$$Excel-Macros$$ Find Date Macro

2008-10-31 Thread Rjorg
Hi, I am trying to create a macro that searches for a specific date in a sheet with many dates. I would like a textbox to come up and ask what date to look for. After inserting the date in the text box up I get an error. Do you know what I need to change to get it to look up the date that was inpu

$$Excel-Macros$$ Date search for inputbox

2008-10-31 Thread Rjorg
is the code I have: Dim c As String c = Application.InputBox("What date are you looking for?", Type:=1) Cells.Find(What:=c, After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate Tha