coxonitus
04-27-2011, 11:18 AM
hi everybody
I'm using this code to save xlsm files in a folder.
' Opslaan_Als Macro
Dim SheetName As String
SheetName = InputBox(Prompt:="new filename:", _
Title:="name")
If SheetName = "" Then GoTo End
ActiveWorkbook.SaveAs "C:\Documents and Settings\xx\xx\2011\" & SheetName & ".xlsm"
ActiveWorkbook.Close
Exit Sub
End:
MsgBox "false not valid!", vbCritical, "Error"
End Sub
Is it possible when I want to print a file that exists in that folder, we can call it and then print??
The print will be called from a dashboard.
anybody?
I'm using this code to save xlsm files in a folder.
' Opslaan_Als Macro
Dim SheetName As String
SheetName = InputBox(Prompt:="new filename:", _
Title:="name")
If SheetName = "" Then GoTo End
ActiveWorkbook.SaveAs "C:\Documents and Settings\xx\xx\2011\" & SheetName & ".xlsm"
ActiveWorkbook.Close
Exit Sub
End:
MsgBox "false not valid!", vbCritical, "Error"
End Sub
Is it possible when I want to print a file that exists in that folder, we can call it and then print??
The print will be called from a dashboard.
anybody?