How to use VB or VBA in auto cad

[BudMan38]

The company that I work for uses old Paradox script to access the files in our Auto cad data base. The problem with that is it only opens one sheet at a time, so each time I want to open a different sheet then I need to run the Paradox routine again. If I bypass this and just use the Autocad open the sheets, when saved some of the data like revision and so on will be miplaced and when someone trys to run the paradox routine an error occurs.
I was wondering if something like this is possible:

The dir structure is like this.
F:\eng\ 435671 (The first sheet of the drawing).

The second sheet of the drawing is placed in a sub dir of eng like F:\eng\Sheet2\435671(The second sheet of the drawing).

The drawing number is the same the sheet is placed into the corresponding dir name sheet2, sheet3 and so on.
Only the first sheet is placed in the main dir of eng.

What I would like to happen is.

The first page of the drawing would be opened using the Paradox routine and somewhere maybe on a toolbar an icon is loaded that would activate the routine when clicked.

Once the routine is open a text box would display the drawing number that is open.
The second text box would show the sheet number that is open.

Drawing number
[435671] (textbox)

Sheet Number
[1 ]

If I change the sheet number it would automatically open sheet
[2 ].(textbox)

Thanks for any help
Budman38