View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Hutcins John Hutcins is offline
external usenet poster
 
Posts: 19
Default 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