Categories
Oracle Work

Oracle SQL Developer and Commas

Just found an interesting feature in SQL Developer 3

I created a dataset that contained two columns of numbers that I wanted to quickly get into excel. I choose, export in CSV format to clipboard so that I could quickly paste it into an existing spreadsheet.

My dataset contained:

1234, 5678
2345, 6789
3456, 7890

The data that was exported was:

12,345,678
23,456,789
34,567,890

Have to export to an xls file, open it then copy and paste – YAWN !

Categories
Microsoft Office Windows Work

Microsoft Office–VBA Editor Keeps Opening

For weeks now I have had the mild annoyance that the VBA code editor for various Excel spreadsheet’s appear to be opening at “randomâ€?. I finally tracked it down to me unlocking my PC. If I have excel running then lock my PC, when I unlock it, the VBA code editor appears.

I’m using Office 2003 SP3 on XP Pro SP3.

Turns out that there is a VERY easy fix – don’t maximise the VBA code editor.
If the editor is maximised, it appears on unlock, if it is not maximised it does not appear automatically on unlock.