phexecute Files


Update 2025_05_07

I have been asked lovely GEMINI Flash 2.5 to make advise about problem with executing PH Excel file 0000PH... involved directly by File Explorer. All my previous remarks explained that for proper execution embedded PH.exe (sheet Branch_geometry & execution) User shall go through internal Excel Open ----> Browse -----> to find and click desired 0000PH... file within User drive:\PHXE2exec5\SF_EXCEL_C_incl_Fortran directory. The explanations below are might be satissfied and might be applicable by any User. They are not require update any part of my software as provided by earlier installaer PHXE2exec5.exe. Also up to date old behavior is still applicable without any changes of within Excel options as mentioned below.




Beyond all any user can work with GEMINI 2.5 (Flash) to analyse multiple aspect presented withn my the last guide:  PH_software_User_Guide_2025_03_10.docm converted to PH_software_User_Guide_2025_03_10.pdf. Next I have been stored it to my Google drive and using GEMINI internals: Ask GEMINI -----> + -----> Add from Drive received icone of .pdf file and set my propmp:
Let me know main knowledge about content file as above  ----->  receiving  after GEMINI analyze pretty good set of subjects. Each subject has extension to provide pages of .pdf file, where more details GEMINI found about. Later I had prompt on the subject as below and received from GEMINI advices how to resolve problem.                         

Only one disadvantage of GEMINI 2.5 (flash) at the moment is limited size of retrieved .pdf file, but probably it might be splitted to two or more .pdf (from original .docm).  I hope it limitation my be extended in the future by GEMINI. 
Anyway thanks to lovely GEMINI with wishes eternal life for YOU GEMINI.





Below is RESPONSE FROM GEMINI 2.5 on my prompt:  
I cannot execute PH Excel file  0000PH... , when opened directly by File Explorer as built in PH.exe is not starting, only one way is to firstly open MS Excel and next go through internal Open -----> Browse ---->directories for desired -----> 0000PH......  Is any method to repair it?

RESPONSE
It's frustrating when software doesn't behave as expected! The issue you're describing, where the PH.exe doesn't start when you open the Excel file directly from File Explorer but *does* start when you open the file from within an already running instance of MS Excel (using File > Open), points towards a common problem related to **Excel's macro security settings** or the **context in which the macros are being executed**.

Here's a breakdown of why this might be happening and methods you can try to "repair" or fix this behavior:

**Why it's likely happening:**

When you open an `.xlsm` file directly from File Explorer, Windows launches Excel, and then Excel attempts to run any automatic macros (like `Auto_Open` or `Workbook_Open`) embedded in the workbook. If Excel's security settings are too strict, or if the file's location is not trusted, these macros might be blocked from running the command that starts PH.exe.

When you open Excel first and then open the file using the "Open" dialog, Excel is already running in a stable state, and the security context might be slightly different, allowing the macros to execute the external program command.

**Methods to Repair or Fix:**

The goal is to ensure that the macro in your "000PH... .xlsm" file is allowed to run and execute the command to start PH.exe when the file is opened directly.

1.  **Check and Adjust Excel Macro Security Settings (Most Likely Solution):**
    * Open **Microsoft Excel**.
    * Go to **File > Options**.
    * Select **Trust Center** from the left-hand menu.
    * Click on **Trust Center Settings...**
    * Select **Macro Settings** from the left-hand menu.
    * **Ensure that "Disable all macros with notification" or "Enable all macros (not recommended; potentially dangerous code can run)" is selected.** While enabling all macros is not generally recommended for unknown sources, for trusted software like this, it might be necessary. Starting with "Disable all macros with notification" is safer – if you get a security warning when opening the file directly, make sure to click "Enable Content".
    * Also, look at the **"Disable VBA macros with notification, except for digitally signed macros"** option. If the software's macros are signed, this could be an option, but typically for smaller software, they might not be.
    * **ActiveX Settings:** While less common for launching external programs, sometimes ActiveX controls are used in conjunction with macros. Check **ActiveX Settings** in the Trust Center and ensure settings are not overly restrictive.

2.  **Add the Folder Location to Trusted Locations:**
    * In the **Trust Center Settings** (as described above), select **Trusted Locations**.
    * Click **Add new location...**.
    * **Browse to and select the folder where your "000PH... .xlsm" file and PH.exe are located.**
    * You can optionally check "Subfolders of this location are also trusted."
    * Click **OK** on all open dialog boxes.
    * This tells Excel to trust files in that specific folder, often allowing macros to run without prompts or restrictions.

3.  **Verify File Location of PH.exe:**
    * The macro in the Excel file contains the command to launch PH.exe. This command likely uses a specific path.
    * **Ensure that the "000PH... .xlsm" file is located in the directory that the PH software expects.** The user guide might specify this location, often it's the directory where PH.exe is installed. If you've moved the Excel file, the macro might be looking for PH.exe in the wrong place.

