Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: VB6 to Excel

Show all headers | View raw

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.

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