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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,118,141
Messages
5,570,409
Members
412,323
Latest member
DemonX
Top