I need to create a button on an access form that, when clicked, opens an excel spreadsheet on our server.
Row 2 of the spreadsheet is a row of calendar dates, ex: A2= 5/21/2008 B2= 5/22/2008 C2= 5/23/2008 , etc.
On the access form, there is a text field called txtScheduleDate.
So, ultimately what I would like to do is to open the excel spreadsheet and "find" or "focus" on the column where the row 2 date = the date entered in txtScheduleDate.
Possible?
Office 2000
Thanks!
Start Free Trial