-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel to Forum Software
- Thread starter SOLTEC
- Start date
DocAElstein
Banned user
- Joined
- May 24, 2014
- Messages
- 1,336
Coming back to the OP…… and to get back on track with the thread and original request.....
Hi SOLTEC (Gruß Gott)….
. I should be able to help Yous on this one…
. The links people like us give you in our signature is what we tend to copy from others or from various FAQ; Forum Rules; or various info from MrExcel. Where those links actually go can be changed and we do not always notice. That is to say the actual site may change or be updated and we do not always notice.
. 1) . looking at mine, it sounds as though you should first check out this
MrExcel HTML Maker
.. that is some instructions from Jon von der Heyden on downloading the Free Mr Excel Screen Shot Add-In.
But it does not always work first time. You just have to stick with it …. I rewrote those notes for myself based on the experience I had a few months ago in getting it up and running. I would be happy to post them to you if you wish (Do you have WORD?) – I could drop off here a link for you to a Word (2007) File.
……………………………………
.2) I see that currently this link from my signature
https://onedrive.live.com/?cid=8cffd...CE27E813%21189
gives me 3 things to download. You need to choose this one: HtmlMaker20101230
….. Hopefully after some effort after downloading HtmlMaker20101230 and using the above instructions you should get to be able to produce something like this in MrExcel Forum Threads. (Having mastered it , it is now, finally, my favorite Tool.)
(Note I am using (German PC) XL2007 and XL2010. But I have heard that it should all work in XL2013 Also. (I have no experience with mac.. but the Thread here has diverged a bit into that so there is some info there should that also be of interest to you)
<b></b><table width="10" cellpadding="1px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">General outlook of Code Line (pseudo code Line):</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="color: #C00000;;">arrOut(___) = Object.Value2(_________)</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="color: #974807;;">arrOut(___) = Object.Value2 () (_________)</td></tr></tbody></table><p style="width:5,1em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">LeftSpeedsDeutsch</p><br /><br />
(. The above is a very simple table. You also have super options to include Formulas etc..)
3)… There are other “in – between” options to get you by should the above initially prove tricky.. as it was initially with me. … For example sometimes I use a simple code to get this equivalent:
[Table="class: grid"][tr][td] [/td][td]
[tr][td]
[tr][td]
[tr][td]
[tr][td]
[/table]
. That is very easy.. You simply copy the code into a module, highlight the bit of your spreadsheet you want to show; run the code ; paste into any Forum Editor. You do not have to worry about installing anything. Just copy the code into any module in any Excel File. (If you know nothing about VBA, do not worry, - I can give you a simple set of about 3-4 steps to get this up and running without knowing anything about VBA)
. If you wish I can provide that code here for you. (and if necessary give you those simple steps to get it up and running!)
. 4) As discussed in this Thread Shg and some of his colleagues have alternatives.
. I am only recently trying those, but may be able to help you with installing them if you wish to consider those.. (My Notes which I mentioned above are a sort of general “average” installation instructions for the various tools available..)
. Alan
P.s. 1
….. Any problems there I can certainly help. I live and think in German since 20 years but I am a native Englander!
P.s.2
P.s.3
. To refresh my memory, in case you ask me for help, I followed my notes and installed the Add-In from post #3. As always it was not straight forward and did not work first time around. But after a bit of experimenting I got it up and running to produce another alternative to paste in a Forum Thread…..
… I think it will work here.. pray for me….::::……
[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
[tr][td]
[tr][td]
[tr][td]
[tr][td]
[/table]
Hi SOLTEC (Gruß Gott)….
. I should be able to help Yous on this one…
. The links people like us give you in our signature is what we tend to copy from others or from various FAQ; Forum Rules; or various info from MrExcel. Where those links actually go can be changed and we do not always notice. That is to say the actual site may change or be updated and we do not always notice.
. 1) . looking at mine, it sounds as though you should first check out this
MrExcel HTML Maker
.. that is some instructions from Jon von der Heyden on downloading the Free Mr Excel Screen Shot Add-In.
But it does not always work first time. You just have to stick with it …. I rewrote those notes for myself based on the experience I had a few months ago in getting it up and running. I would be happy to post them to you if you wish (Do you have WORD?) – I could drop off here a link for you to a Word (2007) File.
……………………………………
.2) I see that currently this link from my signature
https://onedrive.live.com/?cid=8cffd...CE27E813%21189
gives me 3 things to download. You need to choose this one: HtmlMaker20101230
….. Hopefully after some effort after downloading HtmlMaker20101230 and using the above instructions you should get to be able to produce something like this in MrExcel Forum Threads. (Having mastered it , it is now, finally, my favorite Tool.)
(Note I am using (German PC) XL2007 and XL2010. But I have heard that it should all work in XL2013 Also. (I have no experience with mac.. but the Thread here has diverged a bit into that so there is some info there should that also be of interest to you)
<b></b><table width="10" cellpadding="1px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">General outlook of Code Line (pseudo code Line):</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="color: #C00000;;">arrOut(___) = Object.Value2(_________)</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="color: #974807;;">arrOut(___) = Object.Value2 () (_________)</td></tr></tbody></table><p style="width:5,1em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">LeftSpeedsDeutsch</p><br /><br />
(. The above is a very simple table. You also have super options to include Formulas etc..)
3)… There are other “in – between” options to get you by should the above initially prove tricky.. as it was initially with me. … For example sometimes I use a simple code to get this equivalent:
[Table="class: grid"][tr][td] [/td][td]
A
[/td][/tr][tr][td]
1
[/td][td]General outlook of Code Line (pseudo code Line):
[/td][/tr][tr][td]
2
[/td][td] [/td][/tr][tr][td]
3
[/td][td]arrOut(___) = Object.Value2(_________)
[/td][/tr][tr][td]
4
[/td][td]arrOut(___) = Object.Value2 () (_________)
[/td][/tr][/table]
. That is very easy.. You simply copy the code into a module, highlight the bit of your spreadsheet you want to show; run the code ; paste into any Forum Editor. You do not have to worry about installing anything. Just copy the code into any module in any Excel File. (If you know nothing about VBA, do not worry, - I can give you a simple set of about 3-4 steps to get this up and running without knowing anything about VBA)
. If you wish I can provide that code here for you. (and if necessary give you those simple steps to get it up and running!)
. 4) As discussed in this Thread Shg and some of his colleagues have alternatives.
. I am only recently trying those, but may be able to help you with installing them if you wish to consider those.. (My Notes which I mentioned above are a sort of general “average” installation instructions for the various tools available..)
. Alan
P.s. 1
….. Any problems there I can certainly help. I live and think in German since 20 years but I am a native Englander!
P.s.2
… I sympathize. I was a Physicist. After a serious accident and weeks in a coma, they “pulled the plug” saying I was brain dead. I kept breathing. And came back! Learning Excel and some of the help from here is what I hope will bring me back up to speed with the Thinking. I will help you as much as I can.
P.s.3
. To refresh my memory, in case you ask me for help, I followed my notes and installed the Add-In from post #3. As always it was not straight forward and did not work first time around. But after a bit of experimenting I got it up and running to produce another alternative to paste in a Forum Thread…..
… I think it will work here.. pray for me….::::……
[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
A
[/td][td]B
[/td][/tr][tr][td]
1
[/td][td]General outlook of Code Line (pseudo code Line):[/td][td][/td][/tr][tr][td]
2
[/td][td][/td][td][/td][/tr][tr][td]
3
[/td][td]arrOut(___) = Object.Value2(_________)[/td][td][/td][/tr][tr][td]
4
[/td][td]arrOut(___) = Object.Value2 () (_________)[/td][td][/td][/tr][/table]
Upvote
0
Excel Facts
When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
GerryZ
Well-known Member
- Joined
- Jul 4, 2014
- Messages
- 1,224
- Office Version
- 365
- Platform
- Windows
Hello SOLTEC
I made A video for you
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be
Let me know if is better for you now!
GerryZ
Upvote
0
Upvote
0
farmerscott
Well-known Member
- Joined
- Jan 26, 2013
- Messages
- 824
- Office Version
- 365
- Platform
- Windows
Agree, FarmerScott
Upvote
0
Similar threads
- Question
- Question
- Question
