Hi Mynda, I repeated the same experiment to confirm that Power Query would add an unexpected apostrophe on an added column. Please open the attache...
Hi Mynda, It's the case for Excel formulas, but Power Query always add it automatically on a text type added column so far as I know. Nevertheless...
Hi Mynda, I've been doing the way you suggested. What I could not figure out is that why Power Query "must" adds a single quote for an added column...
Hi Sunny, Frankly speaking I've posted that thread on MSOFFICE FORUMS earlier in last month end. Eventhough I knew very well if I've raised this ca...
Hi Sunny, Thanks again for your great support. Furthermore, to my surprise you were that serious to make your commitment and completed it so quickl...
Hi Sunny, Regarding the script as listed below you provided for me last time, could you please do me one more favor by adding a loop to restart the...
Hi David, As I have no intention to break your VBA password, you may forget my request anymore. Happy lunar new year. Julian
Thanks for your sharing in advance, David. By the way, Sunny has also helped me working out a VBA script to play a Window Media Player's playlist in E...
Can it be opened to me?
Hi Sunny, The first few rows of module 11 are garbled as quoted below, could you please show me the right script for my reading. Thanks. Sub ?...
Indeed, the script of your folder picker dialog is much concise than the Function BrowseForFolder( ) I obtained from others. Besides, I don't know why...
Hi Catalin, I got the following function which can open a browse window. If I want to implement it on your VBA, how your script can be modified? Wo...
Got it. Thanks for your further explanation.