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

One line of code messed up!
 

might help if you post the code

--
Message posted from http://www.ExcelForum.com

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

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/

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