Test post

[KEDENNIS]

Every post I make is being block by a firewall that says i'm trying to injecting SQL.....
So i'm trying a different script as a test....

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Mine was doing that yesterday. But I also received messages stating I was posting HTML when in fact I was just posting a simple formula in formula tags.

BSB

[Pete_UK]

It tends to happen if you use the less than symbol (< ) with something immediately after it. Seems to work okay if you put a space immediately after it, though.

Hope this helps.

Pete

[KEDENNIS]

Sub PDF_SAVE()
Dim ws As Worksheet
Dim strPath As String
Dim myFile As Variant
Dim strFile As String
On Error GoTo errHandler


'CODE DELETED FROM HERE


If myFile <> "False" Then
ws.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=myFile, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False

MsgBox "PDF file has been created."
End If

exitHandler:
Exit Sub
errHandler:
MsgBox "Could not create PDF file"
Resume exitHandler
End Sub

[KEDENNIS]

Please Login or Register  to view this content.

[KEDENNIS]

Please Login or Register  to view this content.