Thread
:
Importing Access to Excel
View Single Post
#
3
Posted to microsoft.public.excel.programming
Stumped Programmer[_2_]
external usenet poster
Posts: 3
Importing Access to Excel
Thank you,
The cells I am refering to are in a Datagrid (stated "table" in post) in my
project.
With the line: *.Range("G9").Value =
Val(EDV_DMM_STD_SummaryDataGridView(3,1))* I am trying to take the value
(text or integer) of cell (3,1) in the Datagrid and transfers it to cell "G9"
in Excel
"Roger Govier" wrote:
Hi
I think you would need a
.Sheets("Sheet1").Activate or .Select
before referring to the individual cell ranges.
--
Regards
Roger Govier
"Stumped Programmer" <Stumped
wrote in
message ...
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.
Reply With Quote
Stumped Programmer[_2_]
View Public Profile
Find all posts by Stumped Programmer[_2_]