Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Excel sheet into Web component
Hi,
My goal of my VB form is to be able to select certain things and then display a filter spreadsheet using the Excel component in Microsoft Office Spreadsheet 10.0 control. Can someone tell me how to load an entire excel sheet into my component sheet? After that I should be able to figure out how to filter and display only certain rows/columns. Thanks, RishiD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Excel sheet into Web component
I think you have to loop through each cell in the worksheet.
Dim Rng As Range Application.ScreenUpdating = False For Each Rng In ActiveSheet.UsedRange.Cells Sheet1.Spreadsheet1.Range(Rng.Address).Value = Rng.Value Next Rng Application.ScreenUpdating = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Rishi Dhupar" wrote in message oups.com... Hi, My goal of my VB form is to be able to select certain things and then display a filter spreadsheet using the Excel component in Microsoft Office Spreadsheet 10.0 control. Can someone tell me how to load an entire excel sheet into my component sheet? After that I should be able to figure out how to filter and display only certain rows/columns. Thanks, RishiD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Excel sheet into Web component
Rishi,
Alternatively, have you looked at the OLE control to show Excel ? It takes a little getting used to and I can't say it better than what you're using now. NickHK "Rishi Dhupar" wrote in message oups.com... Hi, My goal of my VB form is to be able to select certain things and then display a filter spreadsheet using the Excel component in Microsoft Office Spreadsheet 10.0 control. Can someone tell me how to load an entire excel sheet into my component sheet? After that I should be able to figure out how to filter and display only certain rows/columns. Thanks, RishiD |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Excel sheet into Web component
Dim Rng As Range
For Each Rng In Sheet1.UsedRange.Cells Spreadsheet1.Range((Rng.Address)).Value = Rng.Value Next Rng This code seems to be working well, is there anyway to keep the formatting of the text? Thanks so much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Excel Component Bug | Excel Discussion (Misc queries) | |||
Set up costing sheet for multiple component recipe. | Excel Discussion (Misc queries) | |||
Loading sheet names in Combobox | Excel Programming | |||
Excel sheet not loading | Excel Discussion (Misc queries) | |||
Loading Sheet Names into Combo Box | Excel Programming |