Hi guys!
I have 10 sheets in an Excel workbook.
The data on these sheets are imported from ODBC through 10 different Microsoft queries.
Now the 10 queries share a same parameter, the time period, such as <#2016/3/31#.
Every time I want to run these queries, I need to open each one and modify the period parameter.
Is there a way to input the time period parameter in an cell or record a macro so that I can simply click a button to have all the queries use this parameter?
thanks for your help ：）
Did you try recording a macro to see if that got you started?
There is absolutely a way to have them all modified to the same parameter.
http://www.mrexcel.com/forum/excel-q...lications.html
https://social.msdn.microsoft.com/Fo...forum=exceldev
http://stackoverflow.com/questions/3...nt-be-displaye
Google is your friend.
Last edited by mikeTRON; 05-13-2016 at 01:09 PM.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thanks so much.
You are right.
I should've google it in the begining.
There are many different ways to achieve this outcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks