Search results for query: *

Hi, I am new to power query and was looking for some help with splitting a group by table into two different group by tables if there are more than 8 records in the first resulting table. Current order of operations: 1) Take the raw data and group it 2) Any returned record that's table has...

I have two working macros that I'd like to combine into one. The reason for this is because while they both print out the Word document, they do it differently. Macro One pulls the Mail Merge data into the Word document correctly but will only print to the selected / default printer. Macro...

Hi, I have a pivot table with two value columns. The data changes each day. One of the columns tells the user the total number (count of Required Quantity) of hardware packs that are required. The second column sums the total parts within the hardware packs (Sum of Comp_Qty). I am trying to...

This article covers how to correct the "Project unviewable" error message in Microsoft Word when editing the VBA code in a macro enabled file from a SharePoint Site or OneDrive Word document (.docm). Here are the quick steps to correct the issue. The reason that you are seeing this message is...

Hi, I'd like to create a macro to open a Word document from Excel. I am receiving Run-time error '429': ActiveX component can't create object when I execute the code. I don't have admin privileges to perform the regedit that is called out in this article. This also has to work on several...

Hi All, I need to search a folder and sub folders for a file name containing some value. In the past it looked like Application.FileSearch was a valid way to get the list. Now, Application.FileSearch looks to have been obsoleted in the early 'ots. Is there an updated method? I've looked at...

Hi, I have a macro timer that runs every set period. This macro works just fine, but at some point, a user might need to stop the macro timer from running its next cycle. The period can be as short as every 5 seconds or as long as 24 hours. I've tried several of the error(18) capture...

Hi All; I am trying to return values from an array based on a search term. The array is being captured correctly but I can't search the array return correctly. When I hardcode the array, the search does work. I get a type mismatch 13 when I run the code. Worksheet = "data" dynamic table =...

Hi All; I am running into a situation where I get a runtime 53 error that I am not able to handle correctly. The error occurs on the second occurrence of an error in the DO UNTIL loop when processing the ted.txt to TED FIVE.txt file name conversion. I expect the error to occur, but it should...

Hi All; I'm not sure if this will help you, but I think I created some code to use as a template for calculating different things related to dates. Hope this helps someone. I'll be honest, I haven't verified this code other than simulated so it might not 100% work :) Sub Holidays() Dim...

I have a simple line of code that I'd like to run while a worksheet is password protected. Is it possible to run this without removing the password protections? There will not be a password since that level of restriction isn't required. ThisWorkbook.Sheets("Pick...

Hi Guys, I'm not sure how to do this the simplest way and was hoping for some ideas. I have a excel document that contains multiple macros. One of them adds a banner across the menu worksheet saying that the file is obsolete. To reactivate the sheet, an admin needs to enter a password. This...

Hi All; I am trying to run 2 different codes in PowerShell from VBA. Both lines of code when entered into PowerShell directly work, but from Excel VBA, they don't execute. I've tried both independent of each other just to see if PowerShell was doing anything, but neither code worked and...

Hi All; Is there a way to pass a var from one excel doc macro to another and then change the var and return the new var into the original macro? Here is what I have so far. The calling_macro correctly opens the SANDBOX - Macro from Macro - Source.xlsm file, passes bob="hi" to the msg_box...

Hi I was reading about Using Err.Raise and I had a question or few that I was holing someone could answer. Here is the article I am referencing: Link If I were to add Err.Raise to the code, when an error occurs in the section of code, it should go to Pub Cost ERROR_INVALID_DATA. If there is...

Hello, I am trying to perform a TEXTSPLIT in a dynamic table. I know that this isn't supported, but I am looking for a workaround. I need the data to be divided by the delimiter. Example: Input: bob.frank.ken.paul Column A: bob Column B: frank Column C: ken Column D: paul The string can...

Hi Folks, I had a situation over the weekend that caused major headaches for a bunch of people today. The root cause was that multiple people were in a macro enabled excel doc located on SharePoint. Since they were all trying to use the macro at once, it caused a secondary file to break. Is...

Hello, I have a somewhat complex lookup to perform in a set of BOMs that will provide a single result. I've tried several different operations, but I run into a question about validating a return against a list of PN. I've attached a sample of the problem to this post for reference. The goal...

Hi All; I'm sure that this isn't uncommon, but I can't locate an applicable solution to my issue. I have 2 tables [table1] and [table2]. [Table1] contains a list of models and their descriptions only. [table2] contains cost calculations that needs to expand based on changes to [Table1]. For...

Hello, I am trying to run a vba code after a query has been refreshed. My query code does work, but I'd like to tell the user that the query update is successful or failed. My query update works: ActiveWorkbook.Connections("Query - part_structure_ref_doc_table").Refresh I know the best...