1. Ruddles

    Read current audio volume setting

    Hi Everyone, I know how to change the audio volume level setting using VBA by sending the VK_VOLUME_UP and VK_VOLUME_DOWN codes to the virtual keyboard, but my code also needs to know what the actual level is. I've been trying to persuade The Google to tell me but haven't even got as far as...
  2. V

    Toggle between two values in registry

    Hi Guys, How to modify a batch script to toggle between the two values when execute. Any help would be much appreciated. @echo off for /F "skip=2 tokens=2*" %%A in ('reg query "HKLM\Software\microsoft\windows\CurrentVersion\Policies\System" /v "EnableLUA"') DO (Echo %%B) If %%B==0x0 ( reg add...
  3. N

    How to add a trusted document in Excel via .reg file?

    I am deploying a macro entry file to various people. I would like the computers to trust this file ask quickly as possible. Some system can trust as easily as one click Enable macro. Others have to face multiple warnings and jump through multiple windows to trust the location. I think trusting...
  4. rediffusion

    How to backup settings of Microsoft Office which are in registry branches?

    Cross-post! CloneApp - this is a software that allows you to copy/backup the desired registry branches. Want to understand how from the registry backup what I need (I just do not know where to look, there are a lot of things written) !? Settings - ContextMenuCell, ContextMenuPly...
  5. D

    Timeout of 100 seconds

    I have 40 queries. When I "Refresh All" I often encounter "the function didn't finish within timeout of 100 seconds." I find, once it craps out, it cannot recover and waiting 100 seconds is too long. Each query normally takes 2-3 seconds, so I can tell quickly that it's failing. Is...
  6. M

    re-work this macro (create new row)

    Instead of "find next row to paste to on Discharges", how could I have this macro create a new row between row 1 & 2 to paste to information there. This way, my most current information would always be on top. Private Sub CommandButton1_Click() Dim lr As Long Dim r As Long Dim...
  7. E

    Find and delete windows registry key with specific value

    Hello, I am struggling for quite a while with a problem regarding the windows registry... I want to find and delete a registry key with a specific value in the registry folder: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options The relevant registry keys are named "OPEN"...
  8. F

    How to tell Excel 2010 to open Excel macro files (xlsm) in separate windows

    I have been trying to figure out which registry keys need to be modified in order to open macro enabled excel files (*.xlsm) in separate windows? I followed the instructions on the following pages Microsoft How-To (if you want to open *.xlsx files in separate windows) and relation between...
  9. C

    Creating keys in the Registry from VBA

    Friends, I am having trouble creating a key in the registry from VBA. I have the proper declaration for RegCreateKeyEx. I am able to use the following code to attempt to create HKEY_CLASSES_ROOT\Admin (which already exists). The return value is 0 with a status of 2 meaning "already exists"...
  10. D

    Win7 wallpaper rotation disrupted each time

    Hi guys, Today I have a question totally not related to Excel. But I hope that your expertise can also support in this case. This has been bugging for a long while now. I have a question about influencing the Win7 wallpaper rotation via batch or other code. The issue I encounter is like...
  11. D

    Addin Order in Registry

    Hello, I have this situation at my work place: -there is an big add-in that is frequently being updated by someone else (uninstalls add-in and re installs it, and creates an excel menu so the users can handle the macros easier) -i have been asked to create a separate add-in, but with references...
  12. Jaafar Tribak

    Can't find the ClassId of the VBIDE ?

    Hi dear board members.- I've looked in the Registry but cannot find the entry for the 128 bit CLSID of the VBIDE COM object. Does anybody know it ? The one for the Excel application is located in the reg Key: <TABLE style="WIDTH: 60pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back