Advertisement

05.23.2008 at 07:28AM PDT, ID: 23427704
[x]
Attachment Details

Automatically opening an excel spreadsheet, finding a value

Asked by snyperj in Microsoft Access Database

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
[+][-]05.23.2008 at 08:06AM PDT, ID: 21632773

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Sign Up Now!
Solution Provided By: capricorn1
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.23.2008 at 08:30AM PDT, ID: 21633039

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628