I have been finding myself working in Excel lately these days. I just wanted to share with you a quick hack that I discovered over the internet. Splitting an Excel Workbook into individual worksheets in a matter of seconds. The vba code is based of Chris Bryson’s Blog! I am made one tweak from the original code to suit my needs.
MyPath = ThisWorkbook.Path
For Each sht In ThisWorkbook.Sheets
Filename:="C:\Users\YOUR COMPUTER PATH" & "\" & sht.Name & ".EXTENSION OF YOUR CHOICE"
For more details check out Chris Bryson’s Blog. The link is provided at the top of this post.
What is WAMP?
My page for the website is in the subdirectory simple
Here are all of my files in the subdirectory.
When I click on index.html it just shows an empty page. Notice that it is pointing to the C: drive an not the local host. We will need to change the directory so it will be pointing to the host server.
In the example below I change the directory so it now points to the server localhost.
And now my program works. Yay!!!!
What is Wamp: https://www.youtube.com/watch?v=iG7cj-TwUGI
To download wamp: http://www.wampserver.com/en/
More in depth tutorial in using Wamp: http://www.howtogeek.com/177129/beginner-geek-how-to-host-your-own-website-on-windows-wamp/