software

I want to create a macro that can write info to the quot;ThisWorkbookquot;
module. Anyone know how to do it?

John Vickers--
John Vickers
------------------------------------------------------------------------
John Vickers's Profile: www.excelforum.com/member.php...oamp;userid=31551
View this thread: www.excelforum.com/showthread...hreadid=512923See Chip's page at www.cpearson.com/excel/vbe.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;John Vickersquot; gt;
wrote in message
news:John.Vickers.23aiko_1140039607.9126@excelforu m-nospam.com...
gt;
gt; I want to create a macro that can write info to the quot;ThisWorkbookquot;
gt; module. Anyone know how to do it?
gt;
gt; John Vickers
gt;
gt;
gt; --
gt; John Vickers
gt; ------------------------------------------------------------------------
gt; John Vickers's Profile:
www.excelforum.com/member.php...oamp;userid=31551
gt; View this thread: www.excelforum.com/showthread...hreadid=512923
gt;

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: www.excelforum.com/member.php...oamp;userid=31551
View this thread: www.excelforum.com/showthread...hreadid=512923Don'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)

quot;John Vickersquot; gt;
wrote in message
news:John.Vickers.23c0qm_1140109801.1115@excelforu m-nospam.com...
gt;
gt; Ok, I got this to work, but when I run the macro, it shows the vb
gt; editor. Is there a command to disable this so it will just run in the
gt; background without showing what it changed?
gt;
gt; John Vickers
gt;
gt;
gt; --
gt; John Vickers
gt; ------------------------------------------------------------------------
gt; John Vickers's Profile:
www.excelforum.com/member.php...oamp;userid=31551
gt; View this thread: www.excelforum.com/showthread...hreadid=512923
gt;