StephenL
08-10-2006, 02:18 PM
Hello all,
Is it possible to copy an Excel worksheet into an existing Excel file using Access VBA coding?
Dim xlApp As Object
Dim ExlFile As Object
Dim ExlFile2 As Object
Dim FN1 as String
Dim FN2 as String
FN1 = "c:\YTD Reports summary.xls"
FN2 = "c:\ YTD Reports by BU.xls"
Set xlApp = CreateObject("Excel.Application")
Set ExlFile = xlApp.workbooks.Open(FN1).Sheets(1)
Set ExlFile2 = xlApp.workbooks.Open(FN2).Sheets(1)
ExlFile.Copy After:=ExlFile2 ? This is where I am stuck.
Any help would be greatly appreciated.
Steve
Is it possible to copy an Excel worksheet into an existing Excel file using Access VBA coding?
Dim xlApp As Object
Dim ExlFile As Object
Dim ExlFile2 As Object
Dim FN1 as String
Dim FN2 as String
FN1 = "c:\YTD Reports summary.xls"
FN2 = "c:\ YTD Reports by BU.xls"
Set xlApp = CreateObject("Excel.Application")
Set ExlFile = xlApp.workbooks.Open(FN1).Sheets(1)
Set ExlFile2 = xlApp.workbooks.Open(FN2).Sheets(1)
ExlFile.Copy After:=ExlFile2 ? This is where I am stuck.
Any help would be greatly appreciated.
Steve