johaneil
02-16-2009, 09:51 AM
Looking for some VBA code that will open an excel file on a sharepoint, copy a range of cells and then past to another workbook. Currently have the following, but can't get it to copy the range of cells....
Dim xlApp As Excel.Application
Dim wb As Workbook
Dim xlFile As String
xlFile = http.... Review.xls"
File: '2009 Forecast Review.xls "
Set xlApp = New Excel.Application
xlApp.Visible = True
Set wb = xlApp.Workbooks.Open(xlFile, , False)
End Sub
Thoughts?
Dim xlApp As Excel.Application
Dim wb As Workbook
Dim xlFile As String
xlFile = http.... Review.xls"
File: '2009 Forecast Review.xls "
Set xlApp = New Excel.Application
xlApp.Visible = True
Set wb = xlApp.Workbooks.Open(xlFile, , False)
End Sub
Thoughts?