Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Access to Excel
I am wondering how to use excel's automated reference to automate updating
data in a excel file using access. Ex: Using the ".Range("G9").Value =" I have personally tried using this code (it did not work) Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click With objExcel .Visible = True .Workbooks.Open("\EDV SUMMARY SAMPLE.xls") *.Range("G9").Value = Val(EDV_DMM_STD_SummaryDataGridView(3,1))* .Range("A1").ColumnWidth = 20 .Range("A1").Font.Bold = True .Range("A2").Value = "So. Main St." .Range("A3").Value = "Hartford" & ", " & "CT" End With **this is a control table conected to a linked databse. I am trying to point to a cell in the table by using indexes and write the data to the excel doc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing from access to excel | Excel Discussion (Misc queries) | |||
Importing to Excel from Access | New Users to Excel | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
Importing to access from excel | Excel Discussion (Misc queries) | |||
Importing Access mdb to Excel | Excel Programming |