Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: GS Newsgroups: comp.lang.basic.visual.misc Subject: Re: VB6 to Excel Date: Mon, 25 Apr 2011 16:38:08 -0400 Organization: A noiseless patient Spider Lines: 26 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15"; format=flowed Content-Transfer-Encoding: 8bit Injection-Date: Mon, 25 Apr 2011 20:35:52 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="UVJBuiIZprDyxzUkJsiwfw"; logging-data="17066"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Ez4bzFZN7yF4uIADidkxA" X-Antivirus-Status: Clean X-Newsreader: MesNews/1.08.03.00-gb X-Antivirus: avast! (VPS 110425-0, 04/25/2011), Outbound message Cancel-Lock: sha1:WJ8zF/cnuq/dhn2yDwxgKukXNpI= X-ICQ: 543516788 Xref: x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.misc:110 Steve Rindsberg presented the following explanation : >> But as the others have already pointed out, there isn't much >> difference between having a 'macro module' file you import into new >> projects/workbooks or simply having a 'seed workbook/project', aka a >> Template which already includes the macros you might want to use. > > I haven't done enough with Excel to say whether this'd be true as in > some other Office products, but the ability to add code *via* code may > be dependent on the user's security settings; they may not allow access > to the visual basic project. Hi Steve, The security settings are suppressed for automated instances. In this case it might be possible regardless of user rights. As I already stated, I've never written VBA programmatically but I've acted on the VBE enough to know it's doable in an automated instance. HTH -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc