$$Excel-Macros$$ Re: vba code to convert PDF to Excel

DoEvents 'IN ACROBAT : 'SELECT ALL SendKeys "^a" 'COPY SendKeys "^c" 'EXIT (Close & Exit) SendKeys "^q" 'Wait some time Application.Wait Now + TimeValue("00:00:03") ' wait 3 seconds DoEvents 'Paste ActiveSheet.Paste 'Go back to cell A1 Call BackT

$$Excel-Macros$$ Please help me adding variables to my macro

I am attaching a macro that I recorded. But I need the variables to be updated Basically this macro is going thru several tabs and update the pivot tables by simply changing the dates. So everytime I run the macro, I want dates in these pivot tables to be updated to today. Please look at

Re: $$Excel-Macros$$ Password problem in Excel Macro

Sheets(Control_Panel).Select Workbooks.Open Filename:=path2, UpdateLinks:=0 Sheets(Result).Select Range(DU1:KF60).Select Selection.Copy -- *From:* Mccue ogu...@gmail.com javascript: *To:* excel

$$Excel-Macros$$ Password problem in Excel Macro

I have this macro that I run everyday. But it is a password protected excel sheet so Macro is asking me to put in the password during macro is running. Here is where it asks password Workbooks.Open Filename:=path1, UpdateLinks:=0 Sheets(DATA).Select Workbooks.Open Filename:=path2,