Need a Macro to paste Excel data as HTML
Captain Infinity
how to create a macro.
What I have to do, frequently, is convert data from an Excel table into HTML,
specifically links. I have designed the spreadsheet so that the tag data is
contained in columns that appear before and after the specific link data. This
allows me to change only the data that needs alteration, leaving the tag
identifiers standard. This is all set, no help is needed here. Here's a sample
of the table data for some example image links:
Col1 Col2 Col3 Col4 Col5 Col6
<A HREF=" http://whatever.com/ Example1 .jpg">Image 1 </A>
<A HREF=" http://whatever.com/ Example2 .jpg">Image 2 </A>
<A HREF=" http://whatever.com/ Example3 .jpg">Image 3 </A>
<A HREF=" http://whatever.com/ Example4 .jpg">Image 4 </A>
In the above, only the data in Column 3 would change, everything else remains
static throughout the spreadsheet. If the link type changes I only need to
change the value in the top cell of column 4 and everything in that column
changes.
What I do then is select a range of columns and rows, copy it to the clipboard,
and then switch to FrontPage, where it is then pasted as HTML. During the
paste, Frontpage concatenates all columns, and what I'm left with is a bunch of
links labeled "Image 1", "Image 2" and so on, or whatever descriptor I've set in
Column 4. The conversion/paste is very simple actually, takes only a couple of
clicks, but the clicks add up when doing this over and over.
OK, long story made short: A macro assigned to a button would be nice in
FrontPage to do the following:
* Edit Menu - Select All
* Edit Menu - Paste Special
* "Convert Text" interface - select "Treat as HTML"
* OK
Just those four things.
Of course, like millions before me, I tried recording the Macro in Word and
pasting it into the FrontPage VBA editor, but you know how that turned out.
Any help would be appreciated. Thank you.
**
Captain Infinity