Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
karram
in reply to: A.Acheson

Herewith attached code below.

'Save Excel files as current folder patch
oPath = ThisDoc.Path
oFolder = oPath
If Not System.IO.Directory.Exists(oFolder) Then
    System.IO.Directory.CreateDirectory(oFolder)
End If

myXLS_File = oFolder & "\" & xlDocID & ".xls"
xlWB.SaveAs(myXLS_File) = True
GoExcel.DisplayAlerts = True
myXLS_File.close