Hi all
Using xl 2003
Trying to refer to workbook with variable after
assiging full name as string :
Code
Option Explicit
Sub Reconcile_detail()
Dim wb1 As String
Application.ScreenUpdating = False
wb1 = "C:\Documents and Settings\mystuff\My Documents\Chicago" & _
"\Revenue\REV_Tools\Jan_05\Progress_Inv_Dtl_Scrub_Mstr.xls"
Workbooks.Activate wb1
Worksheets("Order_Nmbrs2").Activate
Range("G2").Activate
Call DoTheImport
'Need to determine the columns to delete
'objExcelSheet.range("A:H,L:Q").Delete
'Columns("D").Delete
Application.ScreenUpdating = True
End Sub
Display More
Problem is this line, can't figure out why
I've tried writing it 10 different ways, no help.
Can anyone give me a point in the right direction?
Thanks
-marc