Hmm, looks like I needed more testing before trying to consolidate the HTML code with the BBCode version!
Hmm, looks like I needed more testing before trying to consolidate the HTML code with the BBCode version!
Remember what the dormouse said
Feed your head
haha. If its any help, Im running 8.1 (doesnt say what build), and Office 13 on I7 with 12 gig ram (not sure if this happens in office 10, but I can testy if needed)
Its not a huge big deal, I just remove all colors before using. The "switch back to last copy area" can be a pain
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@ Ford
Me, too. I've discovered that if I go into the VBA editor and hit reset all is well.I have noticed with what I got from your post 181, that sometimes, it seems to remember the file it was last used in (if I have a few different files open), then when I try and use it again, it jumps back to that file, and wont accept the range from the current file. I end up having to close the file I used it previously in, and then it works fine again.
Anybody here has an idea how will I can copy and paste the Alphanumeric beside the numbers column? When I copy and paste the alphanumeric it cannot be pasted because the area are not the same size and shape. I want the format of the numbers should be the same with the alphanumeric. Your help is greatly appreciated guys. Thank you so much.
help.jpg
josafe88
Welcome to the forum. Pls take some minutes to read forum rules before you post again, because:
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
@Ford,
I've loaded an updated version. Can you download and retest? I think it fixes both issues. (there is no BBCode for cell fill, so it simply ignores that)
Will do Rory. I am at work right now (W7/2007), so I will take a look when I get home - thats where it happens
(now, all I have to do is find te post that has the upload LOL)
You can download my current version from the link at the bottom of the page here: http://excelmatters.com/excel-forums/
Thanks for the pointer, Rory. I found the link, will try it when I get home (I work 3-11)
Romper, I have tried that link again, but it doesnt seem to be working?
I think Rory has had it with this forum.
I can't quite tell what link you are referring to, but the link in Rory's post #209 takes me to his blog just fine. On that page scroll to the end of his text and find the link to the tool.
For convenience's sake, here it is again:
https://www.dropbox.com/s/31r9s6t9j6...ools.xlam?dl=0
cheers, teylyn
teylyn, thanks for that. I could get to his site
http://excelmatters.com/excel-forums/
but the link to the file (marked "here") did not work - but when I just checked again now, it does
Again, thank you
You're welcome. It's great tool and worth spreading.
Here, here
Rory’s gone……
_ …… but his Tool Lives on
_. May it continue to come up frequently for us.
Alan
P.s. …..
Part of my My earlier Signature, ( currently suspended in favor of an important message )
Post screenshots of your Spreadsheet Ranges that can be copied into a Spreadsheet
-See bottom of the page (Win & Mac): http://excelmatters.com/excel-forums/
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
And a few other links to versions of the Add-In
https://app.box.com/files/0/f/366413.../f_27863000440 ( XL 2007 + )
https://app.box.com/files/0/f/366413.../f_32131854803 (XL 2010 + )
Simple BB Borders code
https://app.box.com/s/soezox25h3w0q5s4rcyl ( XL 2010 + )
Simple Red BB Borders codes
https://app.box.com/files/0/f/366413.../f_32560517515 (XL 2010 + )
https://app.box.com/files/0/f/366413.../f_32629351849 (XL 2010 + )
Note:
When trying different Forum Tool ADD-Ins, always delete all versions form your computer entirely except the one you are trying. ( Otherwise Excel seem to decide which Add-In it uses regardless of the one you specify!!!! )
http://www.mrexcel.com/forum/about-b...rder-help.html
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
I uploaded the BB code earlier this morning then attempted to use it a little later when posting a solution. When I selected copy Excel quit responding and went into a recovery mode. When it started again the Forum Tools tab was gone, much the same as what had happened some time ago with PowerPivot 2010. I have an older laptop so maybe it is just a memory issue in which case there is probably nothing that can be done. I just wondered if anyone happens to have any ideas?
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc
I have older computers and Excel versions... This crashing thing on running a program is happening a lot more often with me recently
http://www.mrexcel.com/forum/general...l-crashes.html
, but not specifically as a result of an Add-in attempt. Of course you realise that when the File recovers itself it it will either open your last saved File or , if it can, a more recent one it did automatically. So if you did not save the File, ( and i think importantly also you may need to save the Add-in when you have it selected in the VB Editor window, ) then it may be gone when Excel recovers.
Maybe some ideas then:
_1) As I mentioned in the above Thread, this strange crashing problem seems to be less apparent if I run a code in F8 once or twice the first times. If you are using the Rory Add-ins then that means
open Module
mBBCode
in the VB Editor, ( Alt 11 )
Put a stop beside
Sub CopyRngToBBC(rInp As Range, bFrm As Boolean, bA1 As Boolean, bColour As Boolean)
then run
Sub ShowRangeToBBCForm()
in debug mode. ( F8 )
That may help, or at least in the debug mode you may see the error point where Excel is freaking out for you
_2) You will find it a bit difficult to contact the author of these codes here. You may want to ask here:
http://excelmatters.com/excel-forums/
_3 ) If you are still having the problems with the Add-in for a BB Code generation, then maybe a simple "stand alone" Code could help get you by in the mean time. Check out these Posts for info and a File with some codes in.
http://www.excelforum.com/developmen...ml#post4293889
http://www.excelfox.com/forum/f17/te...2079/#post9635
http://www.excelfox.com/forum/f13/bb...2077/#post9637
and here the File again
https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9
That one I keep up to date..
The current one i also put in the attachment to this thread
Hope that maybe of some help
Alan
Anyone know how to do this?
Data Range
A 1 10 2 20 3 30 4 40 5 50 6 ------
This is the code generated for my table:
I want to use a background fill color on some of the cells. How do I do that?HTML Code:
I've seen some example code but I can't get it to work. Probably not putting it in the correct location.
Last edited by Tony Valko; 04-04-2016 at 01:21 PM.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Testing.
Edit Do you mean like this? Using RangeToBBCode V0.7.xlam
Don't know which code change does the trick.
Does this help?
Row\Col A 1 10 2 20 3 30 4 40 5 50
More edit
HTML Code:
Last edited by FlameRetired; 04-04-2016 at 01:35 PM.
Dave
That looks like what I need.HTML Code:
Let me see what happens when I try it.
Hi Tony
Try out the last "Wonk" here ( At end of this Post: )
http://www.excelforum.com/the-water-...ml#post4324451
Alan
Last edited by Doc.AElstein; 04-04-2016 at 01:35 PM.
Data Range
A 1 10 2 20 3 30 4 40 5 50 6 ------
Looks good!
Thanks!
Last edited by Tony Valko; 04-04-2016 at 01:47 PM.
Great. __________
Thanks for the rep.
Marcelo Branco
Greetings Marcelo,
While this thread is active again I have another question.
After using the macro and that workbook is still open, I attempt to use it on another workbook the previous selection gets selected.
How do we clear previous selections without closing that workbook?
Thanks,
Dave
Marcelo,
Thanks for the updated code.
I'll have to "tinker around" with it and see how it works.
Hope Ford also sees this as he's been wanting to know which version of the code is the most up to date.
Thanks!
@Dave
That is weird ?? That has never happened to me with any BB Code Generator.
Every time you run the code, the current selection is converted to BB Code and put in the clipboard... or so I thought. Make sure no codes anywhere are still running in deBug, or that nothing anywhere is waiting for a carriage return ( Enter ) - I have found that those two things prevent anything being copied to the clipboard. That could explain why it worked when you closed the previous File. - Maybe something was still "active" in that file which got killed when you closed it
Alan
_.................
@Marcelo and Tony.
That code form Marcelo works great..
_.. added it to my “collection”
https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9
( And dropped an Edit to Ford..
http://www.excelforum.com/the-water-...ml#post4354756
Now he’ll be really confused!!.. lol )
Alan
Last edited by Doc.AElstein; 04-04-2016 at 06:51 PM.
Thanks, Alan.
In previous versions resetting in VBA editor usually did the trick. Something happened along the way and that doesn't work for me anymore.
If those things you listed are the issue it means I do that every time. That's a lot of coincidences. I also don't run macros / UDFs that often ... except for this one.
Kept looking for a way to insert some kind of clearing code in the macro. Never found it. My knowledge of VBA is very thin ... I can spell VBA ... most days. LOL
I've never found a link that covers this one. Ford raised the question early on, too. No response.
Thanks again,
Dave
Hi Dave
Ok something weird then. Sorry i could not help. I am no VBA expert either.
Maybe Marcelo or another one of the people who wrote these codes will get back to you on this one...
_... But i do know that...
_ in VBA, this normally clears the clipboard
Application.CutCopyMode = False
_ . and strangely i notice in Marcelo‘s most recent code he has this line, but he has it commented out...
'Application.CutCopyMode = False
And other codes have a
Declare Function EmptyClipboard Lib "User32" () As Long
And later in the code...
_______ ' Clear the Clipboard.
______ X = EmptyClipboard()
But i am out of my depth here and do not know what all that stuff is about.... !!! I only ever did very simple mods to the Codes from the Pros
_........
Hope you get it sorted..
Alan
P.s.I can tell you one other weird thing about Add-Ins to be careful of:
I sometimes found that when i was trying out the various Add-Ins that sometimes VBA did weird things and decided itself which Add-In to run, regardless of the one I had selected.
And the File name and the name seen in the Add-In list was sometimes different. So I sometimes found it was necessary to delete all BB Code Add-ins ( everywhere ! ) on my computer except the one i wanted to use so as to be sure that VBA “chose” the one i wanted!!). That is one reason why i went a bit away fron the Add-Ins, and turned them into “Stand alone codes”.. which I have a messy collection of in the file i linked.
Using the code in two workbooks
New version - observe the code line
Application.CutCopyMode = False
HTML Code:
Testing...
Workbook 1
A B 1 Names Scores 2 Anthony 10 3 John 20 4 Mary 30 5 Richard 40 6 Robert 50
Workbook2
A B 1 SKU Price 2 1001 10 3 1002 12 4 1003 14 5 1004 16 6 1005 18
Thank you, Marcelo.
I'm clueless, though.
Please tell me what I need to do with this? Where do I put what?
Do I need to edit / rename anything besides insert the "Application.CutCopyMode = False" line?
My VBA knowledge is zero.
Thank you, again.
Dave
@ Doc.AElstein
Thank you, again.
Maybe Marcelo will enlighten us both.
I think I need a "seeing-eye-programmer"! LOL
Dave
Put the code in Personal Workbook - see the link below
How to create a Personal Workbook
http://www.rondebruin.nl/win/personal.htm
You can find in the internet many tutorials/videos about VBA
Some links
http://www.easyexcelvba.com/introduction.html
http://chandoo.org/wp/2011/08/29/int...to-vba-macros/
http://www.ozgrid.com/Excel/free-tra...ba1lesson1.htm
Ignore this post
Last edited by mlcb; 04-04-2016 at 10:47 PM.
From Tony...
yes I did, thank youHope Ford also sees this as he's been wanting to know which version of the code is the most up to date.
From Doc (Alan)...
confused is my middle name - so nothing new there lol( And dropped an Edit to Ford..
http://www.excelforum.com/the-water-...ml#post4354756
Now he’ll be really confused!!.. lol )
OK with that new code from Marcelo (post 227), do I replace whatever I had for posting tables, with that code?
Hi Ford.
Not sure who you are asking. And i am nor sure what "code" ( or Add-In ) you are currently using.
But i just had another go at trying to clarify things a bit as far as i understand them for you:
http://www.excelforum.com/the-water-...ml#post4355240
Alan
Last edited by Doc.AElstein; 04-05-2016 at 08:11 AM.
Hi Dave
_1) First Just some extra quick info in addition to that from Marcelo on VBA Learning:
_a) These Threads has some good you Tube play lists... video series etc...
http://www.excelforum.com/excel-gene...ml#post4272300
http://www.eileenslounge.com/viewtop...175146#p175146
_b) the list of learning material that hiker95 often makes is a bit big.. but he tries to include the best he knows
http://www.mrexcel.com/forum/excel-q...ml#post4379195
http://www.mrexcel.com/forum/excel-q...ml#post4379209
_.................................................................................
_2 ).........
_..........................
.....................
_........................
Marcelo will probably confirm , but i think, he just put back in the line
Application.CutCopyMode = False
_ .. that is to say he edited just that line to take out the took the ' ( - you probably know a ' has the effect of making everything after it on that line turn into comments, that is to say just notes for your convenience, which VBA just ignores. So rather than removing a line, often one “comments them out” by putting a ' before. That way you can put the line back in later if you then change your mind. Or alternatively it just serves as a bit of documentation as a reminder for you as to what you did. )
It is always difficult to help not knowing exactly what level you are. I try:
Basically we are talking about two different things. A) Add-Ins and B) what i call “stand alone codes”
_A) Add-Ins
Add-Ins are more “user friendly” things, ( at least once you have them installed !! installing can be very user unfriendly lol !! )). Once there you have something extra up in the Ribbon bar and you click on it and then a Message box prompts you etc.. etc... etc.......
If you go for the “Add-In option”, then Probably Rory’s is the best to go for. I think He has complied together , added to , improved etc.. codes from the likes of Marcelo Branco, Tony Valko, Jon von der Heyden, Peter (VoG), and Stephen Gersuk ( and i apologise if i have missed anyone. )
Current Add-in and some ( badly) written notes from me on how to install an Add-In for example here:
Add-In:
https://www.dropbox.com/s/31r9s6t9j6...ools.xlam?dl=0
Notes:
http://www.excelforum.com/the-water-...ml#post4109080
http://www.excelforum.com/developmen...ly-needed.html
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
(-..also ... Jon von der Heyden did some notes on a specific HTML Code Generator Add-In that is not supported here at Excel Forum, but again it may give you an idea how to install an Add-in
http://www.mrexcel.com/forum/about-b...ml#post2507729
_.... )
_...............................................................
_B ) “Stand Alone Codes”
An example of this is what Marcelo presented yesterday. That is one of a few codes that would probably be incorporated into one of those Add-Ins.
Again i do not know your exact level of VBBA knowledge.
This is the typical gem given to beginners....
How to get a macro up and running:
(IMPORTANT: always save your File just before you run any macro. –This is Because you cannot use the Excel backward thing to clear any changes made by a macro.
(Actually When you “work on your File” you effectively work on a copy of your File. It only becomes your file when you save http://www.mrexcel.com/forum/excel-q...ml#post4425428 ...._)
_ - So If anything goes wrong after running a macro, then simply close the file without saving, then open it and no damage will have been done to your original File. )
To Install a macro:
1. Copy the code given to you to the clipboard. ( Highlight code and Hit Ctrl C )
2. Open a NEW workbook ( or the workbook you want the code in )
3. Press the keys ALT + F11 to open the Visual Basic Editor
At this point you should see the cursor flashing in a big empty window
( If not then select from the VB Editor ribbon ---- Insert ------ module )
4. Where the cursor is flashing, paste the code
5. Do any editing of the code you wish to at this stage.
6. Press the keys ALT + F11 to return to Excel ( or press ALT and q simultaneously to close the VB Editor )
To run or wonk or work on a macro:
7. When in Excel, press ALT + F8 to display the Run Macro Dialog Window Box Thing.
8. You can choose to run the code ( alternatively Double Click the macro's name to Run it.)
Or
9. You can choose to work ( or wonk** ) on it. – This option is good to find the macro if you have many and are not sure where they all are )
( **a wonk is what i do on the Pros codes.. in other words i ruin them for my own perverse pleasure lol )
_................................
You may want as an alternative to putting the code in a particular File, to create a PERSONAL.XLSB, and ADD a button to ribbon ( XL 2010 + ) or ADD a quick access symbol XL 2007 +.
( That way it is similarly to the Add-In "always there " for you when you open Excel )
For that i cannot explain it better than the Link Marcelo gave you
http://www.rondebruin.nl/win/personal.htm
Or you may find mine and Jerry’s instructions a bit quicker to follow:
http://www.excelforum.com/tips-and-t...ml#post4109262
http://www.excelforum.com/the-water-...ml#post4110298
_...............................................
Some other “Alan options”!!!!
_ C) I “collect” all these codes in this file
https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9
So just play with that, running for example this code ( Found from Excel as in the above instructions 7. above )
Sub ShowRangeToBBCFormJune()
( I assume that you know that the start point before running any BB Code Generating Add-In or “stand alone code” is to highlight the range you want to show in a Forum Post. That Range is then converted to a BB Code to produce a Table and that code placed in the Clipboard. You then paste in the Forum Editor ..
_ – Practice pasting in here
http://www.excelforum.com/development-testing-forum/
And here:
http://www.mrexcel.com/forum/test-here/
_............
_D) Last just for Fun . For you and Ford as you were over there more recently, ( where the Post editor is kinder and allows a lot at once to be pasted:......
http://www.mrexcel.com/forum/test-he...ml#post4480787
( but note, that Thread will likely be routinely deleted in a few days )
Alan
Last edited by Doc.AElstein; 04-05-2016 at 01:47 PM.
Test new code...
A B C 1 Type Amount Y/N 4 Data3 82 N 5 Data4 84 N
Range has autofilter applied
Just testing
A B 1 E FALSE 2 H 3 H FALSE 4 K 5 A FALSE 6 Y 7 E TRUE 8 E 9 U FALSE 10 J 11 G FALSE 12 T 13 H FALSE 14 A 15 Y FALSE 16 V 17 B FALSE 18 Q 19 A FALSE 20 B 21 I FALSE 22 O 23 O FALSE 24 U 25 T TRUE 26 T
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks