Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to link an Excel Workbook with a data base?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to link an Excel Workbook with a data base?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to link an Excel Workbook with a data base?
That is outside my area of expertise. Maybe someone who works on the web
frequently can give you an answer. "RyanH" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to link an Excel Workbook with a data base?
Hi I am vitz.
is there anybody knows how to querry data from *.aspx database using MS excel (ver. 2003)? Please help... Is there a need for a driver, if so, what is it? Thanks in advance.. "JLGWhiz" wrote: That is outside my area of expertise. Maybe someone who works on the web frequently can give you an answer. "RyanH" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel hyperlinks:files to link on several base paths | Excel Discussion (Misc queries) | |||
How do I link an Excel Data Base to a Visio Floor Plan? | Excel Discussion (Misc queries) | |||
I want to link my order form with my data base list | Excel Discussion (Misc queries) | |||
Excel Data Base Link | Excel Programming | |||
Data Base Link | Excel Discussion (Misc queries) |