help:- vb <-> excel

[satti charvak]

i've no idea of using excel as database in place of access....pleace help me with some code on how to read and write data from a grid to excel using ado.....


also ..i've to use some functions on excel like cell color change, cell font change, cell border, INSERT PIC FROm VB PICTURE BOX TO EXCEL CELL and change pic's height and width inserted to the excel sheet. please help me wth some pracical example......i'm very fine with ado ...other than the database being excel

[satti charvak]

any help please i'm getting frustrated..................

[alex_read]

Which type of grid are you using? Am I to assume you've got data in an msflexgrid etc. control grid on a vb form & want to place this into a brand new Excel file?

I can give you some code if you explain the above to give me more of an idea of what your trying but I can't understand why you want to use Excel as your database software over Acces or SQL Server for example...

[satti charvak]

I'm using msflex grid with access 2000.....

now for the excel part ...i've to give some selected data from flex grid to my bosses who have only ms-office installed...now what i've to do is to download the data into excel and zip the files and send them thru net......we do't have sql-server or web-page to manage this thru asp-sqlserver combo or any thing like that..

please help me with your source code

[alex_read]

See if this one makes any sense & let me know if you need any further help...

[satti charvak]

THANKS Alex, I had MSDN, but was not able to work on it as i didn't have any idea.....for othrer properties like cell color, fonts, borders, merging etc.

i've found the help from msdn but still I'm not able to add pics from the pic box in vb to the excel sheet....

please help me on this

I'll upload my vb-excel code once it is done ...for other's help

[satti charvak]

hi ....,

the vb to excel is running properly in my computer.... i made a installer for the same project and installed that on other's system.....I had excel-xp and the person is using excel-97. Now when try to export the data to excel sheet it give automaion error.... please help me on this error......

y is this coming in the first place....also what might be the reasons for his error.

do i have put something extra in my project to make ir running in EXCEL-97 9x, dll etc etc)

[alex_read]

When you create your reference to the Excel Application object, you'll have to use late binding - I susspect at the moment you're using the project menu > references option then calling the object out...

If you want this code to work with ny version of Excel, you're going to have to create your Excel Application object like this:

Dim objXlApp as object
set objXlApp = createobject("Excel.application")