Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have an Excel spread sheet that contains macros and links. I was told the macros defined the relationships of cells. The person who created the spread sheet has left the company, and our users are afraid to do anything with the spread sheet because no one really knows all the details in the spread sheet. Also, the data that they have is hitting the Excel maximum limit, so we need to extract out the data and put them into a relational database. Is there a way that we can extract, not just the data, but all the relationships defined in the macros and links, to create any relational database (Access, MS SQL Server, Sybase, Oracle, etc.)? By the way, we are using Excel 2000 (9.07616 SP-3). Thanks.
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Someone is going to have to go through those macros to
determine the relationships, if thats the case. If no one has that ability you will probably require the services of an excel vba consultant, whom can be found on the web. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i convert digists in to characters in a spread sheet | Excel Worksheet Functions | |||
convert excel spread sheet into txt.cvs document | Excel Discussion (Misc queries) | |||
Convert info from database to spread sheet | Excel Discussion (Misc queries) | |||
convert spread sheet to pdf | Excel Discussion (Misc queries) | |||
HOW TO CONVERT EUROS TO SWISS FRANCS IN A EXCEL SPREAD SHEET | Excel Worksheet Functions |