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

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

Re: VB6 to Excel

Show all headers | View raw

It happens that Ivar formulated :
> Thank you for your reply
> .Select - That's the bit I was missing. Got it now
>
> After adding a reference to "Microsoft Visual basic for Applications 
> Extensibility" to the VB6 project I can now add a std Module to the Excel 
> Project files and add code to that. 

While you're at it you could predesign your worksheet[s] 
(formatting/formulas already in place) so all you need to do from VB6 
is dump your data into the appropriate cells.

> I would still rather put the code in the click event of the button tho.

The type of button your using doesn't have a 'click event'. As Gord 
suggests, you assign a macro to it. This is done programmatically by 
specifying the macro when setting its "OnAction" property as shown in 
my code sample.

To do this manually you can right-click the button and choose 'Assign 
macro' on the popup menu.

If you prepare the Excel file beforehand you can have the controls in 
place with caption text, formatting, and macros assigned. (Requires the 
macros also exist, preferably in a standard module.)

>
> Using the Macro recorder is an easy way to get the VBA sintax, it's 
> unfortunate that you can't use the macro recorder to record that fact that 
> you are creating a macro. Oh well :-)

Not sure what you mean here. Using the macro recorder to record a macro 
does (by attrition) do just that. Problem is the generated code almost 
always needs cleanup/refining editing.

-- 
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