I have written a program in Excel 2007 VBA to generate a new woorkbook and have a Query table in one of the sheets.There are charts related to it in the remaining sheets.I would like to make the query table update itself immediatly with changes in any in access 2007 table.Could somebody give me some solution.
Bookmarks