Opening the visual basic editor window from code.

[marklenel]

Is it possible to open the visual basic editor window from code? If so how?

 

[flyover789]

try:

SendKeys "%{F11}"

HTH,
fly

Martin Serra Jr.

http://www.mserrasystems.de

 

[marklenel]

Many thanks Martin,

That's one of the things we've tried. However, if I give you a little more context you'll see why it's not working for our particular situation.

I've password-protected the code and form design in a database that is distributed on a number of computers. I need to update this database as a number of forms and some of the code has changed.

I need to access the VB window in order to 'SendKeys' the password to unlock the code (I can't find any other way of sending the password!).

Unfortunately, as part of the lockdown, I've also set the startup properties so that all the standard toolbards are no longer accessible. For this reason, SendKeys Alt-F11 doesn't work, as the standard toolbar isn't there!

So I'm looking for another method, via code, to either unlock the code or open the VB window (allowing SendKeys to plug in the password).

If you've any other suggestions I'm all ear!

Thanks,
Mark

 

[flyover789]

assuming that you are working in a front-/back-end environment, I'd think about how to most efficiently redestribute new fron-ends ...

Regrads,
fly

Martin Serra Jr.

http://www.mserrasystems.de

 

[marklenel]

I agree! We started looking at copying only new and updated objects to the original system, then came across this problem.

Our current solution is to replace the entire front-end, and copy relevant data from the old system to the new one.

 

[DeanWilliams]

Hi,

If you want to open a specific module you can use:

VBE.VBProjects(1).VBComponents("Form_FormName").CodeModule.CodePane.Show

HTH,
Dean