Print First And Last Page In Excel
I am trying to build a macro in VB to print out only the first and last page of Excel reports that I produce. Is there anything that returns the last page?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Vb Want Print My Excel Page.
Hello people,
I'm trying to find the vb code to print a page out of a excel file.
VB Code:
Spreadsheet3.XMLURL = App.Path & " est.xls"Spreadsheet3.ActiveWorkbook.Sheets("Blad3").SelectSpreadsheet3.ActiveWindow.SelectedSheets.PrintOut Copies:=1
I get everytime a error on PrintOut with the message Method or data member not found.
What is wrong and is there somebody who can help me with the correct line.
How To Print Custom Page # In Excel ?
Hi,
I need to print in a cell (not in the footer) the custom page # of the printed sheet. For example, if a sheet occupies two printed pages then the first page should show in cell A1 "Page A" and the second page should show in cell A1 "Page B".
How can it be done in VB?
Thank you
Vladk
Excel Page Breaks And Print Settings
I'm flying blind here, no previous VB programming experience before I needed to get this project done!
I am starting with an dump of data exported to Excel which includes rows ordered by a location ID and a group ID (several groups for each location). What I need is to print the data out for each group, with the groups separated on individual pages (groups may overflow to more than one page also). Ex: group 1 has 20 members, fitting on page 1. Group 2 has 50 members, which takes up a page and a half (pages 2 and 3). Group 3 should be printed starting on page 4.
To achieve this I have created a macro which uses a variable to store the group ID and then goes line by line to check if the next row is in the same group. It copies all members of one group to a separate sheet, adjusts the print margins to include all the data, and prints the group. Then it clears the sheet and proceeds with the next group.
My question is as follows. Is there any way to get this printed as ONE print job? Other than making a new sheet for each group? To simplify printing I coded the print setup into the macro, but it sends each group as its own print job. I need users at other computers to be able to print this also, and printer installation settings vary. If I could bring up the print dialog ONCE, they could choose their printer of choice and also put in their copy code. We use print job accounting and our IT guy is wary of disabling it for this one purpose.
Hope this is not too confusing! If anyone needs clarification or code excerpts, please let me know.
THANKS!
[Edit: I suppose an easy way to do it would be to keep all the data on one sheet and set the page breaks after each group. Is there any VB command to do this in Excel?]
VBA Excel: Combine Print Range On Same Page
Assign multiple print ranges within a single Excel Worksheet
Is this performed through a pagesetup function? Please get me started...thanks
Private Sub CommandButton1_Click()
Dim rCol As Range
Dim rCell1 As Range, rCell2 As Range
Dim Sht As Worksheet
'Set range variable to Selection
Set Sht = ActiveSheet
Set rCol = Sht.UsedRange.Columns(1)
'Insert page breaks
Sht.PageSetup.PrintArea =
Optimizing Code To Print A 2 Page Excel File
I have built a Timesheet program from scratch (VB6/Access DB). In it, we have the option of putting information on a separate page to show descriptions of what we did during the week (everything, not billable, or billable).
If there are more than 36 entries for the week, the program creates a new page for the rest of the items, but puts the description on the 2nd page. I would like to change this so that the entries that are on the page would have the corresponding descriptions on the back, but I'm not sure how.
Here's the relevant code:
Code:
'Print 2 page timesheet
Public Sub PrintTimeBack()
Dim TFileName As String, CurJob As String, CurTask As String, BottomRow As Long
Dim Row As Long, Found As Boolean, TheDate As Date
Dim Records As Integer, SetOnce As Boolean, BottomRecords As Integer
Dim Index As Integer, JobId As Integer, Selection As String, TempRow As Long
Dim ResetSheet As Boolean, ResetOnce As Boolean, TBackNo As Integer
CallingForm = "PrintTimeBack"
On Error GoTo ErrHandler
SetTempPrint
ReDim JobPrinting(0)
Jobs = 0
'Load up hours table so it is sorted by Job# asc, Taskcode asc
ChangeHoursPrintable
'Set up control information
Records = 0
BottomRecords = 0
ResetSheet = False
ResetOnce = False
SetOnce = False
'Move to first item in table
If Not rstHours.BOF Then
rstHours.MoveFirst
End If
'Show the user some stuff
fraSavPrint.Visible = True
lblInfo = "Setting up 2 Page..."
pbSave.Value = 0
'Set file name
TFileName = "timesheets s_" & Replace(Right$(CurWeek, _
(Len(CurWeek) - 4)), "/", "_") & "_2pg"
'Set up time into array for later printing, this will get all the
' job numbers and codes summed together
Do While Not rstHours.EOF
Index = 0
Found = False
'See if find item in array
Do While Not Found And Index < Jobs
If LCase$(JobPrinting(Index).Num) = _
LCase$(rstHours.Fields("jobno")) And _
LCase$(JobPrinting(Index).Code) = _
LCase$(rstHours.Fields("jobcode")) Then
JobId = Index
Found = True
End If
Index = Index + 1
Loop
'If you don't find it, create new array item
If Not Found Then
If Jobs > 0 Then
ReDim Preserve JobPrinting(Jobs)
End If
Jobs = Jobs + 1
CurJob = rstHours.Fields("jobno")
CurTask = rstHours.Fields("jobcode")
SetJobPrinting (Jobs - 1), CurJob, CurTask
JobId = Jobs - 1
End If
'Switch on what weekday the jobdate is
' Then put the task code and hours into the array
Select Case Weekday(rstHours.Fields("jobdate"))
Case vbMonday
JobPrinting(JobId).Mon = JobPrinting(JobId).Mon + _
rstHours.Fields("hours")
Case vbTuesday
JobPrinting(JobId).Tue = JobPrinting(JobId).Tue + _
rstHours.Fields("hours")
Case vbWednesday
JobPrinting(JobId).Wed = JobPrinting(JobId).Wed + _
rstHours.Fields("hours")
Case vbThursday
JobPrinting(JobId).Thu = JobPrinting(JobId).Thu + _
rstHours.Fields("hours")
Case vbFriday
JobPrinting(JobId).Fri = JobPrinting(JobId).Fri + _
rstHours.Fields("hours")
Case vbSaturday
JobPrinting(JobId).Sat = JobPrinting(JobId).Sat + _
rstHours.Fields("hours")
Case vbSunday
JobPrinting(JobId).Sun = JobPrinting(JobId).Sun + _
rstHours.Fields("hours")
End Select
rstHours.MoveNext
'Show the user that the program is still running by increasing
' the progress bar
If (pbSave.Value + (rstHours.RecordCount / Jobs)) > 100 Then
pbSave.Value = 100
Else
pbSave.Value = pbSave.Value + (rstHours.RecordCount / Jobs)
End If
Loop
'Load up template file
SetExcelFile App.Path & "" & "templatelankwback.xls"
'Use the timesheet front for the sheet
Set Excel_Sheet = xlBook.sheets("Timesheet Front")
'Set up information at the top of the page
SetExcelTop TheDate
'Set up row information
Index = 0
Row = 3 'Top row to put information in
BottomRow = 39 'Bottom row to put information in
SetOnce = False
'Put data from array into sheet
Do While Index < Jobs
'If all rows are filled (CheckReset checks this), reset sheet check
If Not ResetOnce Then
If Not ResetSheet And CheckReset Then
ResetSheet = True
End If
'Actually reset the sheet
If ResetSheet Then
EndExcelSheet TFileName
SetExcelFile App.Path & " emplatelankwback.xls"
Set Excel_Sheet = Nothing
Set Excel_Sheet = xlBook.sheets("Timesheet Front")
SetExcelTop TheDate
Row = 3
BottomRow = 39
SetOnce = False
SetTempPrint
If Right$(TFileName, 4) = ".xls" Then
TFileName = Left$(TFileName, Len(TFileName) - 4) & "_2" & _
Right$(TFileName, 4)
Else
TFileName = TFileName & "_2"
End If
ResetOnce = True
End If
End If
'like "##9##" goes at bottom
'not like "##9##" goes at top of sheet.
If JobPrinting(Index).Num Like "##9##*" Then
'start at bottom of the sheet
TempRow = BottomRow
SetOnce = True
Else
'start at top of the sheet
TempRow = Row
SetOnce = False
End If
'Find next open item in the database
Do While PrintedRow(TempRow) = True
If SetOnce Then
TempRow = TempRow - 1
Else
TempRow = TempRow + 1
End If
Loop
'Put information into sheet
PrintRow Index, TempRow
'There is information in this row now
PrintedRow(TempRow) = True
Index = Index + 1
Loop
'Print sheet into actual excel file
PrintToExcel
'Set current printing date and time
SetCell 42, 2, Format(Now, "Short Date")
SetCell 42, 6, Time
ChangeHoursWeekly
If Not rstHours.BOF Then
rstHours.MoveFirst
End If
Row = 3
Set Excel_Sheet2 = xlBook.sheets("Timesheet Back")
SetCell2 1, 2, MyPrintName
'Job number selects what goes on the back sheet
' option 1 would have everything
' option 2 would have a 9 in the 3rd position (non-billable time
' option 3 would have anything else in the 3rd position
If lstSheets.Selected(1) Then
Selection = "#####*"
ElseIf lstSheets.Selected(2) Then
Selection = "##9##*"
Else
Selection = "##[012345678]##*"
End If
Do While Not rstHours.EOF
'Back of sheet gets selected time time
' If the job number matches above selection, put it on the sheet,
' otherwise skip it
If rstHours.Fields("jobno") Like Selection Then
Found = False
'Find matching name from listing in another table
If Not rstJobNos.BOF Then
rstJobNos.MoveFirst
End If
Do While Not rstJobNos.EOF And Not Found
If rstHours.Fields("jobno") = rstJobNos.Fields("jobnumber") Then
SetCell2 Row, 1, rstHours.Fields("jobno") & _
" / " & rstJobNos.Fields("jobcompany")
Found = True
Else
rstJobNos.MoveNext
End If
Loop
'Put the Job number
SetCell2 Row, 3, Format(rstHours.Fields("jobdate"), _
"Short Date")
'If there is a task code, display it.
' example of task coded entry: 1 - Misc (0.25 hours)
' example of non coded entry: Misc (0.25 hrs)
' The replacethiswiththat function clears the newline character
If Not rstHours.Fields("jobcode") = "" Then
SetCell2 Row, 4, rstHours.Fields("jobcode") & _
" - " & ReplaceThisWithThat(rstHours.Fields("description"), _
Chr(13), " ") & " (" & Format(rstHours.Fields("hours"), _
"#0.00") & " hrs)"
Else
SetCell2 Row, 4, _
ReplaceThisWithThat(rstHours.Fields("description"), _
Chr(13), " ") & " (" & Format(rstHours.Fields("hours"), _
"#0.00") & " hrs)"
End If
Row = Row + 1
End If
'Again, show user that stuff is happening
If pbSave.Value + (45 / rstHours.RecordCount) > 100 Then
pbSave.Value = 100
Else
pbSave.Value = pbSave.Value + (45 / rstHours.RecordCount)
End If
rstHours.MoveNext
Loop
Excel Macro To Print First Page Of Multiple Tabs
Hi
I'm trying to create a macro that will print the first page of each tab in an Excel workbook at once. Does anyone have any ideas?
Is there anyway to create a generic macro that can be used in any workbook?
Problem With Print, Page Setup, And Print Preview In A Text Editor...
Yes, I have another question.
When I use these exact same functions (with WebBrowser.ExecWB in place of txtScrapbook.Text) in my web browser, it works perfectly. But when I use them in reference to a text box, it doesn't.
Can you tell me where the problem lies, or give me an alternative method? I have a common dialog box already for other functions, so feel free to make use of it if you need to. Thanks.
Code:Private Sub PageSetup_Click()
txtScrapbook.Text OLECMDID_PAGESETUP, OLECMDEXECOPT_DODEFAULT
'opens page setup dialog
End Sub
Private Sub Print_Click()
txtScrapbook.Text OLECMDID_PRINT, OLECMDEXECOPT_PROMPTUSER
'opens common dialog box prompting user to print current web page/parts of current web page
End Sub
Private Sub PrintPreview_Click()
txtScrapbook.Text OLECMDID_PRINTPREVIEW, OLECMDEXECOPT_DODEFAULT
'opens print preview dialog
End Sub
How To Print Images That Fit To The Page Size Specified In Print Common Dialog?
i need some help in printing the whole image tat fit onto the paper size i specified in Print Common Dialog. I hav a PictureBox array & each PictureBox contains a smaller Picturebox inside. For example : Picture1(index) has a smaller Picture2(index) inside. There are vertical & horizontal scrollbars next to each Picture1(index).
i already hav the basic Print Common Dialog code below. Here's the problem -> I can print out the pictures displayed inside Picture2(index) but the printout will turn out truncated or just part of the whole picture when im printing to a 4R photo size for example and the image displayed in Picture2(index) is larger then the bounding Picture1(index) & i need to use the scrollbars to scroll and view the other portions of the image.
So how to modify the code below to print out the whole image tat fit nicely to the paper size i specified. Thanxs.
'---------------------------------------------------------------------
'CODE
'---------------------------------------------------------------------
CommonDialog1.CancelError = True
On Error Resume Next
CommonDialog1.Action = 5 ' Start the Print Common Dialog
If (Err.Number = cdlCancel) Then Exit Sub
'when Cancel is pressed, exit subroutine
'Code to print the array here
For Pics = Picture2.LBound To Picture2.UBound
If Picture2(Pics).Picture > 0 Then ' If the PictureBox is not empty
Printer.PaintPicture Picture2(Pics).Picture, 0, 0
Printer.EndDoc
End If
Next
'---------------------------------------------------------------------
Print Picture Box (print A Form That Is Too Large For The Screen Or Page)
I got a picture box (Picture1), which contain several picture box'es, labels and
Flex Grid tables, -which I would like to print. Picture1 is quite high (higher than the screen). I found some code that i modified, but the printing only get the labels proper. The Flex Grids and picture box'es only show the border, and not the contents.
Code:Private Const WM_PAINT = &HF
Private Const WM_PRINT = &H317
Private Const PRF_CLIENT = &H4& ' Draw the window's client area.
Private Const PRF_CHILDREN = &H10& ' Draw all visible child windows.
Private Const PRF_OWNED = &H20& ' Draw all owned windows.
Private Declare Function SendMessage Lib "user32" Alias _
"SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, _
ByVal wParam As Long, ByVal lParam As Long) As Long
Private Sub Print_Click()
Dim rv As Long
Me.ScaleMode = vbTwips ' default
With Picture2
.Top = Picture1.Top
.Left = Picture1.Left
.Width = Picture1.Width
.Height = Picture1.Height
End With
Me.Visible = True
DoEvents
Picture1.SetFocus
Picture2.AutoRedraw = True
rv = SendMessage(Picture1.hwnd, WM_PAINT, Picture2.hDC, 0)
rv = SendMessage(Picture1.hwnd, WM_PRINT, Picture2.hDC, _
PRF_CHILDREN + PRF_CLIENT + PRF_OWNED)
Picture2.Picture = Picture2.Image
Picture2.AutoRedraw = False
Printer.Print ""
Printer.PaintPicture Picture2.Picture, 0, 0
Printer.EndDoc
End Sub
Edited by - Zigar on 11/27/2003 3:31:21 AM
Print Column Header On Each Print Out Page
I am trying to put the header of each column on each print out page.
Right now I have it only appearing on the first page of my printouts.
How do you do that in Excel 2003?
HELP Print Listview Print To Many Page
HI
I am using this to print Listview
When I print 1 page then it is ok but
if data from Listview go on 3 or 4 page then fyrst page is ok
efter fyrst page I only get 1 data on on each page
so this can be many page
Can somone help me what is wrong in this ??
Printer.Font = "Tahoma"
Printer.FontBold = True
Printer.FontUnderline = False
Printer.FontSize = 10
Printer.Print "Print from listview"
Printer.FontUnderline = False
Printer.Print vbNewLine
Printer.CurrentX = 1440
Printer.CurrentY = 1440
PrintListView lvwDataCopy
Printer.EndDoc
Private Sub PrintListView(lvw As ListView)
Const Margin = 60
Const COL_MARGIN = 240
Dim ymin As Single
Dim ymax As Single
Dim xmin As Single
Dim xmax As Single
Dim num_cols As Integer
Dim column_header As ColumnHeader
Dim list_item As ListItem
Dim i As Integer
Dim num_subitems As Integer
Dim col_wid() As Single
Dim X As Single
Dim y As Single
Dim line_hgt As Single
xmin = Printer.CurrentX
ymin = Printer.CurrentY
' ******************
' Get column widths.
num_cols = lvw.ColumnHeaders.Count
ReDim col_wid(1 To num_cols)
' Check the column headers.
For i = 1 To num_cols
col_wid(i) = _
Printer.TextWidth(lvw.ColumnHeaders(i).Text)
Next i
' Check the items.
num_subitems = num_cols - 1
For Each list_item In lvw.ListItems
' Check the item.
If col_wid(1) < Printer.TextWidth(list_item.Text) _
Then _
col_wid(1) = Printer.TextWidth(list_item.Text)
' Check the subitems.
For i = 1 To num_subitems
If col_wid(i + 1) < _
Printer.TextWidth(list_item.SubItems(i)) _
Then _
col_wid(i + 1) = _
Printer.TextWidth(list_item.SubItems(i))
Next i
Next list_item
' Add a column margin.
For i = 1 To num_cols
col_wid(i) = col_wid(i) + COL_MARGIN
Next i
' *************************
' Print the column headers.
Printer.CurrentY = ymin + Margin
Printer.CurrentX = xmin + Margin
X = xmin + Margin
For i = 1 To num_cols
Printer.CurrentX = X
Printer.Print FittedText( _
lvw.ColumnHeaders(i).Text, col_wid(i));
X = X + col_wid(i)
Next i
xmax = X + Margin
Printer.Print
line_hgt = Printer.TextHeight("X")
y = Printer.CurrentY + line_hgt / 2
Printer.Line (xmin, y)-(xmax, y)
y = y + line_hgt / 2
' Print the rows.
num_subitems = num_cols - 1
For Each list_item In lvw.ListItems
X = xmin + Margin
' Print the item.
Printer.CurrentX = X
Printer.CurrentY = y
Printer.Print FittedText( _
list_item.Text, col_wid(1));
X = X + col_wid(1)
' Print the subitems.
For i = 1 To num_subitems
Printer.CurrentX = X
Printer.Print FittedText( _
list_item.SubItems(i), col_wid(i + 1));
X = X + col_wid(i + 1)
Next i
y = y + line_hgt * 1.5
Next list_item
ymax = y
' Draw lines around it all.
Printer.Line (xmin, ymin)-(xmax, ymax), , B
X = xmin + Margin / 2
For i = 1 To num_cols - 1
X = X + col_wid(i)
Printer.Line (X, ymin)-(X, ymax)
Next i
End Sub
Print A Page Without My Print Button!!!
My question concern my web page:
How can i print an html page without it's print button.
I figure out how to hide the button when pressed(with layers)
but when it's finish printing or the user cancel,
how can i make the button visible,i know how but on
what event.
some1 have an idea??
Print Page That Contains Last Value
Hi,
I am using VB6 to access an excel document. What I want to do is find the last value of a range (a1:a100) and print only the page that the last value appears on.
Example:
Say the last value in that range is in cell a79, and a79 appears on the third page of the file, vb6 now only prints page 3 (which contains a79).
I hope that makes sense and that you are able to assist me.
Thanks again.
Daniel.
Page Set Up Before Print
Hi All,
Glad to be the member of this Forum.
Is it possible to make "Page 1 of ?" option as the default footer in Page Set up. That is every I shouldn't be selecting the option before printing.
Please help.
Thanx
Print A A4 Page
I have two fields in my database
They are :name and ID
The original layout is:
Name ID
Tom 1
Mike 2
Jack 3
Allan 4
I would like to print it like:
Name ID Name ID
Tom 1 Jack 3
Mike 2 Allan 4
anyone knows ? thank you !!! thank you !
Keep asking question until the end of the world....
Help Please With 2 Page Print Out.
Ok I am new to VB6 and I ran into a problem. When I print out a report from a text box the report ends up being 2 pages which it is suppose to be, but here is the problem. The first page prints out fine with a top margin of about 1/2 inch, but the second page looses the top margin data and prints the first line of the second page about 2 mm from the top of the page instead of 1/2 inch top margin.
I just want the second page to have the 1/2 top margin also what do I need to do?
here is my code so far.
Private Sub cmdPrint_Click()
'USE API TO PRINT
If (DisplayPrinter(txtReport.hWnd, centerForm:=True)) Then
Printer.ScaleLeft = -0.5 * 1440 'left margin
Printer.ScaleTop = -0.5 * 1440 'top margin
Printer.CurrentX = 0
Printer.CurrentY = 0
Printer.Font = "ARIAL"
Printer.FontSize = 12
Printer.Print txtReport.Text
Printer.EndDoc
MsgBox "Report has printed successfully."
End If
End Function
any suggestions or code would really be appriciated. Please make it as simple as possiable, since I am really new at vb6 thanks,
Print On New Page
Hello i have 2 questions, my first one is how do i print to my printer?
I think its something like Print.Printer but im not sure.
For my second question: i know that there is a code that when i add it it will print automaticly to a new page on my printer even when the page isnt full yet. I thought it was something like Chr12 to print on a new page but i forgot what it was. Hope anyone can help me out here.
Print New Page
I would like to know, How I can print the picture and put the picture in a new page after print the contents in the listview?
Code:
For i = 1 To ListView1(0).ListItems.Count
Printer.Print Tab(5); ListView1(0).ListItems(i); _
Tab(25); ListView1(0).ListItems(i).ListSubItems(1); _
Tab(45); ListView1(0).ListItems(i).ListSubItems(2); _
Tab(65); ListView1(0).ListItems(i).ListSubItems(3); _
Tab(85); ListView1(0).ListItems(i).ListSubItems(4); _
Tab(105); ListView1(0).ListItems(i).ListSubItems(5); _
Tab(125); ListView1(0).ListItems(i).ListSubItems(6); _
Tab(145); ListView1(0).ListItems(i).ListSubItems(7)
Next
Printer.Print "Legend": ForeColor = vbBlack
Set Picture2 = LoadPicture(App.path & "output.bmp")
Printer.PaintPicture Picture2, 60, 13000, 2000, 800
Printer.EndDoc
Print A Web Page
How to print a web page pogramatically from within Vbcode? (The web page should not appear on the screen ie. it should be loaded in background or in a web control)
Print 1st Page Of PDF
How do I Print the 1st page of a PDF? I currently use:
VB Code:
ShellExecute(hDesktop, "Print", "somefilename.pdf", vbNullString, "C:",0)
but it prints it all when I just want the first page.
thanks
---edit---
the program used Crystal Report Application server, so i just used the export feature to word and used the word application object to print page 1, but thanks for all of the interest.
Help. How To Print More Than 1 Page ?
Hi peeps, i have 2 probs.
Im new and have spent days on this forum learning all that i have learned so far.
THANKS ALL
After much searching i have finally found how to print the contents of my msflexgrid.
I have 2 problems that i am hoping your goodselfs can help with.
1. ) The data i have in the flexgrid is more than 1 page but can not get the rest to print. how can i get the printer to manually feed the next page and continue printing. ??
current code i am using is.
Private Sub Command5_Click()
Printer.ColorMode = vbPRCMMonochrome
Printer.PrintQuality = vbPRPQDraft
Printer.Orientation = vbPRORLandscape
Printer.PaintPicture Grid1.Picture, 0, 0
Printer.EndDoc
End Sub
2. ) Less inportant.
whilst printing the flexgrid, i would like to print in the background my logo so it is like a hologram. ?
Not sure if this can be done with the print command or if it can be included into the msflexgrid as a background image.
Hope you can help.
Thanks.
Print The Web Page
Working with the printer is a pain...
I had an idea to display what I wish to print as a web page in a hidden webbrowswer and the tell that webbrowser to print
webbrowser1.print
but there is not print method
there must be a way!
Print Fit To Page
Hi, I have an Access database and I've created a print button on one of my forms. When I click print it prints on 2 pages and I want to squeeze it onto 1 page. I can do this by adjusting the page setup but I want to do it in the visual basic code somehow so that all the users won't have to change their page setup. I've searched everywhere and can't find an answer to my problem, can someone please help?
Print From A Web Page
Hi,
I have a web site. I have a listing of all the word documents on the web site with a selection box for each. When I select some docs and click Print Button, I need to print all those docs onto a local printer ?
Can I use VB script for that ? If so, how ? Thanks for your help,
Cuteguy141.
How To Print At Last Page
hi......
can anyone please explain how to print the page footer only at the final page in data report (VB 6)
for example,
l've 3 page report n i only want the total of sales print at final page, Page 3 only.
TQ.....
Print First Page Of Doc
I need to change the printer settings in order to print the first page of a pdf file. Here is my print code, what can i do to make it print just the first page.
strPrinterName = Printer.DeviceName
strDriverName = Printer.DriverName
strPortName = Printer.Port
'Perform error checking
strCommandLine = "c:Program FilesAdobeAcrobat4.0 ReaderAcroRd32.exe /t """ + _
strfilename + """ """ + _
strPrinterName + """ """ + _
strDriverName + """ """ + _
strPortName + """"
RunProcess strCommandLine
thanks
JM
Print Web Page
Do u know: how to print a web page? To print it in text format (html codes) and graphic format(like we see in web browser). I have a hard time to figure it here. Could u help? Thanks!!!
Print Command In Vb6 To Print A Range In An Excel Worksheetsheet
Thank you for you assistance in populating an excel sheet from a vb6 user form textbox.
I am now struggling to print the excel sheet from vb6 command button.
I can print the worksheet but it is blank as I cannot work out how to set the print range.
Assistance would be appreciated as, after hours of trying, I am about ready to scream!!
Print Two Forms On One Page
How do I get two forms under the same project to print on a letter size page?
The print button is initialized from Form1 which collects the info. Form2 & 3 are formatted just for printing. This is all a standard exe file.
Any help would be apprciated.
Print Web Page Oddity
IE.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER, 0, 0
This works fine except it will print one extra blank page. When I change it to prompt the user only one page is printed. I removed the header and footer for both and they are the same webpage. Any ideas as to why not prompting the user would result in an extra blank page being printed?
Thanks,
Mark
Print Page Size Help
i am using printer.print
how do i tell the computer i want to print to Legal size????
Printer.PaperSize
but what is the answer for legal?
How To Print 2 Forms In One Page?
HI my problem is the following
I need to print one form and it´s duplicate in one page. I tried to copy and paste the entire form, but the size exceds the size permited by visual basic 6.
Thanks in advance
Webpage: Print To Fit One Page
Hi,
I have a program that loads a web page into a WebBrowser Control. I can print it fine using the following code:
Code:
wWeb.SetFocus
wWeb.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER, 0, 0
I would like to print the page to fit to one page. I have tried printer.ScaleWidth = 8.5, and tried various printer.zoom values, but nothing works. Does anybody have any ideas?
Ryan
Print Heading Every Page
Hi! I can print a heading only in my first page. How would I print the same heading in every page and how do i print page numbering Like "Page 1 of N". What should be added to my code?
VB Code:
Printer.FontName = "Courier New" Printer.FontSize = 11 Printer.Orientation = vbPRORPortrait Printer.CurrentY = 720 'Top Margin of .5" Printer.Print Tab(60); "Date Printed: "; Date Printer.Print Tab(60); "Served by: "; lblLoginName.Caption Printer.Print Tab(60); "Transaction ID: "; txtTransactionID.Text 'Printer.FontUnderline = True Printer.Print: Printer.Print Dim Pagelength%, BottomMargin%, TopMargin% Pagelength = 11 * 1440 BottomMargin = 1 * 1440 TopMargin = 0.5 * 1440 'Print headers If Printer.CurrentY > Pagelength - BottomMargin Then Printer.NewPage Printer.CurrentY = TopMargin End If
Print A Html Page
Hello, Iwas just wondering how to print a html page from within an app. I have created one from my app and now want to send it to the printer. Is ther any way of doing this.
How To Use PaintPicture To Print More Than One Page
I have a picBOx that has fairly large text documents being printed to it. I can view the entire pic box but when I send it to the printer it only prints out one page!?!?!?
Any ideas?
Also, what is the maximum height of a PicturBox?
Print Form Fit Exactly To A A4 Page
how do i print a form that can fit (or fill up the whole page) a A4 size page?..cuz when i print the form it prints only half the page ....
How To Print A Utf-8 Number To A ASP Page
I have a utf-8 unicode E999A2, which is a Chinese character. How can I print out this chinese character in a ASP page.
I can use "Response.Write(chr(&H41))" in my ASP VB script to print out "A" on the page. But couldn't figure out how to do the same thing to chinese characters which is utf-8 based unicode.
Print Full Page
I am having trouble printing a form from my program. When I print a form, it only prints what is above the fold. My forms are quite long (about twice the length of the screen) and I would like to print the entire form..not just what is above the fold. Can someone let me know if it is possible to print the full page of a long form.
Thanks,
Al
How Do I Print A Page That Is 8x11
OK here is the problem i am faced with, i need to put a 1040 ez form on to my form, but i need it to stay about its original size. That is not a problem for me to do. The problem is, when i print the form, it never prints the entire 1040ez. Is there a way for me to do this, well, I know there is a way i just don't know how to.
Can anyone please help me with this????
First Page Print For Web Browser
Hi, all
In order to make print out from internet web page, It is possible print out ONLY First page among 2 ~ 5 PAGE of WEB
In other word, If you link any internet web site. and If you try to print out that web site. I think that normallay, it will be printed out at least 2 ~ 5 pages from your printer for first page of internet web site which was linked by you.
That means there is no way to control page break ? because i really do not want to print out whole pages form first page of internet web site.
The following code is NOT able to break page which i want.
WebBrowser.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER, 0,0
Any idea ? Thanks you.
Print A Form On Page?
Hi there!
Does anyone know what kind of code I need to get a small, simple form to rpint out centered on a
standard 8X11 piece of papaer? I know how to use PrintForm, but I want to make it look nice, so
therefore centering it on the page would be desireable.
Thanks for your help!
How Can I Print Two Forms In The Same Page?
i did i report using a form and i have a loop to change the form, so i have to print many forms, but this forms are little and i want to print two forms in the same page, how can i do this?
i already tried to use:
form2.print
form3.print
printer.enddoc
but the vb6.0 is printring in different pages, in two pages.
i would like to know how use:
'printer.pagesize' how?
[Edited by gregorys_silva on 01-10-2001 at 12:41 PM]
|
TRACKER
