Archive for the 'Microsoft Office' Category

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 to make sure the DPI settings set to the same.

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

Import data into SQL Server using VBA

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

ADO Late binding note – avoid missing reference & compatibility issues.

ADO Late binding example

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