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.