Import excel file into MSFlexgrid

[DarkX_Greece]

Hello ,

i would like to import an excel file into a MSFlexGrid but when I try the Datasource way it doesn't work. Does anyone has any code available?

[Siddharth Rout]

Does this help?

http://www.freevbcode.com/ShowCode.asp?ID=7354

you will have to extract the code from the part where it is importing to excel...

Hope it helps...

[DarkX_Greece]

thanks, but it doesn't work.

[Siddharth Rout]

thanks, but it doesn't work.

What exactly doesn't work? Are you getting any error messages? or is there any code missing?

[DarkX_Greece]

I took a screenshot of the error.
Here is the screenshot:

[Siddharth Rout]

Oh, Ok...

After you open the project, don't run it. Like I said in my previous post you will have to extract the code...

Check out the code in the form ExcelImportDataFile under

Public Sub ReadExcelFile()
End Sub

Hope this helps...

[jcis]

See these examples
http://www.vbforums.com/showthread.php?t=393082

[DarkX_Greece]

Oh, Ok...

After you open the project, don't run it. Like I said in my previous post you will have to extract the code...

Check out the code in the form ExcelImportDataFile under

Public Sub ReadExcelFile()
End Sub

Hope this helps...

I know this example and I extracted the code yesterday. I have the same problem.

That's why I wrote that I have problems with the DataSource method.

[DarkX_Greece]

See these examples
http://www.vbforums.com/showthread.php?t=393082

This sample helped me a little but when I don't know how many cells to copy, what could I do?

[Siddharth Rout]

@jcis: That's a damn neat code

[jcis]

This sample helped me a little but when I don't know how many cells to copy, what could I do?

So you want the Flexgrid to look exactly like the Workseet? If so there is a property of the worksheet i think, something like UsedRange, you can send that to Clipboard and use UsedRange.Columns or something like that to get the columns and row count, if this doen't work you can still do it Splitting the string in the Cliopboard, the separator is vbTab. When you have as many rows and cols are needed then paste in the Flex.