VB and Excel

ivanlaw · July 4th, 2007, 01:57 AM

Is it excel file can import to the vb file???
please help me...

ashu_from_india · July 4th, 2007, 02:07 AM

ur question is not clear...wht exactly u wanna do????
if u mean tht u wanna fetch data from Excel file from V6 then, u can do it using VBA
search google for "VBA with Excel examples"

ivanlaw · July 4th, 2007, 04:25 AM

Like that thanks a lots.:D

Quote:

quote:Originally posted by ashu_from_india
ur question is not clear...wht exactly u wanna do????
if u mean tht u wanna fetch data from Excel file from V6 then, u can do it using VBA
search google for "VBA with Excel examples"

ivanlaw · July 9th, 2007, 02:09 AM

Sorry ask again...So the VBA can't be an installer to install in the computer,right?:D

Quote:

quote:Originally posted by ivanlaw
Like that thanks a lots.:D

Quote:

quote:Originally posted by ashu_from_india

Quote:

ur question is not clear...wht exactly u wanna do????
if u mean tht u wanna fetch data from Excel file from V6 then, u can do it using VBA
search google for "VBA with Excel examples"

Shasur · July 9th, 2007, 02:15 AM

ivanlaw

Do you mean Install for 'Creating a Setup for Deployment'. If that is the case then VBA would not help you in creating Setup. You need to use VB6.0 Package and Deployment wizard for that.

On the otherhand, if you want to distribute your macros to others you can give them as part of Excel file (As Excel Addins (.xla)

Hope iy gives you better clarity

Regards
Shasur

http://www.dotnetdud.blogspot.com

ivanlaw · July 10th, 2007, 01:17 AM

That is right.But like that...Is it the Excel file can import to the VB 6.0???
Or got any method to do that???

Thanks~

Quote:

quote:Originally posted by Shasur
ivanlaw

Do you mean Install for 'Creating a Setup for Deployment'. If that is the case then VBA would not help you in creating Setup. You need to use VB6.0 Package and Deployment wizard for that.

On the otherhand, if you want to distribute your macros to others you can give them as part of Excel file (As Excel Addins (.xla)

Hope iy gives you better clarity

Regards
Shasur

http://www.dotnetdud.blogspot.com

Shasur · July 10th, 2007, 03:17 AM

Here is the way you can access Microsoft Excel from VB6.0

1. Include the Microsoft Excel 9.0 Library in your project reference (Project menu --> References)

2. Use the following code to get the Excel Application

Dim oXlApp As Excel.Application
Dim oDataFile As Excel.Workbook

Set oXlApp = New Excel.Application
Set oDataFile = oXlApp.Workbooks.Open("c:\sample.xls")

..

you can use all the objects you use in Excel VBA in Vb6.0 now on

Cheers
Shasur

http://www.dotnetdud.blogspot.com

ivanlaw · July 11th, 2007, 02:40 AM

I put all the code you give in the form load,but still can not do it.Why?
Then another question is how did I fully utilize the OLE component???
Please teach me...:)
Thanks~:D

Quote:

quote:Originally posted by Shasur
Here is the way you can access Microsoft Excel from VB6.0

1. Include the Microsoft Excel 9.0 Library in your project reference (Project menu --> References)

2. Use the following code to get the Excel Application

Dim oXlApp As Excel.Application
Dim oDataFile As Excel.Workbook

Set oXlApp = New Excel.Application
Set oDataFile = oXlApp.Workbooks.Open("c:\sample.xls")

..

you can use all the objects you use in Excel VBA in Vb6.0 now on

Cheers
Shasur

http://www.dotnetdud.blogspot.com

Shasur · July 11th, 2007, 03:11 AM

Hi ivanlaw

Can you post the part of the code that is showing error. This should be useful in fixing the problem

Regards
Shasur

http://www.dotnetdud.blogspot.com

ivanlaw · July 12th, 2007, 08:11 PM

So strange.Today just try it no error,but all the thing can not display.
I can't find the Microsoft Excel 9.0 Library ,but include Microsoft Excel 11.0 Library.Is it correct or useful ???
:(

Quote:

quote:Originally posted by Shasur
Hi ivanlaw

Can you post the part of the code that is showing error. This should be useful in fixing the problem

Regards
Shasur

http://www.dotnetdud.blogspot.com