Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am writing a Microsoft Access application that exports data to Excel, and
have just started using late binding. However, I am experiecing some errors now that I have done so. 'Here is where I input the late binding code Dim ExcelApp As Object Set ExcelApp = CreateObject("Excel.Application") 'Here is where I try to copy the cell formulas to encompass all input rows ExcelApp.Range("H2:AD2").Select strFields = "H2:AD" & intRecords ExcelApp.Selection.AutoFill Destination:=ExcelApp.Range(strFields), Type:=xlFillDefault strFields is set to encompass all the rows that have been imported into Excel. However, the application no longer seems to work at the last line of code. ExcelApp.Selection.AutoFill Destination:=ExcelApp.Range(strFields), Type:=xlFillDefault Any ideas? Thanks! Dustin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Late Binding examples of binding excel application | Excel Programming | |||
Late Binding help, Please | Excel Programming | |||
Late Binding | Excel Programming | |||
EARLY binding or LATE binding ? | Excel Programming | |||
DAO Late Binding? | Excel Programming |