Excel to Forum Software

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,686
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
That's not entirely accurate. Excel 2008 is the only version of Mac Excel that doesn't have VBA. All the others do, including 2011.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,686
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Which one are you referring to?
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
5,897
Platform
MacOS
I was referring to Mr.Excel.com HTML Maker, but just tried and get a runtime error!
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,154
I was referring to Mr.Excel.com HTML Maker, but just tried and get a runtime error!
Copied from Mac Excel 2011.
Executed cmd-v.
Activated the left most button of the 'Font' bar.
Activated the Go Advanced button of the forum.
Clicked in the posted table area.
Activated the Table Properties button on the down most bar of the forum.
Set the Table Style to Full Grid.

This is the result, comparable with the Borders-Copy-Paste method using IE.

cityrating
rome7
london6
paris6
istanbul6

<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,686
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
The HTML Maker won't work as it uses Windows API calls to manipulate the clipboard.
 

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
5,897
Platform
MacOS
Thanks Aladin, nearly but no borders! Maybe because I'm using Safari?


21-Dec-1421-Dec-1421-Dec-140
21-Dec-1421-Dec-1418-Dec-14-3
21-Dec-1421-Dec-1427-Dec-146
beg jan 1410 jan 1417-Jan-147
mid jan 1420 jan 1430-Jan-1410
end jan 1430 jan 1415-Jan-14-15
15/01/1415-Jan-1425/01/1410

<tbody>
</tbody>

I don't see "Set the Table Style to Full Grid."?
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,154
Thanks Aladin, nearly but no borders! Maybe because I'm using Safari?


21-Dec-1421-Dec-1421-Dec-140
21-Dec-1421-Dec-1418-Dec-14-3
21-Dec-1421-Dec-1427-Dec-146
beg jan 1410 jan 1417-Jan-147
mid jan 1420 jan 1430-Jan-1410
end jan 1430 jan 1415-Jan-14-15
15/01/1415-Jan-1425/01/1410

<tbody>
</tbody>
I too have used Safari. I think you missed a few steps towards the end of the recipe.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,686
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
The BBCode add-in in post #3 does work on a Mac but it needs a bit of UI work. I'll see what I can do.

Edit: now done. See the first link in my signature.
 
Last edited:

Forum statistics

Threads
1,089,200
Messages
5,406,794
Members
403,106
Latest member
AliO

This Week's Hot Topics

Top