Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by remeng

  1. remeng

    Ecel Macros not working with V 2505

    Our team has tried 2506 and 2507. Both versions now have the macro issue corrected. Microsoft released 2506 and 2507 with a matter of days. There might have been a few other issues that cropped up too.
  2. remeng

    Ecel Macros not working with V 2505

    Our IT team is rolling back the install till they found out more about the issue. Our latest known stable version is Version 2503 build 18623.20266
  3. remeng

    Ecel Macros not working with V 2505

    Hi Strong - Unfortunately, the files are company restricted otherwise I would have shared the code. It appears that when macros import data from an external file into dynamic tables, it won't import bring the data in at all. When trying to import data in a non-dynamic table, the data is not...
  4. remeng

    Ecel Macros not working with V 2505

    Is anyone else having issues with Excel macros not working correctly after Excel was updated to version 2505 build 18827.20150? I've gone through the standard checks with regards to securities and Trust Center settings and nothing has been disabled or modified. I can't see any specific error...
  5. remeng

    Power Query Split by Table Group by Rows into a new set of group by tables

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

    Open Word as ReadOnly

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

    Power Query Split by Table Group by Rows into a new set of group by tables

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

    Copy data between SQL and Oracle

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

    Excel Pivot Table - Combine Values into a single row

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

    Excel Pivot Table - Combine Values into a single row

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

    Excel Pivot Table - Combine Values into a single row

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

    Combine two working macros into one for MS Word

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

    Excel Pivot Table - Combine Values into a single row

    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!
  14. remeng

    Combine two working macros into one for MS Word

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

    Combine two working macros into one for MS Word

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

Part and Inventory Search

Back
Top