Ms Access works wonder

I was stucked hours at xlUpdateLinksNever, trying to resolve the problem of Excel creating a dialog that prompts whether or not to update the links to other excel workbook (see the issue as in the pic).  So, I sought for this IT expert’s advice.  And only realized that, I can actually go without having this coding at all.  

 

I learnt an important lesson today.  Always try to generate output by using Ms Access Query and link function before any attempts to use Excel VBA Macro programming.

Excel Macro is not easy to troubleshoot and can only cater add-hoc functions. 

 

Thanks to the IT expert’s advice that I am nearer to achieving my goal.