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

e("00:00:03") ' wait 3 seconds 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 se

$$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 t

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

e:=path2, UpdateLinks:=0 ActiveWorkbook.SaveAs Filename:=path3 _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False ActiveWorkbook.Unprotect "my password" Sheets("Control_Panel").Select Workbooks.Open Filename:=path2, UpdateLinks:=0 Sheets("R

$$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, UpdateLi