I recently wrote code that automatically creates a new worksheet using
data from an account column in the excel database worksheet. The newly
created worksheet is used to store extra data about clients in the base
worksheet called "Database".

The database worksheet and "extra" worksheets are all contained in one
workbook.xls file, making portabilty of the document easy.

The database workshhet looks something like this

last first address city state zip phone account

By placing the cursor on a specific record and clicking on the create
supplement worksheet button, the new worksheet is created and it is
named using the account number from the appropriate column.

It all works fine until I try to write code to automatically call up
one of the created worksheets. I can not seem to get code written to
call up the worksheet based on the account number from the account
column.

Any guru's out there with an idea? Include your phone number if you
care to. I will call you on my nickel.

Paul Veilleux
Garland, Texas
972-278-2031:)
I am legally blind. Sometimes I prefer to talk than read.


--
PaulVeilleux
------------------------------------------------------------------------
PaulVeilleux's Profile: http://www.excelforum.com/member.php...o&userid=37899
View this thread: http://www.excelforum.com/showthread...hreadid=574338