I really need some help on this one.
I have the following:
An Excel file named "C:\Excel1.xls"
An Access database [db1]
An Access Form [Form1]
ActiveX Textbox Controls on [Form1]: [Event Date], [Classification], [Resolution]
While in the Access [db1], I need to open "C:\Excel1.xls" with the press of a command button found on Access [Form1]. Then I need Excel cells A1, A2, and A3 to be set to [Event Date], [Classification], and [Resolution] values.
Please Help!
I have the following:
An Excel file named "C:\Excel1.xls"
An Access database [db1]
An Access Form [Form1]
ActiveX Textbox Controls on [Form1]: [Event Date], [Classification], [Resolution]
While in the Access [db1], I need to open "C:\Excel1.xls" with the press of a command button found on Access [Form1]. Then I need Excel cells A1, A2, and A3 to be set to [Event Date], [Classification], and [Resolution] values.
Please Help!