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 !
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.
A nice quick tip, I had lots of cell values in a mixture of cases that should have been uppercase.
Create a macro:
sub MakeUpper()
for each myCell in Selection
myCell.Value = UCase(myCell.value)
next myCell
end sub
Add a menu item to your toolbar and then assign this macro to it.
Select the cells you want to upper case then press the button!
Sometimes you find a feature in a product that is just blatantly missing. One of those in Microsoft Word is the ability to update all the fields in the document with the latest value in a field.
I use both the built in fields e.g. Author, Version, Title and custom fields e.g. Project Code. I set the values once in the document properties and then insert the field codes in the document rather than the text. All is well. If you change the value of a field you can press F9 and all of the fields update to the latest value EXCEPT if you have used the fields in the document header or footer, these do not get updated for some reason. I would classify this as a bug, why would I not want all instances of the same field to be in sync throughout my document.
The solution is remarkably simple. Create the following macro:
Sub UpdateAll()
Dim oStory As Range
Dim oField As Field
For Each oStory In ActiveDocument.StoryRanges
For Each oField In oStory.Fields
oField.Update
Next oField
Next oStory
End Sub
This can be saved in your normal.dot file and will be available in all your word documents.
I’m building up for my running challenges of 2011 and breaking in my new treadmill so I am slowly building up my miles.
On incentive is the Marcothon group on FaceBook, the basic premis is to run for either 3 miles or 25 minutes in every day in December.
I have also been mucking around with Xcelsius for a parkrun project, more on that later.
To keep an eye on my progress I have built a dashboard to track my running over the current year and so I can visually compare my training year on year.
If you look at the left hand menu you will see the items:
These can be quickly accessed by using the following shortcut keys:
In addition, when you use Ctrl+1 to access mail, this takes you to the folder that you were last using, if you would rather jump straight into your In-Box – use (Ctrl+Shift+I).
I kept forgetting to start Google Calendar Sync when I started Outlook. I don’t always start Outlook when I start my laptop and I’m not always online when I run Outlook so puting it in my Startup folder is not really an option.
My solution, a macro that runs when Outlook starts that gives me the option of running Google Calendar Sync if I feel it’s appropriate.
Private Sub Application_Startup()
Dim response As Integer
Dim RetValresponse = MsgBox(prompt:=”Do you want to run Google Calendar Sync?”, buttons:=vbYesNo)
If response = vbYes Then
RetVal = Shell(“C:\Program Files\Google\Google Calendar Sync\GoogleCalendarSync.exe”, vbMinimizedNoFocus)
End IfEnd Sub
I’m using Microsoft Outlook 2007 and I think it’s a great piece of software.
It has a built in RSS feed reader. Typically I use Google Reader but as that can’t handle authenticated feeds I’m using Outlook for all of my work related Sharepoint feeds.
In order to introduce people to RSS, Microsoft have included two “standard” RSS feeds: “Microsoft At Home” and “Microsoft At Work”.
The only problem is, I’m not really interested in reading these feeds.
Continue reading »
Last week I gave a colleague a demonstration on why, if you have numbers stored in a character string you should convert them explicitly to numbers:
select ‘Yes’
from dual
where ’1000′ between ’000′ and ’999′;‘YES’
—–
Yes
Google Reader
Follow me on Twitter
Recent Comments