Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
S

salowist

@salowist
About
Posts
3
Topics
0
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Excel mystery
    S salowist

    Sorry, didn't catch that in your orig post. Have you tried saving it as an xlsb (Binary Workbook) file or ,depending on what your code does, as an xlam (Add-In)? Here is the vbs script to add a trusted location to an office program

        Dim WshWhell
    Set WshShell = CreateObject("WScript.Shell")
    
    'Acceptable Office Version Values: 2003 = 11.0, 2007=12.0, 2010=14.0
        'Acceptable Program Values: Excel,Access, Outlook, PowerPoint, Word, Visio.
        'There is a "Common" program group that may possibly be used but I haven't tried it yet.
    	'The location ID is a unique value such as "LOCATION99"
    
    RegEdPath= "HKEY\_CURRENT\_USER\\SOFTWARE\\MICROSOFT\\OFFICE\\(Office Version)\\(Program)\\SECURITY\\TRUSTED LOCATIONS\\(LocationID)\\"
    
    WshShell.RegWrite  RegEdPath  , ""
    	WshShell.RegWrite  RegEdPath & "PATH" , "C:\\MyTrustedPath"
    	WshShell.RegWrite  RegEdPath & "Description" , "Description"		
    	WshShell.RegWrite  RegEdPath & "AllowsubFolder" , 1 , "REG\_DWORD"
    
    The Lounge help question

  • Excel mystery
    S salowist

    Have you tried converting the spreadsheet to 2007? It would require security changes but it may just work. I have a vbs script that adds trusted locations via the registry if you need.

    The Lounge help question

  • Excel mystery
    S salowist

    Do you know if any of the Korean users can add a module manually?

    The Lounge help question
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups