 |  |  |  |  |  |  |  |
spreadsheet won't fit in a single page
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
I have a spreadsheet that I populated from an access table (file).
when I print the data in the spreadsheet, part of the data prints on one page and the other half prints on another page. In otherwords, I have to paste two pages together to see the complete record.
I have used:
xlWksht.PageSetup.FitToPagesWide = 1
xlWksht.PageSetup.FitToPagesTall = 1
But it does not fix the problem...... Please help anyone!
Thanks
tgifgemini.
when I print the data in the spreadsheet, part of the data prints on one page and the other half prints on another page. In otherwords, I have to paste two pages together to see the complete record.
I have used:
xlWksht.PageSetup.FitToPagesWide = 1
xlWksht.PageSetup.FitToPagesTall = 1
But it does not fix the problem...... Please help anyone!
Thanks
tgifgemini.
|
Similar Threads
- VB6/Excel - Using Char(10) to fit a long rcrdset as two lines within same recordset (Visual Basic 4 / 5 / 6)
- should i optimize the same keywords for each page on your site? (Search Engine Optimization)
- Change Web Page Font Size on the Fly (Windows tips 'n' tweaks)
- Help burning a Img file to single layer (OS X)
- Multiple Adsense publishers on single site (Advertising Sales Strategies)
- converting from javascript to HTML? (Java)
- Cheap Advertising available, or RENT a PR4 page! (Ad Space for Sale)
- Page cannot be displayed (Web Browsers)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Help me to read the files of Real Player (RM,RAM...etc)
- Next Thread: Printing in a usb port
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
