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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com