Using VB to write VB

WalterBillington · Joined: 13 Oct 2007 Posts: 1

Hey

I use VB in Excel in a financial forecasting context. One of the things I
want to be able to do, but can't figure out, is (1) install code into newly
created worksheets - i.e. so that on sheet deactivate the sheet deletes, and
(2) edit code in modules - i.e. the VB would edit the code.

Any ideas?

Thanks

Walter

Archived from group: microsoft>public>vb>enterprise

amdrit · Joined: 04 Oct 2007 Posts: 8

The newsgroup that you want is microsoft.public.excel.programming

To access the VBA code in excel, you can make use of Application.VBE

To work with the worksheets, you can make use of Application.Workbooks,
Activeworkbook.Sheets

"WalterBillington" wrote in message @uwe...
> Hey
>
> I use VB in Excel in a financial forecasting context. One of the things I
> want to be able to do, but can't figure out, is (1) install code into
> newly
> created worksheets - i.e. so that on sheet deactivate the sheet deletes,
> and
> (2) edit code in modules - i.e. the VB would edit the code.
>
> Any ideas?
>
> Thanks
>
>
> Walter
>

WalterBillingham via VBMo · Joined: 14 Oct 2007 Posts: 1

Good one - many thanks, that led me to where I wanted to go!

amdrit wrote:
>The newsgroup that you want is microsoft.public.excel.programming
>
>To access the VBA code in excel, you can make use of Application.VBE
>
>To work with the worksheets, you can make use of Application.Workbooks,
>Activeworkbook.Sheets
>
>> Hey
>>
>[quoted text clipped - 10 lines]
>>
>> Walter

--
Message posted via VBMonster.com
http://www.vbmonster.com/Uwe/Forums.aspx/vb-ent/200710/1