For behavior of Office URI scheme

Nobuyuki Sasaki 1 Reputation point
2021-06-09T08:10:29.137+00:00

On Google Chrome (or Edge),
I would like to open Excel macro with startup parameters specified.
In the case of running it with some Excel workbook opened first,
Excel macro could not get the startup parameters.
(It works so that the startup parameters of Excel workbook opened earlier can be taken)

Even if I have some Excel workbook open first, I would like to take Param1 parameters with the XXXXX.xlsm macro.

Office URI scheme with the following command image
ms-excel:nft|u| http://localhost:8080/excel/XXXXX.xlsm?Param1

In Excel macro
Get startup parameters using 'GetCommandLineW'

Office version : 365 or 2019

Thank you.

{count} votes

1 answer

Sort by: Most helpful
  1. Nobuyuki Sasaki 1 Reputation point
    2021-06-14T04:47:00.453+00:00

    Hi All,
    Thank you for your some support.

    I could not find the best solution, so I switched to solution that does not use URI scheme.
    I am very grateful for the study of development.

    Thanks.

    0 comments No comments