CC sectionĭim icounter As Long 'counter for the column letter in "Clients Database" to fill the. Xĭim x As Long 'counter for the date contained in column B row xĭim d As Long 'counter for the row number in "Clients Database" to fill the. 'Dim signaturefile As String: signaturefile = "C:\Users\browngil\AppData\Roaming\Microsoft\Signatures\X_files\image001.png"ĭim Backupfile As String: Backupfile = "V:\Admin Factures\FACTURES X " & Year(Date) & "\Transport\Factures X Transport\"ĭim BOUCI As Range 'BOUCI.value is the invoice number i.e. 'Dim signaturefile As String: signaturefile = strFilename & "X_files\" & Dir(Environ("appdata") & "\Microsoft\Signatures\*.png") ''Using DIR function to be able to use wildcards to match the htm signature file so any user can get their own signature on the emails generatedĭim signaturefile As String: signaturefile = strFilename & Dir(Environ("appdata") & "\Microsoft\Signatures\*.htm") Dim strFilename As String: strFilename = Environ("appdata") & "\Microsoft\Signatures\"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |