Messed up display of conditional compilation directives

[Jaafar Tribak]

Hi forum,

First, I would like to congratulate the MrExcel community on the new Board and I wish it success.

I have noticed that in previous posts where conditional compilation is used, the #If #Else #End If lines are not displayed correctly .

See this old post as an example :

Which Range is currently being Cut or Copied ?

Hi dear forum members, I have a vba situation where I need to know the address of the range that is currently being copied (or cut) ie: when Application.CutCopyMode 0 . I wonder if I am overlooking some easy solution or missing something obvious. Regards.

www.mrexcel.com

Interestingly, this doesn't seem to happen with new posts like here :

Test Conditional Compilation

Option Explicit #If VBA7 Then #Else #End If Sub Test() 'this is a comment End Sub

www.mrexcel.com

 

[smozgur]

First, I would like to congratulate the MrExcel community on the new Board and I wish it success.

Thank you, @Jaafar Tribak!

I just fixed the post you reported above.

Reason: It had inner tags, color, url etc. The only way to make codes including bbcode is using the Rich Code option after the migration. I just added =rich into the code tag, and now it should render correctly.

Normally, selecting VBA will be good enough from now on. The code will be highlighted automatically without any inner bbcode.

We had to use this method (rich) to provide backward compatibility, however not all posts have been converted (due to not containing certain patterns). Please do not hesitate to let us know by reporting your own post (or others) with "Code doesn't show correct" or similar message.

 

[Jaafar Tribak]

Thank you for looking into this and correcting the problem.

Unfortunatly, I have dozens of similar codes all over the forum where the issue still remains .. I wonder if they can all be fixed.

Regards.

 

[smozgur]

Unfortunatly, I have dozens of similar codes all over the forum where the issue still remains .. I wonder if they can all be fixed.

Yes. As long as we can define the pattern, we can fix them. It might take some time, but we'll continue fixing such content.

Thanks again for reporting this.

 

[MARK858]

Just in case as most of the old posts seem to be rendering correctly I have just come across this one from Robert Mika that hasn't rendered correctly....

Calculating Gestational Age

Hello All, I am creating an outpatient log using Excel for a Labor & Delivery Unit. Is there a way to calculate a gestational age by entering the due date? Ideally a staff member would enter the EDC (est. date of confinement), say 3/31/2012 in A2 and the EGA (est. gestational age) would...

www.mrexcel.com

 

[smozgur]

Just in case as most of the old posts seem to be rendering correctly I have just come across this one from Robert Mika that hasn't rendered correctly....

Thanks for reporting this, Mark.

As we explained in the help page:

For the forum migration in November 2019, more than 90 thousands of existing posts using HTML-based codes were converted to XL2BB code. We found that there were many versions of HTML Makers in use and the output from some tools have not been converted yet. We are still working on converting those after the migration.

For example, in this sample you reported, our member looks to be invented his own HTML maker script, or simply generated the table HTML codes manually and used in the post.

It is not easily possible to convert them manually by the way, but we keep defining patterns and converting to the XL2BB tags with some programming help. It will just take some time.

Thanks again.

 

[MARK858]

Thanks for replying smozgur, I know that you are still working on it but I thought I had better report it as most of the posts I have seen you have done great work to manage to get converted.

Btw, I doubt if Robert made up his own Html for the post as he made too many posts per day to go to that much effort (whether he used Colo's original code though I don't know).

 

[smozgur]

I thought I had better report it

Absolutely! I really appreciate you did that.
And thank you for your kind words.

Actually I was just giving a sample about different patterns by using the post, not even looked who posted it. It was the only proper and great way and Colo’s HTML Maker will be always one of the best tools that was used in MrExcel Message Board. Beyond that, thanks to Colo, his HTML pattern(s) was really clean to catch with Regex even it is not quite possible to parse HTML with Regex properly since it is not a strict language like XML.

We’ll keep converting the rest. Thank you so much for your help!