ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change Registry in VBA (https://www.excelbanter.com/excel-programming/362365-change-registry-vba.html)

John Hutcins

Change Registry in VBA
 
I want to print a series of reports to MODI in Excel without opening the MODI
viewer. I found a post here that said it is a checkbox in the savefile
dialog that you need to uncheck.

its registry key is he
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\M ODI\MDI writer
DWORD OpenInMODI=0

Can I do this directly in my VBA code? I've never worked with a registry
setting.
Thanks for any help!
John


All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com