Macro writing a Macro

[John Vickers]

I want to create a macro that can write info to the "ThisWorkbook" module. Anyone know how to do it?

John Vickers

[Bob Phillips]

See Chip's page at http://www.cpearson.com/excel/vbe.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"John Vickers" <[email protected]>
wrote in message
news:[email protected]...
>
> I want to create a macro that can write info to the "ThisWorkbook"
> module. Anyone know how to do it?
>
> John Vickers
>
>
> --
> John Vickers
> ------------------------------------------------------------------------
> John Vickers's Profile:
http://www.excelforum.com/member.php...o&userid=31551
> View this thread: http://www.excelforum.com/showthread...hreadid=512923
>

[John Vickers]

Ok, I got this to work, but when I run the macro, it shows the vb editor. Is there a command to disable this so it will just run in the background without showing what it changed?

John Vickers

[Bob Phillips]

Don't think so, it needs to work on the window. You could use Sendkeys to
close it down after.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"John Vickers" <[email protected]>
wrote in message
news:[email protected]...
>
> Ok, I got this to work, but when I run the macro, it shows the vb
> editor. Is there a command to disable this so it will just run in the
> background without showing what it changed?
>
> John Vickers
>
>
> --
> John Vickers
> ------------------------------------------------------------------------
> John Vickers's Profile:
http://www.excelforum.com/member.php...o&userid=31551
> View this thread: http://www.excelforum.com/showthread...hreadid=512923
>