Hi all,
I am new with VBA and have a problem to insert a longer text.
The next problem is, when in the folder is no file, the VBA stopp.
Could anyone help me, please?
Kind regards,
Thorsten
http://speedy.sh/tcty3/VBA.docx
Hi all,
I am new with VBA and have a problem to insert a longer text.
The next problem is, when in the folder is no file, the VBA stopp.
Could anyone help me, please?
Kind regards,
Thorsten
http://speedy.sh/tcty3/VBA.docx
Hi Thorsten,
I'm not clear on what you need for your first question & it would help if your file was in Excel format so I can see what you're working with.
For your second question, you can add an If statement that moves to the next folder where there is a file if a file isn't found in the folder.
Can you upload an Excel file & a before & after example of what you need?
Thanks
Remember you are unique, like everyone else
Hi,
thank you for your help. I have uploaded an Excel File.
1. I have to insert one textmodul (see my example in red) choosen from 2 templates in this VBA Code for an E-Mail. Or better to create two separate text files and insert from the different files (text1 ord text2).
2. Normaly I have to attach a file to this E-Mail. But if there is no file in the folder, display E-Mail without attachment.
I hope it is clear for you what I mean?
The excel file you can find here: http://speedy.sh/DsUHu/testVBA-mail.xlsm
Kind regards,
Thorsten
Hi,
thank you for your help. I have uploaded an Excel File.
1. I have to insert one textmodul (see my example in red) choosen from 2 templates in this VBA Code for an E-Mail. Or better to create two separate text files and insert from the different files (text1 ord text2).
2. Normaly I have to attach a file to this E-Mail. But if there is no file in the folder, display E-Mail without attachment.
I hope it is clear for you what I mean?
The excel file you can find here: http://speedy.sh/DsUHu/testVBA-mail.xlsm
Kind regards,
Thorsten
Hi,
thank you for your help. I have uploaded an Excel File.
1. I have to insert one textmodul (see my example in red) choosen from 2 templates in this VBA Code for an E-Mail. Or better to create two separate text files and insert from the different files (text1 ord text2).
2. Normaly I have to attach a file to this E-Mail. But if there is no file in the folder, display E-Mail without attachment.
I hope it is clear for you what I mean?
The excel file you can find here: http://speedy.sh/DsUHu/testVBA-mail.xlsm
Kind regards,
Thorsten
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks