petroj02
10-20-2016, 05:04 AM
Hello all,
I have again a question about something and because I am sure you can help me there is my post.
I am working about sending automatic emails with pdf attachments converted from new Excel list, which is generated after some Kind of configuration... The configuration gives me basically sort of numbers and These numbers allways have to start with Zero and then follow six others numbers. These numbers are saved at original workbook at row with my own Format 0000000.
I know how to Change Format of row from General to my own 0000000 Format) in Excel, but I dont know the Syntax how to do that with vba since,I am able to convert sort of numbers from original to new workbook, but Zero as first Digit is hidden.
I have again a question about something and because I am sure you can help me there is my post.
I am working about sending automatic emails with pdf attachments converted from new Excel list, which is generated after some Kind of configuration... The configuration gives me basically sort of numbers and These numbers allways have to start with Zero and then follow six others numbers. These numbers are saved at original workbook at row with my own Format 0000000.
I know how to Change Format of row from General to my own 0000000 Format) in Excel, but I dont know the Syntax how to do that with vba since,I am able to convert sort of numbers from original to new workbook, but Zero as first Digit is hidden.