Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BuskyLusky

    VBA with OLE Excel Automation

    Hi. I have some problem writing my own values to an Excel Ole Object. I add an OLE object, then selects MicroSoft Office Excel Chart. Then an example chart is shown. I wish to edit this one to use my own data, which I may extract from the VBA form. If you try to edit the excel object by right...
  2. BuskyLusky

    ERROR code 91, when reading excel Sheet

    Hi I have a problem with this code: ------------------------------------ Dim xlTmp As Excel.Application Dim xlSht As Excel.Worksheet ------------------------------------ Public Sub Form_Initialize() Set xlTmp = New Excel.Application xlTmp.Workbooks.Open "\database.xls" Set...
  3. BuskyLusky

    Excel Reading with VBA

    Thanks I figured it out, simply by typing this code: ---------------------------------------- Dim xlTmp As Excel.Application Dim xlSht As Excel.Worksheet ---------------------------------------- Private Sub CommandButton5_Click() Label1.Caption = xlSht.Cells(5, 5)...
  4. BuskyLusky

    Excel Reading with VBA

    Ok. Forget about ADO and the question above. I have an excel sheet with 10 collumns and 10 rows. I wish to read one cell at the time and use them in a formula programmed in VBA. How can this be done?
  5. BuskyLusky

    Excel Reading with VBA

    Hello, I have a problem concerning the use of VBA to read an excel data sheet. I have searched many forums, but I feel this one is the best qualified. As I understand one should use ADO to read the excel file. Is there anyone who could really give me a good example in how it is done? From an...

Part and Inventory Search

Back
Top