Using VBA how do I create an Access Database from Excel?

[Mohamed C]

I want to be able to create an access database from Excel without having to open access. How do I do this with code. I know that this can be done with Excels add-in "Template Wizard with Data Tracking" but I want to achieve this in VBA code.

Please help.

 

[anvil19]

Hi Mohamed

I refer to a similar post that I answered a while ago.

http://www.mrexcel.com/board2/viewtopic.php?t=95345

Any help?

anvil19