Solved- Microsoft Excel printing to multiple PDF instead of a single one

Excel will do this if the DPI(print) setting are not consistent.

 If this is the case for you, select all sheets and go to page layout and change Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Quick Microsoft Excel Tip: To find the last used cell in a column

Just use the cell’s  .End(xlDown).Select

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Import data into SQL Server using VBA

One particular client had key financial information in SAP to be brought into a SQL Server database backend for use via the Excel front end tool by managers and analysts for reporing.

Unfortunately despite being a FTSE 100 Multi national with a recordset to match and still using Excel 2003 with the row limit, they had not envisiged that their one stop solution (Business Explorer  (BEx) an Excel addin) would fail to be anything but perfect for all users and thus had not obtained the Openhub license required to link directly/obtain bulk extracts and ETL wi Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Advanced Autotrader.co.uk options!

Discovered a little known feature of atotrader so here you go!

In normal search you are only able to sort the results by Highest & Lowest price along with distance. However it is also possible to sort by advert age ie put newest and oldest first Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Solution: Dell Latitude E6400 poor Sound quality bug

Tried to listen to music today on a Dell latitude E6400, tried We7.com and the sound was woeful, so tried  Grooveshark.com and the same Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Business Objects- Report scheduling bug

Discovered a strange Boxi bug today Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Reviewed: Britains Got talent 2010 auditions – Sat 23rd Jan 2010 (Manchester Opera House)

Verdict: Worth going to once, but only because its free: a very chavvy affair.

Review:

Having received the free tickets back in December had been looking forward to the day coming around, the event started at 13.15 and finished around 6pm Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

DTS: The login already has an account under different user name

Came across this package failing one today when trying to copy database objects to a different server.

After trying various things discovered Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Joke of the day

A white man and a asian man walk into a cafe, the waiter asks what they would like and the white man says: A tea and a Scone The asian man though asks for a ’short back and sides’, the waiter says “what is he on about”, the white man replies “don’t worry about it, just get him a tea and Scone too”.

Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Code for £100 off all Thompsons Holidays

£100 off code!

£100 off code!

Just enter code 9358 when booking online at Thompson.co.uk Read the rest of this entry »

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot