publish summary sheet of excel in existing html page

[prabhuduraraj09]

Hi all,

I am not familiar with html, but some how i have created html page for few contents that i need to circulate to my agents.
However, i have a excel file which has productivity data for daily. So summary sheet has summarize report.
eg., Range from A15 to D45.
In html page i have created space name as "Summary of Productivity".
now what i want is when agent open the html page and clicks on the "summay of productivity", i want it to display only the range of A15 to D45 of that in excel file. I dont want Excel file to get open.

Please if some one could help me, how to achieve this by step by step instruction that would be Great help.

Thanks for reading my post. Awaiting for possible help.

[HaHoBe]

Hi, prabhuduraraj09,

as there is no information about what the original html-code may look like I suggest you have a look at Function RangetoHTML(rng As Range) which is part of the website and try to convert and insert the converted range into the "template".

I dont want Excel file to get open.

I doubt you will have success on that.

Ciao,
Holger