please help me how to access excel files (each cell) using VB, and how to manipulate them and save to a new excel file. i am new to visual basic. how access each cells in an excel file.
dim objExcel as Excel.Application ' early binding set objexcel = new excel.application
objexcel.open "xxx.xls" rem objexcel.workbook(0).worksheet(0).range("A1").value = "new text" objexcel.Worksheets.Item("Sheet1").Range("A1").Value = "new text"
objexcel.quit ' or exit / or something set objexcel = nothing
this could has errors, by the way...
---- : hello friends : : please help me how to access excel files (each cell) using VB, and how to manipulate them and save to a new excel file. : i am new to visual basic. : how access each cells in an excel file. : :
: I will try... : : dim objExcel as Excel.Application ' early binding : set objexcel = new excel.application : : objexcel.open "xxx.xls" : rem objexcel.workbook(0).worksheet(0).range("A1").value = "new text" : objexcel.Worksheets.Item("Sheet1").Range("A1").Value = "new text" : : objexcel.quit ' or exit / or something : set objexcel = nothing : : this could has errors, by the way... : : ---- : : hello friends : : : : please help me how to access excel files (each cell) using VB, and how to manipulate them and save to a new excel file. : : i am new to visual basic. : : how access each cells in an excel file. : : : : : : [red]Good luck![/red] : [blue]Hackman[/blue] : :
Does range "A1" covers all the rows / cols in specific sheet ? Tried it and I got only the first range in the sheet, but few rows after I have more data...
Comments
dim objExcel as Excel.Application ' early binding
set objexcel = new excel.application
objexcel.open "xxx.xls"
rem objexcel.workbook(0).worksheet(0).range("A1").value = "new text"
objexcel.Worksheets.Item("Sheet1").Range("A1").Value = "new text"
objexcel.quit ' or exit / or something
set objexcel = nothing
this could has errors, by the way...
----
: hello friends
:
: please help me how to access excel files (each cell) using VB, and how to manipulate them and save to a new excel file.
: i am new to visual basic.
: how access each cells in an excel file.
:
:
[red]Good luck![/red]
[blue]Hackman[/blue]
:
: dim objExcel as Excel.Application ' early binding
: set objexcel = new excel.application
:
: objexcel.open "xxx.xls"
: rem objexcel.workbook(0).worksheet(0).range("A1").value = "new text"
: objexcel.Worksheets.Item("Sheet1").Range("A1").Value = "new text"
:
: objexcel.quit ' or exit / or something
: set objexcel = nothing
:
: this could has errors, by the way...
:
: ----
: : hello friends
: :
: : please help me how to access excel files (each cell) using VB, and how to manipulate them and save to a new excel file.
: : i am new to visual basic.
: : how access each cells in an excel file.
: :
: :
:
: [red]Good luck![/red]
: [blue]Hackman[/blue]
:
:
Does range "A1" covers all the rows / cols in specific sheet ?
Tried it and I got only the first range in the sheet, but few rows after I have more data...