Last seen: Jul 3, 2025
You cannot connect to named ranges from external books. All you can do is to convert the named range into a table with same name, Then query the folde...
Yes, filter to get to the row you need, then extract the value from the column you want. Post your function here if you get stuck.
Hi Tim, If there is a query loaded to sheet, not just to data model, when you copy this sheet into a new file all queries and necessary parameters/...
Appending those 3 Collect Data queries will run each query, combining them is not an excel query if those queries are getting data from Oracle. If ...
Build a custom function to get the type. If the name of the new function is GetType, replace: {current, type text} with: {current, type GetType(...
You have already a topic here: The following expression works with both tables and named ranges: Source= Excel.CurrentWorkbook(){[Name="NamedRang...
Added this code in a module: (adapted from Option Explicit #If VBA7 Then Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA"...
Hi Charlie, Remote multiuser excel application can be done, but it's a complex task, needs a user database with permissions, leave settings, imple...
You have removed the line Wait 2 Here is the missing code, put back the line you removed: Private Sub Wait(ByVal nSec As Long) nSec = nS...
Try this code: (adapted from) #If VBA7 Then Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hwnd...
Just start a new blank query with this formula: = Table.SelectRows(Test, each _[Custom]="Failed") (replace "Failed" with "Manual" for the other...
Great, glad to hear you're happy. Please mark the topic on other forums where you posted this question as solved, to stop them from spending time o...
This was very good information. Thank you Have you seen the file attached to my previous message? It has the solution as well,. not just "good in...
In the attached file, change the path to your sample file in the "Test" query. Basically, the idea is to add a new column to identify the target he...