jerry12302
Active Member
- Joined
- Apr 18, 2005
- Messages
- 449
- Office Version
- 2010
- Platform
- Windows
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.
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.
