6

I want to switch back and forth between application with the shell command in VBA. I am using SendKeys to do stuff in process A then move to process B, then to process A then process B. It works fine for the first iteration. When I use AppActivate to go back to process B, it actually does switch focus back to process B. HOWEVER, it ignores subsequent commands from SendKeys.

Example code:

Sub pastePDF2TXT_v3(pdfName As String, txtName As String)


Dim acrobatID
Dim acrobatInvokeCmd As String
Dim acrobatLocation As String

Dim notepadID

Dim acrobatID2
Dim notepadID2

Debug.Print "here"


acrobatLocation = "C:\Program Files\Adobe\Acrobat 9.0\Acrobat\Acrobat.exe"

acrobatInvokeCmd = acrobatLocation & " " & pdfName

acrobatID = Shell(acrobatInvokeCmd, 1)
AppActivate acrobatID
SendKeys "^a", True  '^A selects everything already in the pdf file.
SendKeys "^c", True  '^C copies the selection to the clipboard.



notepadID = Shell("NOTEPAD.EXE " & txtName, 1)  ' invoke notepad on the text file.
AppActivate notepadID                           ' set the new app as teh active task.

SendKeys "^a", True  '^A selects everything already in the text file.
SendKeys "^v", True  '^V pastes the new stuff over the top of the old text file (deleting the old stuff)
SendKeys "%{END}", True ' makre sure last line of text file 
SendKeys "{ENTER}", True



AppActivate acrobatID  ' NOTE: APPEARS TO WORK UP TO THIS POINT.

SendKeys "{ENTER}", True  ' NOTE: SECOND APP IGNORES SUBSEQUENT COMMANDS FROM HERE DOWN.
SendKeys "^a", True  '^A selects everything already in the pdf file.
SendKeys "^c", True  '^C copies the selection to the clipboard.
SendKeys "%f", True  'alt f, x to exit Notepad.exe
SendKeys "x", True
'acrobatID.Quit


Debug.Print "start second"

AppActivate notepadID                           ' set the new app as teh active task.


SendKeys "%{END}", True 'Go to end of text file.
SendKeys "^v", True  '^V pastes the new stuff at end of file.
SendKeys "{ENTER}", True

SendKeys "^s", True   

SendKeys "%f", True   'alt f, x to exit Notepad.exe
SendKeys "x", True

notepadID.Quit
acrobatID.Quit

End Sub
Daniel
  • 1,920
  • 4
  • 17
  • 35
elbillaf
  • 1,952
  • 10
  • 37
  • 73

6 Answers6

4

I know this question is old, but I have run into this same problem, but I don't think the answer that was chosen is the correct one.

When you call AppActivate, the script goes on halt, waiting for the target application to terminate. After the application is terminated, the script continues. I see no solution to this issue.

EDIT:

I use a batch-file to call CSCRIPT for the AppActivate command, and I notice you are strictly using a VBS file. Try calling CMD as a new window and pass CSCRIPT //NoLogo //B WScript.CreateObject("WSCript.shell").AppActivate("Window Name") as the argument, and see if that bypasses the issue.

Anthony Miller
  • 15,101
  • 28
  • 69
  • 98
  • I already finished that project and am no longer working that issue; however, this kind of thing surfaces every few years, so I'll keep this in mind for the next go around. thanks, tff. – elbillaf Jan 25 '12 at 18:29
2

Similarly, I was trying to use AppActivate on a pdf document I had opened with a shell command so that I could use SendKeys on it. It would always generate Run Time Error '5'. My solution, eventually was to NOT use AppActivate at all, in fact opening the document brings it to the forefront anyway. The problem is that the SendKeys statement executes immediately after the shell command but the pdf needs a second or two to open up. My solution is to pause the code for a couple seconds before excuting the sendkeys statement.

I used a time delay curtosy of pootle flump. Check out the thread here: http://www.dbforums.com/microsoft-access/1219379-time-delay-vba.html

cloudyjudgement
  • 21
  • 1
  • that worked for me. I used a timing delay like: Application.Wait Now + TimeValue("00:00:2") – Selrac Aug 15 '17 at 11:58
2

After hours of research on various forums, I could figure out that I wont be able to use Adobe library objects and functions with Adobe Reader. The only viable option left was to use Shell Commands to use "save as text" option available in the Adobe Reader's file menu. The shortcut key is Alt+f+a+x+s. I implemented these in the below code which worked perfectly, although I was required to insert delays in some steps.

Sub SavePDFasText()
Dim AdobeReaderPath As String
Dim PdfFilePath As String
Dim PDFid, NotepdId As Double

AdobeReaderPath = "C:\Program Files\Adobe\Reader 10.0\Reader\AcroRd32.exe"
PdfFilePath = "D:\PowerGenMacro\opm_11.pdf"
PDFid = Shell(AdobeReaderPath & " " & PdfFilePath, vbNormalFocus)
Application.Wait TimeSerial(Hour(Now()), Minute(Now()), Second(Now()) + 5)
'Alt+f+a+x is required to save the pdf as text in the adobe reader
SendKeys "%(FAX)", True
Application.Wait TimeSerial(Hour(Now()), Minute(Now()), Second(Now()) + 2)
SendKeys "%S", True
SendKeys "^q", True

End Sub
everton
  • 7,579
  • 2
  • 29
  • 42
Barun Rai
  • 21
  • 1
0

Try sendkeys "%{tab}" to switch windows but then keep only 2 active windows.

or try appactivate only after sendkeys {Tab} so that text entry box is not selected before switchibg windows cmd.

or try try appactivate window name, 1 then sleep 2000 °to allow time to bring that window into focus

Sahara_trip
  • 1
0

This might be more of a comment than an answer, but I don't seem to be allowed to "comment", so...

It's amazing you've gotten as far as you did. Chances are, you're never going to be able to make this work reliably -- period. As soon as you do make it work, something will change about how the Acrobat UI behaves in a future release, or Windows will make another change to the rules for what things can send events to what other things, and then you're hosed again.

What you are probably running into in this case is Windows trying to prevent an application stealing the focus from another when a user is apparently busy interacting with the first one. You see the same kinds of problems trying to do things like have a button in one application write data to a temporary file and open MS Word to edit it. Windows prevents the focus from transferring away from the current app and over to MS Word because you just clicked a button in the current app.

So -- instead of trying to solve this impossible technical issue, let's take a step back and ask what you were originally hoping to accomplish by doing all of this. In that way, perhaps, we can get you where you're trying to go :)

Steve Jorgensen
  • 11,725
  • 1
  • 33
  • 43
  • What I have is a bunch (more than 1000) of PDFs that have text that I want to parse through. Some of the text is free-form and unusable. Other parts of the text are formatted almost consistently and I can get that information and put it into a database (excel spreadsheet) for later analysis. After the data is put into a text file, I parse through with a perl script to get the stuff I want and create a CSV. This is a sucky way to do this - for the reasons you give, also because it is aesthetically ugly and it doesn't seem to work consistently in all cases. – elbillaf Feb 11 '11 at 18:28
  • The general method works if the pdf is only one page, but for multipage, acrobat only selects one page on a ^A (from sendkeys) so I have to go back and forth - which does not appear to work. I was able to get around this issue for my current task, but I would like a general method for addressing this kind of problem so future methods won't be so irritating. – elbillaf Feb 11 '11 at 18:30
  • 1
    Could you use something like http://www.pdf2txt.com/ instead of trying to automate the Acrobat GUI? – Steve Jorgensen Feb 13 '11 at 00:57
0

You forgot to add "DoEvents" between each sendkeys and kind of delay/wait period, to give it some time to execute.

Bracky
  • 1