' PDF-Datei ins Webspace versenden
Dim iBox As String
iBox = MsgBox("Soll die PDF-Datei gleich ins WEB versendet werden?", vbYesNo + vbQuestion, "PDF-VERSAND")
If iBox = vbYes Then
Shell ("U:\BAT\FILFTP.EXE @U:\BAT\GE_S-FTP.cfg")
Else
' abspeichern als Vorlage und beenden
Dim sBook As Workbook
ActiveWorkbook.SaveAs Filename:="U:\GROSSER\Preislisten\Monacor_last-pdfconvert.xls", _
FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
For Each sBook In Workbooks
If (sBook.Name <> ActiveWorkbook.Name) And (sBook.Name <> ThisWorkbook.Name) Then
sBook.Close savechanges:=False
End If
Next sBook
End If
Dim WshShell As Object
Set WshShell = CreateObject("Wscript.Shell")
WshShell.Run "C:\windows\notepad.exe", 1
Ergänzung zu VBA Code
DOMMEl 04.10.2009 - 322 Hits - 22 Antworten
VBA Code / Makro
DOMMEl 08.10.2009 - 185 Hits - 3 Antworten
VBA Code Ergänzung
DOMMEl 16.10.2009 - 372 Hits - 36 Antworten
Checkbox VBA Code?
BenjaminM 14.04.2010 - 369 Hits - 12 Antworten