Refreshing a query in excel
Hey people...
i have set up a data import into my excel sheet from another excel sheet,
basically all i want to do is write a peice of code that will refresh the data but amend the criteria. its currently only bringing through data between two dates >=date1, <=date2.
the dates can be decided either from cell referrance or a input box.. which ever one is esiest really.
Any ideas any1.
Stuie,
I think the following thread addresses your question,
mlr0911 MS Query in Excel 01-31-2007, 02:28 PM
in the Excel Worksheet Functions forum
---------
The difference between Theory and Practice is that, in Theory they are the same. In Practice, they aren't.
That did the trick...
Cheers for the heads up Kestrel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks