Member Avatar for jasworld

I need a help in VB interface to other excel applications

  • 2 Contributors
  • 3 Replies
  • 110 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Comatose
Member Avatar for Comatose 
' /* Dimension Object Variables */
Dim ojbExcel

' /* Create The Object */
Set objExcel = CreateObject("Excel.Application")

' /* Actually Open The File */
Set objWorkbook = objExcel.Workbooks.Open("c:\path2your\file.xls")

' /* Choose Which Worksheet (or Tab) We Are Working With */
objExcel.ActiveWorkbook.Sheets(1).Select()

' /* Read The Value From The Cell At Row 2, Column 1 */
CellValue = objExcel.Cells(2, 1).Value

' /* Change The VAlue Of The Cell At Row 1, Column 1 */
objExcel.Cells(2, 1).Value = "Fun"

' /* Actually Show The Excel Window */
objExcel.Visible = true

' /* I Don't Care Who You Are, When You Use Objects, Always Unload Them */
set objExcel = nothing
Member Avatar for jasworld

it seems that is not working

Member Avatar for Comatose

do you get an error?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.