Recent content by remeng

Thanks Combo. It didn't work the way I expected, but it got me on the correct path.

Andy, I ran into this when I was working on an Excel to Mail Merge project... ok still working on it lol. Somewhere in my research I found that even with a blank Word doc, it needs to save the first instance. Why? No clue. I think if you turn AutoRecover off, it might resolve the issue. I...

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...

Hi Andy, You might want to look into a Power Query solution for this instead of VBA. Over the last few months I've noticed that a lot of what we code can be done a lot faster with Power Query. Also, with that system you can connect to the source data directly. Another benefit is that you can...

So I finally figured out a solution to this. You need to use Power Query with the merge operation,

Let me know if this helps. 1) The data is coming out of Oracle in 2 different Reports Schedule Query (Contains the production Schedule) Full BOM Query (Contains the Part Number and Components under the PN as an Exploded BOM - Components inside the PN) 2) Data is queried using Power Query...

Hi MJ, 1) The SN is just used like an index key to cross reference the kits and make sure the count / sum values are correct between the number of kits and the number of parts inside the kits. 2) The kits are made of the following Part Number 12016-1023-00 (SHIP HDW GLIDES 6) 19962-0002-00...

Strongm, Thank you! That did it once I made some minor tweaks to the variable names. When I tried to create my code, I was avoiding the regedit. I guess you just can't do it without the RegObj. Later on, I'll dig into the code further to learn how it actually works. Thanks again! Mike

Hi Mintjulep, I created the tables as you suggested, but I think my Power Query merge LeftOuter Join isn't correct. The numbers just don't match the data correctly. Here is my raw data. What am I doing wrong? Thanks for the help!

Hi Andy, I have info coming into the Sub label_query_to_print(data_query_to_print, excelPath, printer_id_value, ip_address_value) macro. That includes the IP address of the printer (ip_address_value). I need the Macro 1 to include the Macro 2 code that takes the IP address and sends the mail...

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, Thanks for the quick replies. So the data is coming from two different data sources. Both are combined using Power Query. I've tried using combine Pivots prior without any luck, hence utilizing Power Query. Also, the data source info is dynamic, so I am pulling the raw data from other...

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 strongm, I didn't even know that it was a SQL issue until well after I got the 429 error and researched the hell out of it. Trust me, I'd have brought the SQL issue up once I learned about it. Once I did find out about the SQL issue, I was able to google fu it and get a path forward. Now...