Category Archives: VBA

No Thumbnail

VBA Get Table Names in External Access Database (Automation)

In this article I will explain how you can get the names of all the tables in an external access database using VBA. The first step would be to connect to an external database. I’ve explained this in the article below: VBA, Open Access Database From

No Thumbnail

Excel VBA, Sheet Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Row: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples

No Thumbnail

File and Folder Dialoges VBA

You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.