Bub_the_Zombie
Board Regular
- Joined
- Nov 1, 2016
- Messages
- 53
Hey everyone have a few advanced questions I need explained in semi-lay person speak.
I have made a excel Workstation (in .xlsm) that handles everything I need to do during the day (thank you to everyone here that helped me with my pile of questions to complete it). On the workstation there are two worksheets that will be saved as two .html files so they can be displayed on two separate monitors.
I am saving the worksheet by
save as > Save as type: Web Page (*.htm:*.html) > Save: Selection: Sheet > Publish > (Choose the required sheet) > AutoRepublish every time this workbook is saved
Questions / problems.
1. When I save the workbook it is not updating the .html file, am I missing a step somewhere?
2. Is it possible to save two .html files from the same workbook? Meaning when I save the original workbook will both the worksheets update save correctly? Or do I need to create individual workbooks for each .html file I wish to create?
3. Is there any other problems I should keep an eye out for?
I have made a excel Workstation (in .xlsm) that handles everything I need to do during the day (thank you to everyone here that helped me with my pile of questions to complete it). On the workstation there are two worksheets that will be saved as two .html files so they can be displayed on two separate monitors.
I am saving the worksheet by
save as > Save as type: Web Page (*.htm:*.html) > Save: Selection: Sheet > Publish > (Choose the required sheet) > AutoRepublish every time this workbook is saved
Questions / problems.
1. When I save the workbook it is not updating the .html file, am I missing a step somewhere?
2. Is it possible to save two .html files from the same workbook? Meaning when I save the original workbook will both the worksheets update save correctly? Or do I need to create individual workbooks for each .html file I wish to create?
3. Is there any other problems I should keep an eye out for?