Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
One line of code messed up!
I have one line in one module of an Excel VBA code messed
up. I need to write another VBA code that will open the VBA attached to an excel file, open the VBA password, go to that module and alter the one line...HELP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
One line of code messed up!
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
One line of code messed up!
Why can't you just open it as normal, go to the VB IDE and change it?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "scrabtree23" wrote in message ... I have one line in one module of an Excel VBA code messed up. I need to write another VBA code that will open the VBA attached to an excel file, open the VBA password, go to that module and alter the one line...HELP |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
One line of code messed up!
Reread the original question.
-- Regards, Tom Ogilvy "ianripping " wrote in message ... might help if you post the code? --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
One line of code messed up!
VBA password is not exposed as an object.
Only solutions I have seen offered for this involve the use of sendkeys. You can search the google groups archive if you need a sample. Search on VBA (or VBE), password and sendkeys. -- Regards, Tom Ogilvy "scrabtree23" wrote in message ... I have one line in one module of an Excel VBA code messed up. I need to write another VBA code that will open the VBA attached to an excel file, open the VBA password, go to that module and alter the one line...HELP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
Combined line-scatter graph with 2 Y-axis messed up | Charts and Charting in Excel | |||
messed up tab key | Excel Discussion (Misc queries) | |||
Lookup really messed up | Excel Discussion (Misc queries) | |||
I messed up and need help | New Users to Excel |