Access/Excel/Outlook/VBA/VSTO/SharePoint

J

jACK

I have a huge assignment and right now I am doing research. I need to
design basically a business tracking set of tools, either in Visual C+
+ or C# or Basic; or just Office with VBA. Basically we start a job,
and then when it is complete, I need to have it so someone can just
click a button and set a status, and then have email sent out to
responsible parties, and once they finish their analysis, they click a
button and metrics are auto generated. Metrics that display status
and turn around time.

It started as an Access database, the metrics were in excel. So the
way I thought it would work is set up a job in access, then set the
status, have access send out emails via outlook, with a button
embedded in the e-mail that can be click upon completion, that will
time stamp the completion send an e-mail back and update the excel
metric or the database, then have the database auto generate the
metric and charts. I thought the button would work kinda like how
Outlook accepts meeting invitations or how you can select between the
fish or chicken.

So I was looking into VBA, then I heard about VSTO, the new VBA and
SharePoint, SharePoint might be useful because people could interface
with the database and set up jobs and view the stage the job was in
without have Microsoft products via a web site. VSTO looks like it's
the future of VBA, but I have heard mostly negative things about it.

Please anyone offer insight to which way I should go with this, and
any references that will explain how to do the things I want to do
with Office and VBA or VSTO, I have looked at a lot of books and they
don't really get deep enough or specific enough into what I want to
do. I know a little about all these tools but not much about any of
them.

Thank you.
 
O

ODI

Hi Jack

The specification you list can be realized easily in Sharepoint with
InfoPath-Forms. The data entered will be stored in SQL-Server of SPS and
access rights are managed in sharepoint, you can even programm a workflow
using InfoPath and SharePoint Features. Try to consult e-learning site of
microsoft.. there are some good how-to-modules for self learning.

It's time to get the knowhow about those tools... The feature will use them
more and more! And it's really fun to programm quickly a shared workflow
plattform with those software..

Didem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top