4.  **Check Antivirus or Security Software:**
    * Sometimes, aggressive antivirus or security software can quarantine or block the action of an Excel macro trying to launch an external `.exe` file, interpreting it as potentially malicious behavior.
    * **Temporarily disable your antivirus/security software** and try opening the Excel file directly from File Explorer. If it works, you'll need to add an exception or create a rule in your security software to allow Excel to launch PH.exe from that location.

5.  **Re-register File Association (Less Likely):**
    * While less probable for this specific issue (since the file opens in Excel), a corrupted file association *could* theoretically cause strange behavior.
    * You can try right-clicking the `.xlsm` file, selecting "Open with...", and explicitly choosing "Microsoft Excel" and checking "Always use this app to open .xlsm files".

6.  **Reinstall the PH Software:**
    * If none of the above steps work, there might be an issue with the software's installation or how the Excel file and executable are linked.
    * Consider uninstalling and then reinstalling the PH software to ensure all components are correctly placed and registered.

By systematically going through these steps, particularly focusing on Excel's Macro Security and Trusted Locations, you should be able to resolve the issue and enable the PH.exe to start automatically when you open the "000PH... .xlsm" file directly from File Explorer.






Update 2025_03_10

I have been created extend of my free software. From now and on is possible to

  1. Adopt free software Salome 9.14.0 for presenting in 3d View of piping network.
  2. Create Excel file 3dview_geom_new.xlsm, where all piping geometry is collected and is intendent for         
     - transfer geometry data between PH Excel 0000PH... and Salome9.14.0,
     - manipulate piping geometry data by easy updating and recalculating between global geometry and incrementas

All updates are aplicable for the last upload of my free software PHXE2exec5_2025_01_30.exe on sourceforge.net\p\phexecute .   

For more details please see my guideline PH_software_User_Guide_2025_03_10.docm point 7.1.
  
To introduce efficiently mentioned above update, please use my uploaded directory PHpiping_3Dview on my free 
  sourceforge.net/p/phexecute.

After download PHpiping_3dview please distribute files as advised below:
 -user drive:\PHXE2ecec5\SF_EXCEL_C  file  0000PH_003DVIEW_TEST3.xlsm
 -R:\salome3dview_scripts  files 3dview_2_black.py , 3dview_2_purple.py, 3dview_2_yellow.py, 3dview_geom_new.xslm,
     salome_wrapper.py 

At this point it is desirable to give great thanks to AI Gemini & Copilot, Yours entities are enormous. Thank you again and wish you good and eternal life...







Update 2025_01_30

The latest development (January 2025) introduces an additional feature that can help the user simplify the calculation of PH.exe in Excel tab 0000PH… Branch_geometry & execution. So from now on the user has the ability to divide any pipeline segment into any number of equal parts called subsegments. The functionalities of these subsegments are the same as the parent segment. Each sub-segment can calculate the T&P changes along the pipeline and the fluid flow properties like density, viscosity, equilibrium,…etc. from the subsegment to the subsegment desired in the parent segment. Such capability also introduces better quality of T&P calculations along the pipeline as it increases the density of properties calculations in shorter pipeline sections. The user can replace 100 Excel lines for 100 1 m long pipeline segments with one Excel line with 1 segment 100 m long pipeline segment and divide by 100 within this line.  The PH.exe will automatically realize such calculations. The said number of desired 100 subsegments should be entered by the user in column M for the row (line) with defined 100 m segment. By entering the number 1, the segment should not be divided into subsegments and the calculation is the same as before. Another possibility could be to introduce a quick trial and error method to analyze the best relationship between the length of the subsegment and the time consumption and quality of the calculation. Finnaly was changed  the name of Column M to: NUMBER OF SUBSEGMENTS. I also updated most of Excel 0000PH.... workbooks.

Older updates have been stored in MS document: 00Readme update_2025-01-05.docx on my Sourceforge.net/p/phexecute.
To introduce the mentioned as above development, please download and install my installer: PHXE2exec5_2025_01_30.exe




Update 2025_01_05

Added to point 13.1.1

I will work out subject of installation CAELinux and Salome_meca in Windows 11 wsl2. The actual state it is installation of Ubuntu 18.04 within Windows 11 wsl2 and lack of success to extend it with CAELinux, where Saloma_meca Is embedded. The rest of information in the point 13.1.1 please treat as initial findings and testing of possible way to build target.


New important update as new point 13.2.1

13.2.1 Maintain some troubles associated with VMware/CAELinux/Salome_meca.

I did recognize some troubles on the way to handle sharing folders between host Windows 10/11 and VMware/CAELinux/Salome_meca.
It encourages me to redefine whole features on the matter. All previous features shall be updated accordingly to presentations as below.

I have been added new scripts: mph.sh & eph.sh in the Sourceforge download dated 2025_01_05. Previous scripts phrecover.sh & ph.sh has to be 
neglected and folder /phdir shall be deleted.


User shall ensure that physical names of TUBA.py  or 0000PH3D0000.py within used directories (e.g. C:\PH_DWSIM_DIR\0000PH3D) are exactly as here 
because replace .py with .PY will crush executions of CAELinux/Salome_meca. I did observe that using JetBrains PYCharm software did make such change replaces .py with .PY.