0

I have such situation. I have to call function in browser console after user clicked a hyperlink in Excel. One of function's argument is based on row's data, so it's kinda dynamically generated.

Is this possible within Excel environment?

If anything is unclear, let me know.

Thanks guys.

EDIT: I have thought already about using batch file, to convert hole excel file to html or use Python script, but non of this is simple. Problem is that I'm not a VBA guy, so I'm asking SO community to suggest if that kind of thing is even possible in Excel(VBA).

braX
  • 11,506
  • 5
  • 20
  • 33
DIV
  • 101
  • 3
  • Kindly show us your effort prior to asking the question here. – Harshith Rai Nov 29 '18 at 11:30
  • I have thought already about using batch file, to convert hole excel file to html or use Python script, but non of this is simple. Problem is that I'm not a VBA guy, so I'm asking SO community to suggest if that kind of thing is even possible in Excel(VBA). – DIV Nov 29 '18 at 11:36
  • Add it to the question. – Harshith Rai Nov 29 '18 at 11:38
  • 1
    Use the `HYPERLINK` function to generate links, and include the relevant row's data in the generated URL as a bunch of GET parameters. Read them from javascript on the web side. – GSerg Nov 29 '18 at 12:31
  • Thanks. It's true. I forgot about parameters in url, very useful. Anyways, I still have to execute js code (to get parameters and finally run a function) after webpage is loaded. You know anything that could help me achive that? – DIV Nov 29 '18 at 13:52
  • https://stackoverflow.com/q/7770887/11683 – GSerg Nov 29 '18 at 20:32

0 Answers0