I do hope you will enjoy some solutions, which you can find here.
You can find some code here, which was helpful to me during my daily work.
Some code was found in the internet and was fixed, improved or just modified by me.
If I know an author of code I will place '*' with information.
If you feel as an author of some code, don't hesitate to inform me - thank you.
Mateusz
1) Mass import csv or excel files
1) Scripting files from folder
2) Removing empty rows
1) Uploading file to FTP using WinSCP
2) Archiving files and folders using 7-Zip
Excel:
autofilter-with-saving-unique-values-into-new-excel-files
Pure VBA:
1) Filling table with given size with next numbers
2) Changing some data in the table, u must also give size of table
3) Copying data from Column 1 and paste it into table
4) Building two dimensions array
5) Building two dimensiona array which works as vlookup to send email to recipient
6) Loop Do ... Until ...
7) Loop For Each ... Next
8) Loop For ... Next
9) Loop Do While... Loop
10) Select Case
Word:
1) Merging to Individual Files
2) Merging to Individual Word Files, but single files will have names taken from datasource
3) Merging to Individual PDF Files, but single files will have names taken from datasource as well
1) Opening Access' database
2) Opening Excel file
3) Opening any applications by *.exe
4) Opening TXT file, if user_name is allowed
5) Opening Word file
6) Opening PDF file
Outlook sending template email:
1) Sending template of message by outlook
2) Sending template of messages by outlook to many Recipients using class
Outlook saving attachment to disk
1) Saving attachment to disk excluding *.png file
2) Saving attachment to disk excluding *.* any file types
Outlook moving items between folders
I. EXCEL
1) Changing format: text into value
2) Date can be convert into text
3) Saving activeWorkbook as "csv" with date stamp
4) Swifting workbooks
II. ACCESS
1) Transfering Table into excel file (it is NOT limited to 65k rows)
III. VBA
1) Deleting files and folders
2) Additional time to your computer to finish task from previous code. (Order to wait)
3) Declaration responsible for opening new window in maximum size
3a) Opening Internet Explorer Web Browser and navigation to http site (using declaration)
4) Opening folder
Access mass import csv or excel files
1) Mass import of excel files
2) Mass import of excel files picked from file.dialog
3) Mass import of text files
Excel scripting files from folder
1) Scripting files from given directory.
2) Scripting last modification date of single file to act with date rule
3) Scripting last modification date of files in folder with specific extension
1) Removing empty rows from worksheet
1) Uploading file to FTP using WinSCP
2) Downloading file from FTP using WinSCP