Darren Bartrup
Well-known Member
- Joined
- Mar 13, 2006
- Messages
- 1,296
- Office Version
- 365
- Platform
- Windows
I've been given the task of getting our reports from Excel onto a webpage - preferably so the end user doesn't have to have Excel to view the data.
I've picked up the idea used in the 'VBA & Macros for Excel' book by Bill Jelen & Tracy Syrstad.
Now, being a complete newbie to creating webpages it took me the best part of a day to get a some simple text and a table (the table was filled using data from the workbook) and a couple of links onto an html file - this is all good, as I just have to press a button on the workbook and the file is created.
But now things are going to get much more complicated: graphs and pictures, links, multiple worksheets, screentips, combo boxes all needed to be added. Basically, I need to recreate the workbook as a webpage and all at a press of a button (oh, and can I get it to wash the car to?)
Is HTML the best thing to do? Output all the code to notepad and save.
Or maybe one of the hundred of other variations on HTML that seem to be floating around out there?
Then, once I've decided on the best way to go about it... any good books on learning this stuff out there?
Is there a MrWebPage.com site out there?
I've picked up the idea used in the 'VBA & Macros for Excel' book by Bill Jelen & Tracy Syrstad.
Now, being a complete newbie to creating webpages it took me the best part of a day to get a some simple text and a table (the table was filled using data from the workbook) and a couple of links onto an html file - this is all good, as I just have to press a button on the workbook and the file is created.
But now things are going to get much more complicated: graphs and pictures, links, multiple worksheets, screentips, combo boxes all needed to be added. Basically, I need to recreate the workbook as a webpage and all at a press of a button (oh, and can I get it to wash the car to?)
Is HTML the best thing to do? Output all the code to notepad and save.
Or maybe one of the hundred of other variations on HTML that seem to be floating around out there?
Then, once I've decided on the best way to go about it... any good books on learning this stuff out there?
Is there a MrWebPage.com site out there?