Creating an Excel Database!
 

Thanks Tom,

It works! You wanted me to send you the original msg, which i am sending to
you! If possible, help me out on the remaining queries( 3 & 4).

Also, i hv a question for all, is it possible to create a database in Excel
using a data-entery worksheet, so that whatever is entered on the worksheet,
gets stored on a different workbook's worksheet which will be the Database!
I want to integrate the auto-generation of a unique no & also see to it that
sheet will validate that no duplicate entries r entered.

Actually, i hv made a Reimbursement Voucher which every Employee who wants
to get reimbursed for No-Transport-provided for a particular day(i.e
Pickup/Drop to/from Company).

They just hv to fill the (read-only) Voucher which will be located in a
particular folder on the network & then enter the dates to be reimbursed
along with a valid reason, e.g not Picked/Dropped up, had to catch a Cab,
Train, Auto etc & Amount.

The question is, whenever an employee fills in a Reimbursement voucher, i
want the Reimbursement Voucher to generate a unique Code (e.g RV00001) in a
cell labelled the RV# on the Reimbursement Voucher, so that employee can do
a Save-As filename & then also print-it. Now whatever he entered will be
automatically entered on a diff wrokbook's worksheet called say the
'Database'.

Is it Possible, bcos the file stored on the network will be a read-only
file?

Can i send you the file for your perusal? Pls reply so that i can get this
done at the earliest. Your help will really be appreciated.


Thanks & best regards,

Eijaz

================================================== ==========================
Dear all,

i hv few questions:
1) How to write a procedure to automatically create a no of sheets as the
no of days in a month with the sheet names as 01, 02, 03...31...etc.

2) how to write a procedure which will automatically create a sheet each
day, by concatenating the current date & a text such as "Comments", for the
Sheetname. e.g the Sheet names would be created as " Comments-10292003",
"Comments 10302003" etc for each current day....?

3) How to check whether a sheet has already been created & not create it by
the same name again, but just append data to it. tried Worksheet.Add method,
but it only adds addnl worksheets, not append to existing one.....

4) Made a Data Entry Template for transport reimbursement (voucher), which
is shared over a network. Is it possible to generate a Random Aplhanumeric#
for every user who fills in his reimbursement details( the details will
automatically be stored on a seperate excel workbook with the unique
aplhanumeric no along with the date when it was filled.

Can anybody help? any help would be really appreciated.

Thank & best rgds,

Eijaz

Creating an Excel Database!
 

I gave you the information you need for Questions 1 to 3.

--
Regards,
Tom Ogilvy

eijaz wrote in message
...
Thanks Tom,

It works! You wanted me to send you the original msg, which i am sending
to
you! If possible, help me out on the remaining queries( 3 & 4).

Also, i hv a question for all, is it possible to create a database in
Excel
using a data-entery worksheet, so that whatever is entered on the
worksheet,
gets stored on a different workbook's worksheet which will be the
Database!
I want to integrate the auto-generation of a unique no & also see to it
that
sheet will validate that no duplicate entries r entered.

Actually, i hv made a Reimbursement Voucher which every Employee who wants
to get reimbursed for No-Transport-provided for a particular day(i.e
Pickup/Drop to/from Company).

They just hv to fill the (read-only) Voucher which will be located in a
particular folder on the network & then enter the dates to be reimbursed
along with a valid reason, e.g not Picked/Dropped up, had to catch a Cab,
Train, Auto etc & Amount.

The question is, whenever an employee fills in a Reimbursement voucher, i
want the Reimbursement Voucher to generate a unique Code (e.g RV00001) in
a
cell labelled the RV# on the Reimbursement Voucher, so that employee can
do
a Save-As filename & then also print-it. Now whatever he entered will be
automatically entered on a diff wrokbook's worksheet called say the
'Database'.

Is it Possible, bcos the file stored on the network will be a read-only
file?

Can i send you the file for your perusal? Pls reply so that i can get this
done at the earliest. Your help will really be appreciated.


Thanks & best regards,

Eijaz


================================================== ==========================
Dear all,

i hv few questions:
1) How to write a procedure to automatically create a no of sheets as the
no of days in a month with the sheet names as 01, 02, 03...31...etc.

2) how to write a procedure which will automatically create a sheet each
day, by concatenating the current date & a text such as "Comments", for
the
Sheetname. e.g the Sheet names would be created as " Comments-10292003",
"Comments 10302003" etc for each current day....?

3) How to check whether a sheet has already been created & not create it
by
the same name again, but just append data to it. tried Worksheet.Add
method,
but it only adds addnl worksheets, not append to existing one.....

4) Made a Data Entry Template for transport reimbursement (voucher),
which
is shared over a network. Is it possible to generate a Random
Aplhanumeric#
for every user who fills in his reimbursement details( the details will
automatically be stored on a seperate excel workbook with the unique
aplhanumeric no along with the date when it was filled.

Can anybody help? any help would be really appreciated.

Thank & best rgds,

Eijaz

Creating an Excel Database!
 

Tom,

Can you pls Help me on the 4th one?

Best Rgds,

Eijaz



----- Original Message -----
From: "Tom Ogilvy"
Newsgroups: microsoft.public.excel.programming
Sent: Saturday, November 08, 2003 8:45 PM
Subject: Creating an Excel Database!


I gave you the information you need for Questions 1 to 3.

--
Regards,
Tom Ogilvy

eijaz wrote in message
...
Thanks Tom,

It works! You wanted me to send you the original msg, which i am sending
to
you! If possible, help me out on the remaining queries( 3 & 4).

Also, i hv a question for all, is it possible to create a database in
Excel
using a data-entery worksheet, so that whatever is entered on the
worksheet,
gets stored on a different workbook's worksheet which will be the
Database!
I want to integrate the auto-generation of a unique no & also see to it
that
sheet will validate that no duplicate entries r entered.

Actually, i hv made a Reimbursement Voucher which every Employee who wants
to get reimbursed for No-Transport-provided for a particular day(i.e
Pickup/Drop to/from Company).

They just hv to fill the (read-only) Voucher which will be located in a
particular folder on the network & then enter the dates to be reimbursed
along with a valid reason, e.g not Picked/Dropped up, had to catch a Cab,
Train, Auto etc & Amount.

The question is, whenever an employee fills in a Reimbursement voucher, i
want the Reimbursement Voucher to generate a unique Code (e.g RV00001) in
a
cell labelled the RV# on the Reimbursement Voucher, so that employee can
do
a Save-As filename & then also print-it. Now whatever he entered will be
automatically entered on a diff wrokbook's worksheet called say the
'Database'.

Is it Possible, bcos the file stored on the network will be a read-only
file?

Can i send you the file for your perusal? Pls reply so that i can get this
done at the earliest. Your help will really be appreciated.


Thanks & best regards,

Eijaz