Search results for query: *

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

Hi Strongm - here is the link to the root cause of the security issue. There is a SQL operation that activates the Word Macro. They recommend that you regedit, but the following method works without having to go and possibly damage the registry. Once I understood the root cause of the error, I...

Hi Paul, I did activate it prior to posting the original issue. What I learned was that Office has security restrictions that prevent Excel from directly running code in Word. The solution around that is to execute a separate macro in Word that is executed from a macro in Excel. This code...

Update - There was different code out there that works.

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

ok - got it working. What a pain in the butt! Sub live_working_code() str_to_pass = "dir FOLDER PATHWAY /b /a-d > ""TARGET FOLDER PATHWAY\vba print long.txt""" Call Shell("cmd.exe /s /k " & str_to_pass, vbNormalFocus) End Sub the "cmd.exe /s /k" instructs command prompt to receive the...

I've tried to run the cmd code in VBA, but it isn't able to run the command. It will open command prompt, but it won't execute the code. I've tried VBA.SHELL and SHELL. There aren't any other articles that I can find that would indicate that this is supported. Here is an example of one of...

I did find this for cmd prompt which seems to be near instantaneously. This is good for a single folder at a time. I'd need to convert this for every sub folder though. Thoughts? dir FOLDER DIRECTOR PATH /b /a-d > "C:\print.txt"

Hi Andy, The sandbox has 26k files = 4 minutes Production can have 250k+ files = ??? minutes / hrs. / years? Is there a "quick" way to get a database index inside Excel so I can get away from a live folder search? When I use cmd prompt as a comparison to just try and index production, it...

Hi Andy, We have 13 different folders with prints in them. The same part number drawing can be in multiple folder just the file name is different. The file name consists of the part number, rev letter, and status of the print. My macro is designed to search for all the first level folders...