Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Editing Code
the only way would be with sendkeys.
Hardly reliable. -- Regards, Tom Ogilvy Walt Weber wrote in message ... Hi, Some time ago I wrote an application now used at many worksites (All sites use Excel 2000 or 2002 on Windows platforms from Win95 through Win XP, Win NT4.0, and Win 2000) scattered about the western US. It's now important to distribute an update to those applications. In looking through the item titled "Programming To The Visual Basic Editor" on Chip Pearson's web site (http://www.cpearson.com/excel/vbe.htm), I see the following notations included: "Before using these procedures, you'll need to set a reference in VBA to the VBA Extensibility library. In the VBA editor, go to the Tools menu, choose the References item, and put a check next to "Microsoft Visual Basic For Applications Extensibility" library. This enables VBA to find the definitions of these objects. If you are using Excel97, this library will appear in the References list without a version number: "Microsoft Visual Basic For Applications Extensibility". If you are using Excel 2000 or 2002, it will appear with a version number: "Microsoft Visual Basic For Applications Extensibility 5.3". It is very important that you reference the proper library. If you reference the wrong library, you will receive "Type Mismatch" errors. If you don't reference the extensibility library at all, you will receive "User Defined Type Not Defined Error"." Setting the reference to Microsoft Visual Basic For Applications Extensibility 5.3 in my update routine within an 'update.xls' file should deal with this. And "Note: An additional level of security was added in Excel 2002. To manipulate the VBA Project objects as described here, you'll have to change your security setting. Go to the Tools menu, choose Macros, then Security. Click the "Trusted Sources" tab, and put a check next to the "Trust access to Visual Basic Project". NOTE: In all versions of Excel, the VBProject must not be protected. If it is, these procedures will fail. In Excel 2002, you must have "Trust Access To Visual Basic Project" enabled." While I can instruct those with Excel 2002 to 'put a check next to the "Trust access to Visual Basic Project"', the code is password protected (I set the password). Is there some way I can send the password to the VBE to open and edit the code? I can and have written routines to export all site specific data and then import that data into a new version, but this approach is cumbersome. Editing the code would be much nicer. Best Regards, Walt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Need help editing this code | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |