Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
print to a plotter cutter printer
72 views
Skip to first unread message
massimilian...@gmail.com
Nov 8, 2012, 3:24:58 AM11/8/12
to
Hello everybody,
i have a http://www.rolanddg.it/272-plotter-taglio-vinile.camm-1-gx-24-servo printer
this printer work with vectorial format.
There is a way with ms access to realize a report for this printer?
Otherwise is possible create from report a file .emf
thanks in advance
Massimiliano
i have a http://www.rolanddg.it/272-plotter-taglio-vinile.camm-1-gx-24-servo printer
this printer work with vectorial format.
There is a way with ms access to realize a report for this printer?
Otherwise is possible create from report a file .emf
thanks in advance
Massimiliano
David Hare-Scott
Nov 8, 2012, 8:23:55 PM11/8/12
to
material to it from a Windows app, eg Word? If this works then you should
be able to send stuff from Access.
David
massimilian...@gmail.com
Nov 14, 2012, 3:41:02 AM11/14/12
to
@David Hare-scott
there is windows driver, but the printer don't print correctly from word
in fact the printer cut , and accept only vectorial format
an example of vectorial format we can find on .emf files
there is windows driver, but the printer don't print correctly from word
in fact the printer cut , and accept only vectorial format
an example of vectorial format we can find on .emf files
Patrick Finucane
Nov 14, 2012, 6:18:02 AM11/14/12
to
If that doesn't help you might want to contact the vendor or maker of the plotter for some advice.
Patrick Finucane
Nov 14, 2012, 6:41:14 AM11/14/12
to
On Thursday, November 8, 2012 2:24:58 AM UTC-6, massimilian...@gmail.com wrote:
The Frog
Nov 14, 2012, 7:17:06 AM11/14/12
to
Which version of access? Up till 2003 the individual pages of an
access report are actually emf images. They can be extracted. I don't
know if you can use them with your printer, but it might be worth
exploring.
--
Cheers
The Frog
access report are actually emf images. They can be extracted. I don't
know if you can use them with your printer, but it might be worth
exploring.
--
Cheers
The Frog
massimilian...@gmail.com
Dec 4, 2012, 4:19:55 AM12/4/12
to
Thank you Patrick , but my printer is not a standard plotter
and the program used by the printer don't manage txt/csv
The Frog: is interesting your idea: which is the way you intended for extract report in emf image format ?
and the program used by the printer don't manage txt/csv
The Frog: is interesting your idea: which is the way you intended for extract report in emf image format ?
The Frog
Dec 4, 2012, 5:05:24 AM12/4/12
to
Basically the report is a compressed file with a series of emf
images. I wrote some code, based on anothers code, to pull out the
emf images and push them to PowerPoint. I'll see if I can find it and
maybe you can work with the extracted images.
--
Cheers
The Frog
images. I wrote some code, based on anothers code, to pull out the
emf images and push them to PowerPoint. I'll see if I can find it and
maybe you can work with the extracted images.
--
Cheers
The Frog
The Frog
Dec 17, 2012, 5:44:14 AM12/17/12
to
OK, I have found the code I was looking for. If you can produce a snapshot report file then this will extract the EMF images for you and dump them into powerpoint. I havent used this in a while as 2007+ dont seem to support these snapshot reports. This might be of some help to you..... place the code below into a .bas file (make a text file with the code in it and rename the .txt to .bas) then you can import it into Access from the VBA editor.
Cheers
The Frog
'______________________________________________________________________
Attribute VB_Name = "Push_PPT"
Option Compare Database
Option Explicit
Private Declare Function SetupDecompressOrCopyFile _
Lib "setupAPI" _
Alias "SetupDecompressOrCopyFileA" ( _
ByVal SourceFileName As String, _
ByVal TargetFileName As String, _
ByVal CompressionType As Integer) As Long
Private Declare Function GetTempPath _
Lib "kernel32" _
Alias "GetTempPathA" ( _
ByVal nBufferLength As Long, _
ByVal lpBuffer As String) As Long
Private Declare Function GetTempFileName _
Lib "kernel32" _
Alias "GetTempFileNameA" ( _
ByVal lpszPath As String, _
ByVal lpPrefixString As String, _
ByVal wUnique As Long, _
ByVal lpTempFileName As String) As Long
Private Declare Sub CopyMemory _
Lib "kernel32" _
Alias "RtlMoveMemory" ( _
Destination As Any, _
Source As Any, _
ByVal Length As Long)
Private Declare Function SetEnhMetaFileBits _
Lib "gdi32" ( _
ByVal cbBuffer As Long, _
lpData As Byte) As Long
Private Declare Function OpenClipboard _
Lib "user32" ( _
ByVal hWnd As Long) As Long
Private Declare Function CloseClipboard _
Lib "user32" () As Long
Private Declare Function GetClipboardData _
Lib "user32" ( _
ByVal wFormat As Long) As Long
Private Declare Function EmptyClipboard _
Lib "user32" () As Long
Private Declare Function SetClipboardData _
Lib "user32" ( _
ByVal wFormat As Long, _
ByVal hMem As Long) As Long
Private Const emfSIG = &H464D4520
Private Const emfVER = &H10000
Private Const emfCID = 14
Private Const ppLayoutBlank = 12
Private Const msoTrue = -1
Private Const ppPasteEnhancedMetafile = 2
Private Const ppViewSlide = 1
Private Const msoAlignCenters = 1
Private Const msoAlignMiddles = 4
Private Const msoFileDialogSaveAs = 2
Sub test_1()
Dim TempPath As String 'location of temp directory
Dim SnapFile As String 'the original snapshot
Dim DataFile As String 'the decompressed snapshot
Dim Length As Long 'return value for API calls
Dim Fnum As Long 'to hold freefile number for direct file access
Dim Flen As Long 'length of the file
Dim Fpos As Long 'position in the file
Dim Fsig As Long 'variable for holding EMF signature bytes
Dim Fver As Long 'variable for holding EMF version bytes
Dim Fbyt As Long 'variable for holding EMF byte length
Dim emfStart As Long 'variable for holding the start position of an EMF
Dim bArray(0 To 3) As Byte 'byte array for holding our retreived searches
Dim emfArray() As Byte 'byte array for holding the entire EMF image
Dim Pages As Long 'how many pages in the report
Dim i As Long 'general purpose variable
Dim z As Long 'general purpose variable
Dim h As Long 'memory handle value for clipboard goes here
Dim L As Integer 'for holding left margin value
Dim R As Integer 'right margin value
Dim T As Integer 'top margin value
Dim B As Integer 'bottom margin value
Dim ppApp As Object 'PowerPoint application object
Dim ppPrs As Object 'Powerpoint presentation object
Dim ppSld As Object 'Powerpoint slide object
Dim ppSdg As Object 'Powerpoint SaveAs dialog box
'L = Round(CCur(Left(GetOption("Left Margin"), Len(GetOption("Left Margin")) - 2)) * 100, 1)
'R = Round(CCur(Left(GetOption("Right Margin"), Len(GetOption("Right Margin")) - 2)) * 100, 1)
'T = Round(CCur(Left(GetOption("Top Margin"), Len(GetOption("Top Margin")) - 2)) * 100, 1)
'B = Round(CCur(Left(GetOption("Bottom Margin"), Len(GetOption("Bottom Margin")) - 2)) * 100, 1)
TempPath = Space(256) 'initialise string
Length = GetTempPath(256, TempPath) 'get the path and length
TempPath = Left(TempPath, Length) & Chr(0) 'cleanup the string (null terminated)
SnapFile = Space(256) 'initialise string
Length = GetTempFileName(TempPath, vbNullString, 0, SnapFile) 'get filename
SnapFile = Left(SnapFile, InStr(SnapFile, Chr(0)) - 1) 'cleanup filename
Call Kill(SnapFile) 'kill the temp file the process made
DataFile = Left(SnapFile, Len(SnapFile) - 3) & "emf" 'create the output filename for decompression
DoCmd.OutputTo acOutputReport, _
"Erfüllungsgrad Total nach Kunden", _
"SnapshotFormat(*.snp)", _
SnapFile 'produce the snapshot to SnapFile
SetupDecompressOrCopyFile SnapFile, DataFile, 0& 'decompress SnapFile to DataFile
Call Kill(SnapFile) 'SnapFile no longer needed
Fnum = FreeFile 'get a file access number
Open DataFile For Binary As Fnum 'open the file with the EMF's
Flen = LOF(Fnum) 'store how big the file is
Seek Fnum, Flen - 503 'total number of pages stored here
Get Fnum, , bArray 'get the 4 bytes starting at our position
CopyMemory Pages, bArray(0), 4 'place the bytes into a variable we can use
Seek Fnum, 1 'go back to the start of the file for searching
Fpos = 0 'set start value
Fsig = 0 'set start value
Fver = 0 'set start value
If Pages = 0 Then GoTo Shutdown 'Nothing to push to PowerPoint
Set ppApp = CreateObject("PowerPoint.Application") 'Create the PowerPoint app object we will manipulate
ppApp.Presentations.Add 'Add our presentation we will populate with slides
Set ppPrs = ppApp.Presentations.Item(1) 'Set a reference to our newly made empty presentation
ppApp.Visible = True 'This seems to only work as long as you can see the app
ppApp.ActiveWindow.ViewType = ppViewSlide 'and only if the view is set to this when visible!!! (weird)
For i = 1 To Pages 'for each report page we want an EMF
Do While Fpos < Flen 'do while file position is less than the length of the file
Get Fnum, , bArray 'read 4 bytes
CopyMemory Fsig, bArray(0), 4 'place into a usable variable
If Fsig = emfSIG Then 'compare the value against our EMF signature
Get Fnum, , bArray 'read the next 4 bytes
CopyMemory Fver, bArray(0), 4 'copy the version info to a variable
If Fver = emfVER Then 'check if the signatures match
Get Fnum, , bArray 'read the next 4 bytes
CopyMemory Fbyt, bArray(0), 4 'copy the length info to a variable
If i = 1 Then
emfStart = Fpos - 35 - 4 'EMF header block start position
Else
emfStart = Fpos - 40 - 4 'the first seems to have a different offset at the start
End If
Seek Fnum, emfStart 'move to the start of the emf
ReDim emfArray(Fbyt - 1) 'resize the array to hold the entire emf
Get Fnum, , emfArray 'read the emf into the array
h = SetEnhMetaFileBits(UBound(emfArray) + 1, emfArray(0)) 'get our handle to a memory metafile
If OpenClipboard(0&) <> 0 Then 'try and open the clipboard
Call EmptyClipboard 'clear out the clipboard
z = SetClipboardData(emfCID, h) 'push the emf to the clipboard
z = CloseClipboard 'close the clipboard leaving the data there
End If 'end of open clipboard if statement
Set ppSld = ppPrs.Slides.Add(i, ppLayoutBlank) 'create a new slide for each page
ppSld.Shapes.PasteSpecial(DataType:=ppPasteEnhancedMetafile).select 'paste the image to the slide from the clipboard
'With ppSld.Shapes(1) 'crop the image to remove the paper margins
' .PictureFormat.CropLeft = L 'and just keep the 'inside' of the report
' .PictureFormat.CropTop = T
' .PictureFormat.CropRight = r
' .PictureFormat.CropBottom = B
'End With
ppApp.ActiveWindow.Selection.ShapeRange.Align msoAlignCenters, True 'align the image to the centre
ppApp.ActiveWindow.Selection.ShapeRange.Align msoAlignMiddles, True 'align the middles (I forget which is horizontal and vertical)
End If 'end of emfVER IF statement
End If 'end of emfSIG IF statement
Fpos = Fpos + 4 'increment our position in the file
Loop 'end of Fpos to Flen loop
Next i 'end of Pages loop
Set ppSdg = ppApp.FileDialog(Type:=msoFileDialogSaveAs) 'let the user choose the save file
If ppSdg.Show = -1 Then ppPrs.saveas (ppSdg.SelectedItems(1)) 'save the presentation
Shutdown:
Close Fnum 'close the datafile
Call Kill(DataFile) 'DataFile no longer needed
Set ppSdg = Nothing 'release powerpoint object references
Set ppSld = Nothing
Set ppPrs = Nothing
ppApp.Quit 'and quit the app
Set ppApp = Nothing 'and release the app reference
End Sub
Cheers
The Frog
'______________________________________________________________________
Attribute VB_Name = "Push_PPT"
Option Compare Database
Option Explicit
Private Declare Function SetupDecompressOrCopyFile _
Lib "setupAPI" _
Alias "SetupDecompressOrCopyFileA" ( _
ByVal SourceFileName As String, _
ByVal TargetFileName As String, _
ByVal CompressionType As Integer) As Long
Private Declare Function GetTempPath _
Lib "kernel32" _
Alias "GetTempPathA" ( _
ByVal nBufferLength As Long, _
ByVal lpBuffer As String) As Long
Private Declare Function GetTempFileName _
Lib "kernel32" _
Alias "GetTempFileNameA" ( _
ByVal lpszPath As String, _
ByVal lpPrefixString As String, _
ByVal wUnique As Long, _
ByVal lpTempFileName As String) As Long
Private Declare Sub CopyMemory _
Lib "kernel32" _
Alias "RtlMoveMemory" ( _
Destination As Any, _
Source As Any, _
ByVal Length As Long)
Private Declare Function SetEnhMetaFileBits _
Lib "gdi32" ( _
ByVal cbBuffer As Long, _
lpData As Byte) As Long
Private Declare Function OpenClipboard _
Lib "user32" ( _
ByVal hWnd As Long) As Long
Private Declare Function CloseClipboard _
Lib "user32" () As Long
Private Declare Function GetClipboardData _
Lib "user32" ( _
ByVal wFormat As Long) As Long
Private Declare Function EmptyClipboard _
Lib "user32" () As Long
Private Declare Function SetClipboardData _
Lib "user32" ( _
ByVal wFormat As Long, _
ByVal hMem As Long) As Long
Private Const emfSIG = &H464D4520
Private Const emfVER = &H10000
Private Const emfCID = 14
Private Const ppLayoutBlank = 12
Private Const msoTrue = -1
Private Const ppPasteEnhancedMetafile = 2
Private Const ppViewSlide = 1
Private Const msoAlignCenters = 1
Private Const msoAlignMiddles = 4
Private Const msoFileDialogSaveAs = 2
Sub test_1()
Dim TempPath As String 'location of temp directory
Dim SnapFile As String 'the original snapshot
Dim DataFile As String 'the decompressed snapshot
Dim Length As Long 'return value for API calls
Dim Fnum As Long 'to hold freefile number for direct file access
Dim Flen As Long 'length of the file
Dim Fpos As Long 'position in the file
Dim Fsig As Long 'variable for holding EMF signature bytes
Dim Fver As Long 'variable for holding EMF version bytes
Dim Fbyt As Long 'variable for holding EMF byte length
Dim emfStart As Long 'variable for holding the start position of an EMF
Dim bArray(0 To 3) As Byte 'byte array for holding our retreived searches
Dim emfArray() As Byte 'byte array for holding the entire EMF image
Dim Pages As Long 'how many pages in the report
Dim i As Long 'general purpose variable
Dim z As Long 'general purpose variable
Dim h As Long 'memory handle value for clipboard goes here
Dim L As Integer 'for holding left margin value
Dim R As Integer 'right margin value
Dim T As Integer 'top margin value
Dim B As Integer 'bottom margin value
Dim ppApp As Object 'PowerPoint application object
Dim ppPrs As Object 'Powerpoint presentation object
Dim ppSld As Object 'Powerpoint slide object
Dim ppSdg As Object 'Powerpoint SaveAs dialog box
'L = Round(CCur(Left(GetOption("Left Margin"), Len(GetOption("Left Margin")) - 2)) * 100, 1)
'R = Round(CCur(Left(GetOption("Right Margin"), Len(GetOption("Right Margin")) - 2)) * 100, 1)
'T = Round(CCur(Left(GetOption("Top Margin"), Len(GetOption("Top Margin")) - 2)) * 100, 1)
'B = Round(CCur(Left(GetOption("Bottom Margin"), Len(GetOption("Bottom Margin")) - 2)) * 100, 1)
TempPath = Space(256) 'initialise string
Length = GetTempPath(256, TempPath) 'get the path and length
TempPath = Left(TempPath, Length) & Chr(0) 'cleanup the string (null terminated)
SnapFile = Space(256) 'initialise string
Length = GetTempFileName(TempPath, vbNullString, 0, SnapFile) 'get filename
SnapFile = Left(SnapFile, InStr(SnapFile, Chr(0)) - 1) 'cleanup filename
Call Kill(SnapFile) 'kill the temp file the process made
DataFile = Left(SnapFile, Len(SnapFile) - 3) & "emf" 'create the output filename for decompression
DoCmd.OutputTo acOutputReport, _
"Erfüllungsgrad Total nach Kunden", _
"SnapshotFormat(*.snp)", _
SnapFile 'produce the snapshot to SnapFile
SetupDecompressOrCopyFile SnapFile, DataFile, 0& 'decompress SnapFile to DataFile
Call Kill(SnapFile) 'SnapFile no longer needed
Fnum = FreeFile 'get a file access number
Open DataFile For Binary As Fnum 'open the file with the EMF's
Flen = LOF(Fnum) 'store how big the file is
Seek Fnum, Flen - 503 'total number of pages stored here
Get Fnum, , bArray 'get the 4 bytes starting at our position
CopyMemory Pages, bArray(0), 4 'place the bytes into a variable we can use
Seek Fnum, 1 'go back to the start of the file for searching
Fpos = 0 'set start value
Fsig = 0 'set start value
Fver = 0 'set start value
If Pages = 0 Then GoTo Shutdown 'Nothing to push to PowerPoint
Set ppApp = CreateObject("PowerPoint.Application") 'Create the PowerPoint app object we will manipulate
ppApp.Presentations.Add 'Add our presentation we will populate with slides
Set ppPrs = ppApp.Presentations.Item(1) 'Set a reference to our newly made empty presentation
ppApp.Visible = True 'This seems to only work as long as you can see the app
ppApp.ActiveWindow.ViewType = ppViewSlide 'and only if the view is set to this when visible!!! (weird)
For i = 1 To Pages 'for each report page we want an EMF
Do While Fpos < Flen 'do while file position is less than the length of the file
Get Fnum, , bArray 'read 4 bytes
CopyMemory Fsig, bArray(0), 4 'place into a usable variable
If Fsig = emfSIG Then 'compare the value against our EMF signature
Get Fnum, , bArray 'read the next 4 bytes
CopyMemory Fver, bArray(0), 4 'copy the version info to a variable
If Fver = emfVER Then 'check if the signatures match
Get Fnum, , bArray 'read the next 4 bytes
CopyMemory Fbyt, bArray(0), 4 'copy the length info to a variable
If i = 1 Then
emfStart = Fpos - 35 - 4 'EMF header block start position
Else
emfStart = Fpos - 40 - 4 'the first seems to have a different offset at the start
End If
Seek Fnum, emfStart 'move to the start of the emf
ReDim emfArray(Fbyt - 1) 'resize the array to hold the entire emf
Get Fnum, , emfArray 'read the emf into the array
h = SetEnhMetaFileBits(UBound(emfArray) + 1, emfArray(0)) 'get our handle to a memory metafile
If OpenClipboard(0&) <> 0 Then 'try and open the clipboard
Call EmptyClipboard 'clear out the clipboard
z = SetClipboardData(emfCID, h) 'push the emf to the clipboard
z = CloseClipboard 'close the clipboard leaving the data there
End If 'end of open clipboard if statement
Set ppSld = ppPrs.Slides.Add(i, ppLayoutBlank) 'create a new slide for each page
ppSld.Shapes.PasteSpecial(DataType:=ppPasteEnhancedMetafile).select 'paste the image to the slide from the clipboard
'With ppSld.Shapes(1) 'crop the image to remove the paper margins
' .PictureFormat.CropLeft = L 'and just keep the 'inside' of the report
' .PictureFormat.CropTop = T
' .PictureFormat.CropRight = r
' .PictureFormat.CropBottom = B
'End With
ppApp.ActiveWindow.Selection.ShapeRange.Align msoAlignCenters, True 'align the image to the centre
ppApp.ActiveWindow.Selection.ShapeRange.Align msoAlignMiddles, True 'align the middles (I forget which is horizontal and vertical)
End If 'end of emfVER IF statement
End If 'end of emfSIG IF statement
Fpos = Fpos + 4 'increment our position in the file
Loop 'end of Fpos to Flen loop
Next i 'end of Pages loop
Set ppSdg = ppApp.FileDialog(Type:=msoFileDialogSaveAs) 'let the user choose the save file
If ppSdg.Show = -1 Then ppPrs.saveas (ppSdg.SelectedItems(1)) 'save the presentation
Shutdown:
Close Fnum 'close the datafile
Call Kill(DataFile) 'DataFile no longer needed
Set ppSdg = Nothing 'release powerpoint object references
Set ppSld = Nothing
Set ppPrs = Nothing
ppApp.Quit 'and quit the app
Set ppApp = Nothing 'and release the app reference
End Sub
0 new messages