Last seen: Dec 22, 2025
To create a unique Index number by customer, you have to create a query from the source table, then: -Add a custom column named Name&Phone, wit...
It's not hard 🙂 First, load those 2 tables with movies and responses. You have 2 choices: to create a new query, and merge the previous 2 queri...
Hi Oleg, To disable refresh only for specific queries, go to Data>Connections, locate the connection that you want to disable, click on Properti...
Sent by mail, forum upload is still not functional at this moment. But it has exactly the same codes as the ones posted, should work. Cheers, ...
Glad to hear you managed to make it work, with Sunny's help of course.
Hi Julian, Because the code structure is recursive, you have to add another argument to indicate which is the starting row, each time a new folder ...
Received the file, tested and it works on my computer. What you should try, is to list all properties for a single file, maybe the author is in a d...
Send it to email then, there are some technical problems on forum, we are working on it.
The first formula can also work , even if you have a date in the source table. If you don't convert that column to date type in Power Query, it will b...
No worries, let's continue on the other topic 🙂
There is no attachment, please press the Start Upload button after you Add Files to the Upload Queue. Those 2 buttons are side by side, should be easy...
Great, glad to hear you managed to make it work 🙂 Cheers, Catalin
You also opened a new topic with the same text, please don't open multiple threads with the same subject. One is enough, don't worry, we'll help you :...
The Author is not in the list of Attributes, you have to use a different method for that: Sub ListMyFiles2(mySourcePath, IncludeSubfolders) Dim ...
Date operations can be tricky, so I think it's not enough to just say that you have 5/12/16 in a cell, this can mean that you have a text in that cell...