I need a help in VB interface to other excel applications
jasworld
0
Newbie Poster
Recommended Answers
Jump to Post' /* 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 …
All 3 Replies
Comatose
290
Taboo Programmer
Team Colleague
' /* 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
jasworld
0
Newbie Poster
it seems that is not working
Comatose
290
Taboo Programmer
Team Colleague
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.