How to Post code that we can copy/paste easily ?

[Bobbles]

I AM NOT RE-OPENING THIS THREAD,
however I wanted to use Zynder's post to illustrate a point

Zynder,
One of the banes of my life have been the chunks of code that appear in this forum, which are a pain, to copy and paste into our programs.
They have annoying Line numbers, and lots of blank lines.

However your code posting was perfect.
Could you teach the code posters how to do that ?


Here is another fast exporting to excel without looping through cells. It's a basic copy and paste. Good for exporting thousands of records.

Fast Export Flexgrid to Excel

[CODE]Private Sub cmdExportToExcel_Click()
Dim xls As Excel.Application

Set xls = New Excel.Application

xls.Workbooks.Open (App.Path & "\Template.xls")

xls.Visible = True

[si_the_geek]

If you click the Quote button on the post you will see the code as purely text, which is easy to copy.

[Bobbles]

That works.
All these years pruning line numbers and blank lines.
Will I mark it resolved, or could there be others that were unaware of this ?
Thanks for the info.

[RhinoBull]

You don't mark somebody else's thread "resolved" - instead of "hijacking" this thread you could have simply opened new in forum feedback.
Thanks for your feature considerations.

[Bobbles]

You don't mark somebody else's thread "resolved" - instead of "hijacking" this thread you could have simply opened new in forum feedback.
Thanks for your feature considerations.

You are a sour individual, and have been for years.
I bumped the thread as it had the only example of posted code (that I have seen in this forum) that was easy to copy.
If you have nothing nice to say, then keep out of it.

[si_the_geek]

While RhinoBulls post could have been worded a bit better, the points he raised are all valid.

You do not have the ability to mark a thread as Resolved unless you were the one who started the thread - otherwise it could be used accidentally/maliciously to stop the thread starters questions being answered.

As a general rule you should not post questions (particularly off-topic ones) to other peoples threads, as it tends to cause confusion etc, and can be the cause of the thread starter not getting their own questions answered. In this case (with a thread that many people link to) it causes extra reading for those who go to it for help.

The Forum Feedback forum is there for questions about site usage etc, so that is where you should ideally have posted - and I have now moved these few posts to a new thread there.


I bumped the thread as it had the only example of posted code (that I have seen in this forum) that was easy to copy.Many of us are aware of the limitations of the current implementation of VBCode tags, and therefore use the Code tags instead (as used in zynder's post).

Unfortunately there are lots of posts from before the current VBCode tags (as the older version didn't have the same problems, but aren't compatible with the forum software any more), and it is an awful lot of effort for people to go back and edit all of their earlier posts - it took me a few weeks just to alter my tags in the FAQ threads I have posted.