There seems to be plenty of information on how to display Excel data as a webpage, but what I need to do is somewhat the opposite.
I need to display a webpage within an Excel workbook; however, this workbook is then going to be published as html. The nested webpage should be able to update dynamically.
Is this possible or am I trying to hitch a southbound mule to a northbound mule?
Microsoft ExcelMicrosoft OfficeVisual Basic Classic
Last Comment
SnAkEhIpS
8/22/2022 - Mon
Phillip Burton
Have you tried Data - Get External Data group - From Web?
SnAkEhIpS
ASKER
Being new to this I did some research after your suggestion. I need to test this in my prod environment before I close, just in case you might be able to steer me a little. So far, it looks good in test dev env. I appreciate it.
That works. Thank you. Now I just need to see if I can modify how the data is rendered in the worksheet. For example, I would like to make some of the data appear with different fonts or colors applied, perhaps even some of the imported data to go to specific cells, etc..