Vex Star

I am making a timesheet program and I want to convert a week on a monthly chart to a weekly chart. To do this I have coded in a module something similar to this:
Sub Open_Excel_Wb()
Workbooks.Open Filename:= _
"C:Documents and SettingsGarboMy DocumentsBook1.xls"
Sheets("Sheet2").Select
Range("A1").Select
Range("A1").Value = DateValue(Now())
End Sub
How would I then make Range("A1").Value = a value on a [...]

October 31st, 2008 | Tags: Sub Open_Excel_Wb | Category: general | Leave a comment