Word macro for clean HTML code - Page 8

Toxaris · 05-06-2013, 01:33 PM

I have uploaded a new version. There is something strange with the lists. If I create a document with the lists manually or in the test document remove the list and then reapply the list, the function works fine. It seems that there is something not quite right, but I cannot make the distinction in Word as it is now. The only advice I can give is to check your lists afterwards. Perhaps I will find a fix later.

EinfachNurIch · 05-11-2013, 12:08 PM

There is a typo in the macro. In the function LoadArrays "&dbquo;" instead "&bdquo;".

Toxaris · 05-11-2013, 01:32 PM

Right you are.

steppe · 05-13-2013, 05:20 AM

Quote:

Originally Posted by Toxaris

I have uploaded a new version. There is something strange with the lists.

Thanks for fulfulling the requests. Regarding lists, maybe this has to do with different versions of Word. Anyways, changing <ol> to <ul> by hand is not that difficult if you know in advance that the problem may occur.

steppe · 05-13-2013, 05:37 AM

This is not really a problem, but the new version of the Macro creates a folder Save_As_HTML.files (attached). This folder is not mentioned in the HTML file.

Toxaris · 05-13-2013, 05:52 PM

Correct, it is part of the conversion process to determine which images are there. They should be deleted afterwards, but that does not always work. Do not blame me, blame MS. Handling images is handled poorly in VBA... So much better in VB.Net or C#.
I do not recommend using those images anyway, but insert them in Sigil manually. The quality is usually less than what you get from OCR. Therefore I do enter the links to the images in Sigil style and no real link to the actual image.

steppe · 05-23-2013, 06:56 AM

Quote:

Originally Posted by Toxaris

Do not blame me, blame MS. Handling images is handled poorly in VBA... So much better in VB.Net or C#.

I am not blaming you

Thanks for the explanation.

cathytas · 05-27-2013, 02:03 AM

I'm a Mac user and new to this. Do I just drag the macro onto my desktop? Where does it work from? Very nervous about altering Word and then not able to delete it.

Toxaris · 05-27-2013, 02:48 AM

You need to add it to Word via the Visual Editor. On Windows this works via Alt-F11, no idea how this works on a Mac.

steppe · 06-12-2013, 04:02 AM

Quote:

Originally Posted by cathytas

I'm a Mac user and new to this. Do I just drag the macro onto my desktop? Where does it work from? Very nervous about altering Word and then not able to delete it.

Unpack the .zip file that you downloaded from the first post in this thread. Launch Microsoft Word, hold down the "Option" key and press the "F11" key. The Visual Basic window will appear. In the left-hand panel, click the "Normal" project, then click the menu "File" of the Visual Basic window and select "Import file." Navigate to Toxaris's .bas file, select it, and press "OK." Close the Visual Basic window. Open your document in Word, select the "View" ribbon, and click the "Macros" button. In the dialog window, select "Transform_HTML" and press "Run." Click either "No" or "Cancel" when presented with various questions, except for the last question "Save HTML?" where you have to select "Yes."

If your version of Word doesn't have the "ribbon interface" (Word 2008 for Mac or older), then you can download a free 30-day trial of the latest Microsoft Office. The macro works fine in the latest Word for PC.

varlog · 06-12-2013, 06:52 PM

As I left Windows behind me for several years now I've tried your macro with LO on Linux. No go of course. Some comments? A pointer?

Toxaris · 06-13-2013, 05:04 AM

Quote:

Originally Posted by varlog

As I left Windows behind me for several years now I've tried your macro with LO on Linux. No go of course. Some comments? A pointer?

Sure... It only works on MS Word. It can never work on LO/OO, since that is a totally different program...

varlog · 06-13-2013, 05:07 PM

Being simple as I am I just thought it is Basic program operating on a text document - so the "only" problems are compability of program and document. From your answer I take it nobody played (me excluded

) with your macro in LO yet.
I added:
Option VBASupport 1
Option Compatible
I get:
BASIC syntax error.
Variable CharFonts already defined.

