Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!feeder.news-service.com!85.214.198.2.MISMATCH!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: Tue, 26 Apr 2011 23:06:56 -0400
Organization: A noiseless patient Spider
Lines: 34
Message-ID: <ip813a$fcl$1@dont-email.me>
References: <aiUsp.26$2z7.14@newsfe15.ams2> <lil8r6ln74mh0g9hfv0lous8a1t8gc7sot@4ax.com> <VA.000001cf.badb0060@rdpslides.com> <ip4lv7$gla$1@dont-email.me> <VA.000001d1.c0da4e85@rdpslides.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 27 Apr 2011 03:04:10 +0000 (UTC)
Injection-Info: mx02.eternal-september.org; posting-host="UVJBuiIZprDyxzUkJsiwfw"; logging-data="15765"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19Pt+1I3kWWIpUW/KQS06dU"
X-Antivirus-Status: Clean
X-Newsreader: MesNews/1.08.03.00-gb
X-Antivirus: avast! (VPS 110426-0, 04/26/2011), Outbound message
Cancel-Lock: sha1:21K5zpjSb9VMN+gL06jfJFGPMXA=
X-ICQ: 543516788
Xref: x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.misc:115

Steve Rindsberg laid this down on his screen :
> In article <ip4lv7$gla$1@dont-email.me>, Gs wrote:
>> 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.
>
> Ah, thanks.  That's good to know.  I was fairly certain that there'd be no 
> macro warnings in an automated instance but wasn't sure about access to the 
> VBE.

Well, as I said, I don't write code programmatically so I don't know if 
that'll be possible. Thought I only suspect it's doable since we can 
access the VBE in automated instances with no problem.<g>

-- 
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc