•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 391,661 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,820 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our VB.NET advertiser:
Views: 3900 | Replies: 2
![]() |
•
•
Join Date: Feb 2007
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Hello!
I'm fairly new to VB, but I have some C, C++ background.
I'm trying to open an existing Excel Document, and add data in specific ranges from Text box inputs in my VB program. However I cannot seem to be able to do this.
The closest I've gotten was to Open the document, and save data, but it erases the items that were already in that document.
Can anyone help me out with this?
Here's what I have so far, haven't incorporated getting the data from the Text boxes yet - as I wanted to ensure the saved document would have the added information, along with the pre-existing data.
Dim oExcel As Excel.Application = New Excel.Application
oExcel.Workbooks.Open("C:\J\Test.xls")
Dim oBook As Object
Dim oSheet As Object
oBook = oExcel.Workbooks.Add
'Add data to cells of the first worksheet in the new workbook.
oSheet = oBook.Worksheets(1)
oSheet.Range("A1").Value = "Last Name"
oSheet.Range("B1").Value = "First Name"
oSheet.Range("A1:B1").Font.Bold = True
oSheet.Range("A2").Value = "Doe"
oSheet.Range("B2").Value = "John"
'Save the Workbook and quit Excel.
oBook.SaveAs("C:\J\Test3.xls")
oSheet = Nothing
oBook = Nothing
oExcel.Quit()
oExcel = Nothing
GC.Collect()
Thank you for any help you can provide!
(it wouldn't surprise me if the above is completely wrong..)
I'm fairly new to VB, but I have some C, C++ background.
I'm trying to open an existing Excel Document, and add data in specific ranges from Text box inputs in my VB program. However I cannot seem to be able to do this.
The closest I've gotten was to Open the document, and save data, but it erases the items that were already in that document.
Can anyone help me out with this?
Here's what I have so far, haven't incorporated getting the data from the Text boxes yet - as I wanted to ensure the saved document would have the added information, along with the pre-existing data.
Dim oExcel As Excel.Application = New Excel.Application
oExcel.Workbooks.Open("C:\J\Test.xls")
Dim oBook As Object
Dim oSheet As Object
oBook = oExcel.Workbooks.Add
'Add data to cells of the first worksheet in the new workbook.
oSheet = oBook.Worksheets(1)
oSheet.Range("A1").Value = "Last Name"
oSheet.Range("B1").Value = "First Name"
oSheet.Range("A1:B1").Font.Bold = True
oSheet.Range("A2").Value = "Doe"
oSheet.Range("B2").Value = "John"
'Save the Workbook and quit Excel.
oBook.SaveAs("C:\J\Test3.xls")
oSheet = Nothing
oBook = Nothing
oExcel.Quit()
oExcel = Nothing
GC.Collect()
Thank you for any help you can provide!
(it wouldn't surprise me if the above is completely wrong..)
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb VB.NET Marketplace
•
•
•
•
.net access apple asp cocoa custom data dell development drive drivers dropdownlist firefox framework games graphics hard hardware hitachi intel internet linux microsoft mozilla net news next open open source open-source opengl programming red hat skin software source step storage sun super system terabyte theme ubuntu vista web wesnoth wikipedia windows xp
- Excel vba 6.0 copy date cells date format (Visual Basic 4 / 5 / 6)
- Open Excel Sheet in Vb.net (VB.NET)
- ootball league table - add data (C)
- ComboBox bind data problem (VB.NET)
- cannot able to open articles or doc files with ie6 (Web Browsers)
- How to Open a word doc from a java application? (Java)
Other Threads in the VB.NET Forum
- Previous Thread: Phone Words Project
- Next Thread: Beginner, Plis assist!


Linear Mode