which is Basic incompatibility probably.
If time allows, your permission presumed, I'll play some more...

Notjohn · 06-17-2013, 06:45 AM

Quote:

Originally Posted by mmat1

This is not an in-depht analysis, but a quick check shows, that it works well in W2003. So W97 shoudn't cause much problems.

It's great !!!!!!

Is there any hope for Word 2000?

Thanks - NJ

Toxaris · 06-17-2013, 08:36 AM

All I can say is try. I don't have copies of Word 2000 for many years now. It might work. It is not depending on ribbons or alike.

05-13-2013, 05:52 PM	#111
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	Correct, it is part of the conversion process to determine which images are there. They should be deleted afterwards, but that does not always work. Do not blame me, blame MS. Handling images is handled poorly in VBA... So much better in VB.Net or C#. I do not recommend using those images anyway, but insert them in Sigil manually. The quality is usually less than what you get from OCR. Therefore I do enter the links to the images in Sigil style and no real link to the actual image. Last edited by Toxaris; 05-14-2013 at 01:19 AM.

06-13-2013, 05:07 PM	#118
varlog actually it is /var/log Posts: 341 Karma: 2994236 Join Date: Sep 2012 Location: usually Europa Device: prs t1	Being simple as I am I just thought it is Basic program operating on a text document - so the "only" problems are compability of program and document. From your answer I take it nobody played (me excluded) with your macro in LO yet. I added: Option VBASupport 1 Option Compatible I get: BASIC syntax error. Variable CharFonts already defined. which is Basic incompatibility probably. If time allows, your permission presumed, I'll play some more...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Macro: Footnotes to inline text ?	Hadrien	Workshop	17	10-08-2011 02:28 PM
Word 2007 macro	scoplar	Workshop	1	05-21-2011 06:00 AM
Doc to REB Macro for Word	kbirdz	Fictionwise eBookwise	0	10-27-2010 11:30 PM
Word Formatting Macro (Stingo's Macro)	Stingo	Sony Reader	75	08-24-2010 06:18 AM
Docvert 2.0 converts MS Word files to clean HTML	Alexander Turcic	Lounge	0	03-16-2006 05:50 AM

05-06-2013, 01:33 PM	#106
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	I have uploaded a new version. There is something strange with the lists. If I create a document with the lists manually or in the test document remove the list and then reapply the list, the function works fine. It seems that there is something not quite right, but I cannot make the distinction in Word as it is now. The only advice I can give is to check your lists afterwards. Perhaps I will find a fix later.

05-11-2013, 12:08 PM	#107
EinfachNurIch Member Posts: 11 Karma: 14354 Join Date: May 2013 Device: tolino, Kobo Aura HD	There is a typo in the macro. In the function LoadArrays "&dbquo;" instead "&bdquo;".

05-11-2013, 01:32 PM	#108
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	Right you are.

05-27-2013, 02:03 AM	#113
cathytas Junior Member Posts: 1 Karma: 10 Join Date: May 2013 Device: kindle, iPad	I'm a Mac user and new to this. Do I just drag the macro onto my desktop? Where does it work from? Very nervous about altering Word and then not able to delete it.

05-27-2013, 02:48 AM	#114
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	You need to add it to Word via the Visual Editor. On Windows this works via Alt-F11, no idea how this works on a Mac.

06-12-2013, 06:52 PM	#116
varlog actually it is /var/log Posts: 341 Karma: 2994236 Join Date: Sep 2012 Location: usually Europa Device: prs t1	As I left Windows behind me for several years now I've tried your macro with LO on Linux. No go of course. Some comments? A pointer?

06-17-2013, 08:36 AM	#120
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	All I can say is try. I don't have copies of Word 2000 for many years now. It might work. It is not depending on ribbons or alike.