Last seen: Jul 3, 2025
What office version are you using?
In ThisWorkbook.Module, you have to use the Workbook_Open procedure: Sub Workbook_Open() MyFormName.Show End Sub Double click on your form...
Should look like this: =IF( OR(G2<78, AND(G2>=2016,K2<=2019)), value_if_true, Value_if_false)
In Excel you have better alternatives to read that csv, why don't you use Power Query to update data from that csv into the xlsm file?
Here is the code used in the sample file attached: Option Explicit Sub TransferData() Dim tbl1 As ListObject, tbl2 As ListObject, Card As...
Hi Jose, Hard to see your data structure without sample files, so I'll provide a theoretical solution: Use a dictionary to store the values by ID, ...
To add a dynamic list in ribbon, you have to use the dynamicMenu element in UI xml, text file attached. you'll have to get the list of files and build...
Certificates will expire. When they do, most likely you will have to release a new version of your app signed with a renewed certificate, otherwise us...
Splitting data across multiple sheets is a bad idea, you will then need to aggregate data back in order to create reports. Best is to insert data i...
What's wrong with the solution provided in the previous topic you have posted for the same problem? I cannot see any difference in the requirements.
Hi Gold, I think you should use Set Col1=IE.document.querySelectorAll(".wo-notes-num") instead of HTML.querySelectorAll(".wo-notes-num") If you ...
Hi Alan, That step with the List.Accumulate function will not work without the changes indicated, it will return exactly the same error you mention...
Instead of: = Table.AddColumn(#"Changed Type", "States", each List.Accumulate(States1, "", (state,current) => if List.Contains(Text.Split([A...
As mentioned, that is showing because there was a filter applied in that file. Simply go to that power query step indicated in the previous message...
Who knows... The file you provide has the vba code protected, we cannot see what it does, how can we know what it is supposed to do?