General discussion

Locked

Visual Basic 6 to Excel

By mike.shumaker ·
Hi everyone. I am very new to VB and I want
to draw data to a VB front end from an Excel
spread sheet. I was hoping someone could give
me a little help. Thanks in advance!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Visual Basic 6 to Excel

by Peyison In reply to Visual Basic 6 to Excel

Hard to be complete in this limited space, so here's a link that should tell you everything you need, including example code:

http://www.thescarms.com/VBasic/ExcelExport.asp

While you're at it, check out his other VB articles and samples:

http://www.thescarms.com/VBasic/VBasicDesc.asp

(remove any spaces in the above URLs)

Hope this helps.

Collapse -

Visual Basic 6 to Excel

by mike.shumaker In reply to Visual Basic 6 to Excel

The question was auto-closed by TechRepublic

Collapse -

Visual Basic 6 to Excel

by steven_v_brown In reply to Visual Basic 6 to Excel

I use the excel.application object from both vb and excel's vba: below are some scripts that I use:
(I learn best by example maybe you do also - want specific examples email me - steven_v_brown@hotmail.com)
(I can not past much below due to space limits...)

'---------------------------------------------------------------------------
'Modules Written by Steven V Brown
'---------------------------------------------------------------------------
Option Explicit
'---------------------------------------------------------------------------

Collapse -

Visual Basic 6 to Excel

by mike.shumaker In reply to Visual Basic 6 to Excel

The question was auto-closed by TechRepublic

Collapse -

Visual Basic 6 to Excel

by mike.shumaker In reply to Visual Basic 6 to Excel

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums