Groups > comp.lang.basic.visual.misc > #110

Re: VB6 to Excel

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 <gs@somewhere.net>
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	<ip4lv7$gla$1@dont-email.me> (permalink)
References	<aiUsp.26$2z7.14@newsfe15.ams2> <lil8r6ln74mh0g9hfv0lous8a1t8gc7sot@4ax.com> <VA.000001cf.badb0060@rdpslides.com>
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

Show key headers only | View raw

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

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

VB6 to Excel "Ivar" <ivar.ekstromer000@ntlworld.com> - 2011-04-24 13:01 +0100
  Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 09:40 -0400
    Re: VB6 to Excel "Ivar" <ivar.ekstromer000@ntlworld.com> - 2011-04-24 16:04 +0100
      Re: VB6 to Excel ralph <nt_consulting64@yahoo.net> - 2011-04-24 10:54 -0500
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 12:28 -0400
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 14:58 -0400
    Re: VB6 to Excel Steve Rindsberg <steve@rdpslides.com> - 2011-04-24 12:51 -0400
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 13:44 -0400
  Re: VB6 to Excel ralph <nt_consulting64@yahoo.net> - 2011-04-24 12:23 -0500
    Re: VB6 to Excel ralph <nt_consulting64@yahoo.net> - 2011-04-24 12:30 -0500
    Re: VB6 to Excel Steve Rindsberg <steve@rdpslides.com> - 2011-04-25 15:57 -0400
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-25 16:38 -0400
        Re: VB6 to Excel Steve Rindsberg <steve@rdpslides.com> - 2011-04-26 19:54 -0400
          Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-26 23:06 -0400

csiph-web