$$Excel-Macros$$ Re: vba code to convert PDF to Excel
I copied some code but it gets stuck on varRetVal = Shell(strDoIt, 1)
The code is
Sub BackToA1()
Range("A1").Select
End Sub
Sub GetPDFnow()
Dim varRetVal As Variant, strFullyPathedFileName As String, strDoIt As
String
'Add a new worksheet
Sheets.Add After:=Sheets(Sheets.Count)
'Name it
ActiveSheet.Name = "POP3"
'Back to "A1"
Range("A1").Activate
'HERE YOU DEFINE THE FULLY PATHED PDF FILE
strFullyPathedFileName = "C:\users\dave\documents\bne\POP16Nov18.pdf.pdf"
'HERE YOU SET UP THE SHELL COMMAND
strDoIt = "C:\Program Files\Adobe\Reader 8.0\Reader\AcroRd32.exe " &
strFullyPathedFileName
'The Shell command
varRetVal = Shell(strDoIt, 1)
'Clear CutCopyMode
Application.CutCopyMode = False
AppActivate varRetVal
'Wait some time
Application.Wait Now + TimeValue("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 seconds
DoEvents
'Paste
ActiveSheet.Paste
'Go back to cell A1
Call BackToA1
End Sub
On Wednesday, November 28, 2018 at 7:14:13 PM UTC+11, David McCue wrote:
>
> Hi There
> I get a daily PDF emailed to me that I need to convert to excel using a
> macro and I am having trouble using some of the examples of code I have
> found on the web.
>
> Can someone help please?
>
> PDF file attached-the file name changes daily with the date so if I could
> have the code read tomorrow's date file from that folder that would be
> ideal as this is done everyday for the next days operation
>
> Excel file attached and I want it to feed into the sheet named POP but
> also delete the old info out (eg.yesterdays)
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
$$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 the attached. Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Book3.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Password problem in Excel Macro
On Thursday, December 6, 2012 9:17:50 AM UTC-6, Paul Schreiner wrote: Do you have the password? Is it asking for the password when you open the file? or when you try to select the range? (need to figure out if you are dealing with a protected file or sheet) if your password is easypwd then: If the workbook is password protected, you can use: activeworkbook.unprotect easypwd the sheet syntax is: sheets(Result).unprotect easypwd *Paul* Thanks for the reply Where exactly I should place activeworkbook.unprotect easypwd This is what I did and still asking me password Workbooks.Open Filename:=path1, UpdateLinks:=0 Sheets(DATA).Select Workbooks.Open Filename:=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(Result).Select Range(DU1:KF60).Select Selection.Copy -- *From:* Mccue ogu...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Wed, December 5, 2012 4:21:48 PM *Subject:* $$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, UpdateLinks:=0 ActiveWorkbook.SaveAs Filename:=path3 _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False Sheets(Control_Panel).Select Workbooks.Open Filename:=path2, UpdateLinks:=0 Sheets(Result).Select Range(DU1:KF60).Select Selection.Copy Can someone tell me what to so so that macro stops asking password? Thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$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, UpdateLinks:=0 ActiveWorkbook.SaveAs Filename:=path3 _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False Sheets(Control_Panel).Select Workbooks.Open Filename:=path2, UpdateLinks:=0 Sheets(Result).Select Range(DU1:KF60).Select Selection.Copy Can someone tell me what to so so that macro stops asking password? Thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
