I have several embedded excel spreadsheets in forms in a database and the customer would like it that when the form is called to open that excel opens and displays the latest data. However, i have not been able to figure out how to code the opening event to force the spreadsheet in excel to refresh and pull the latest data. How would I do that?
|
|