Results 1 to 3 of 3

Thread: Changing .xls opening behavior through VB

  1. #1

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    104

    Changing .xls opening behavior through VB

    Good Day,
    I am creating an application that will set some default settings for a blank load on a computer. For example, we have an application that ppl use on a daily basis that requires a lot of things to happen to a computer before you run this application. (I did not write this program!!! What my program does is setup a user account, setup an admin account, force classic start menu, force classic control panel, and the last thing I need to do is this:

    In folder options

    My Computer-Tools-Folder Options-File Types Tab--.xls-Advanced-Open-Uncheck Browse in Same Window----Check Confirm Open After Download.

    Now My question is this. Does anybody know how to set this up in code or perhaps where this info can be found in the registry then I can do the code myself.

    thanks,
    Pol

  2. #2

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Posts
    104

    Re: Changing .xls opening behavior through VB

    Anybody have anything on this possibly??

  3. #3
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Changing .xls opening behavior through VB

    The information is probably stored in the registry. To find out where you may need to use a registry monitor utility (freeware) that will track your changes when you uncheck it. Then when you find the location you can automate this with some code to write the chage to the registry.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width