| | |
Data in spreadsheet is not printing on same page
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Jul 2007
Posts: 113
Reputation:
Solved Threads: 0
Hello everyone,
I am using VB6 to generate a report in Excel but I am having a printing problem. I generated a spreadsheet using an access file. The data in the spreadsheet stretches all the way from Column A through S.
When I print, columns A through M prints on one page and columns N through S prints on another page, splitting the spreadsheet data into two separate pages. How can I get the whole spreadsheet to print on one page: I mean columns A through S to print on the same page.
Note: I have used the "FitTopage" function, buy that's not working.
Thanks.
Giftx
I am using VB6 to generate a report in Excel but I am having a printing problem. I generated a spreadsheet using an access file. The data in the spreadsheet stretches all the way from Column A through S.
When I print, columns A through M prints on one page and columns N through S prints on another page, splitting the spreadsheet data into two separate pages. How can I get the whole spreadsheet to print on one page: I mean columns A through S to print on the same page.
Note: I have used the "FitTopage" function, buy that's not working.
Thanks.
Giftx
![]() |
Similar Threads
- spreadsheet won't fit in a single page (Visual Basic 4 / 5 / 6)
- problem ragarding printing a page (HTML and CSS)
- problem ragarding printing a jsp page (JSP)
- Lexmark printer Z53 stops printing in middle of page (OS X)
- Preventing URL's from printing to the bottom of a page printed from a website. (Geeks' Lounge)
- No page header and footer when printing a web page (JavaScript / DHTML / AJAX)
- Printing Web Page (Windows 95 / 98 / Me)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Filter using Binding Source
- Next Thread: run time error '3290' for creating recordset
| Thread Tools | Search this Thread |
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp 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 machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





