View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Is it possible to link an Excel Workbook with a data base?

Sorry about the second question. This is what I had in mind. We currently
have a database that uses .net ( we can access the database from the
internet). I would like to figure out some way to set up a link on the data
base so when the user clicks the link the workbook along with all the macros
will be available to use.

Is something like this relatively easy or extremely complicated?

Thanks,
Ryan

"JLGWhiz" wrote:

This might get you started on the database question.

http://office.microsoft.com/en-us/ex...996671033.aspx

I don't understand the second question. Maybe if you stated the objective
it would help.

"RyanH" wrote:

I have two general questions. Sorry if this is vague!

1.) I have a Workbook with several macros that I use to calculate pricing
for our products. On the pricing sheet, I would like to access the database
so I can easily add customer information instead of cutting and pasting all
the time. Is this possible?

2.) Is it possible to open the same workbook with all the macros
operational with a link on a website?

Thanks in Advance,
Ryan