Skip to main content
L
LincolnBinns
Participating Frequently
January 30, 2018
Answered

Import Macro Enabled Excel Spreadsheet into Dreamweaver

  • January 30, 2018
  • 1 reply
  • 1951 views

Hi there,

We have a very clever excel spreadsheet at work which allows quoting our customers custom work.

Thinking about moving forward and potentially creating an intranet within the company, having this excel spreadsheet as an HTML seems like a logical step forward.

Has anybody done this that could walk me through the steps?

Best regards,

Ian

This topic has been closed for replies.
Correct answer BenPleysier

The spreadsheet can easily be translated into HTML, but because HTML is a static language, you would need a scripting language to translate the macros. The latter can be done using JavaScript. Simply Google the subject or have a look at VBA to JavaScript Translator – Bacon Bits

1 reply

BenPleysier
Community Expert
BenPleysierCommunity ExpertCorrect answer
Community Expert
January 30, 2018

The spreadsheet can easily be translated into HTML, but because HTML is a static language, you would need a scripting language to translate the macros. The latter can be done using JavaScript. Simply Google the subject or have a look at VBA to JavaScript Translator – Bacon Bits

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!
L
LincolnBinnsAuthor
Participating Frequently
January 30, 2018

Hi Ben,

Thanks for replying.

Ok, I have to admit that this is all new to me.

I can see the developer tab in excel and open the VB side of things but it opens many many windows in Visual Basic. I've never used it personally. Do you know of a step by step guide to follow by any chance? Like, is it a case of exporting all sheets individually and translating them into Java them uploading them somewhere?

Any help offered is greatly appreciated.

BenPleysier
Community Expert
BenPleysierCommunity Expert
Community Expert
January 30, 2018

Have a look at How to convert Excel tables to HTML

On second thoughts, have a look at embedding the spreadsheet Excel Online – create web-based spreadsheets, share & publish on a web-site. Instead of uploading to OneDrive, you could leave the spreadsheet where it is. This is probably an easier option to the one I suggested previously.

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices