VBA Site contains VBA code to create macros in WORD EXCEL ACCESS OUTLOOK

 

Welcome to my site.

Dear Reader!

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

 

List of content:

 

I. Access:

1) Mass import csv or excel files

II. Excel:

1) Scripting files from folder

2) Removing empty rows

III. VBA:

1) Uploading file to FTP using WinSCP

2) Archiving files and folders using 7-Zip

 

 

Excel:

excel-send-muliple-emails

autofilter-with-saving-unique-values-into-new-excel-files

 

 

Pure VBA:

vba-order-to-wait

vba-loop-examples-and-arrays

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:

word-mail-merge

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

 

 

 

 

 

 

VBA: Opening applications

Vba opens Access or Excel

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

 

Msofiledialogtype:

Msofiledialogtype

 

Outlook: Sending template email:

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:

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:

Outlook moving items between folders

 

Array Sort:

Array sort

 

Useful code:

Some useful code

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

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

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

 

Excel: Removing empty rows

Excel remove empty rows

1) Removing empty rows from worksheet

 

VBA: FTP file transfer

Ftp file transfer

1) Uploading file to FTP using WinSCP

2) Downloading file from FTP using WinSCP

 

VBA: Archiving files and folders using 7-Zip

Vba zip files and folders

 

Collections

Collections

 

Kontakt






Wyślij wiadomość


1

liczba odwiedzających
© 2013-2024 PRV.pl
Strona została stworzona kreatorem stron w serwisie PRV.pl