Unwanted "beeps" during macro when it minimizes the Adobe window

jerry12302

Active Member
Joined
Apr 18, 2005
Messages
407
I have code that opens adobe files, copies their content, and pastes it into a range in Excel. It works OK, but as it cycles through the Adobe files, one at a time, every time it minimizes the Adobe window to get back to Excel, during
SendKeys ("%n"), True, it beeps. (I've isolated this portion of the macro through trial and error, this is the code that triggers the beep) This gets annoying when there are several files to load.

Is there some VBA code to turn off the audible beep sound during a macro? Or another way to set the focus back to Excel so the data can be pasted, instead of minimizing the Adobe window?

I don't want to turn down the volume, in case there are other non-related alerts or notifications that need attention afterward.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,119,182
Messages
5,576,569
Members
412,733
Latest member
korayuyanik
Top