Go to Top

Great article on using Excel object model

Recently I had to create an Excel spreadsheet export for one of my clients using my Report Generator in Access, it was a thorny project since it wasn’t a straight export from a query or table. I had to instead use vba to create the spreadsheet and place the values of each column and row into each cell.

My client also wanted to have the finished spreadsheet formated to zoom on one page, margins at 0.25 inches and other requirements. I found the link below invaluable, in particular the section on Page Setup.

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

I highly recommend book marking it! Here it is:

http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=2

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
  • This field is for validation purposes and should be left unchanged.