I have developed the following process to prepare Access 2007 databases before deployment:
NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk/forums/showthread.php?t=219948
Is there a similar capability in Excel 2007? I came across this site:
"VBA Code Decompiler and Compactor"
http://orlando.mvps.org/VBADecompilerMore.asp
Which makes it sound like it is possible. But is it possible to do so without requiring that tool? I see references that there is no /decompile command line switch for Excel.
NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk/forums/showthread.php?t=219948
Is there a similar capability in Excel 2007? I came across this site:
"VBA Code Decompiler and Compactor"
http://orlando.mvps.org/VBADecompilerMore.asp
Which makes it sound like it is possible. But is it possible to do so without requiring that tool? I see references that there is no /decompile command line switch for Excel.