itechxxiv
12-09-2005, 10:36 AM
.:Here?s the Scenario:.
I have an Excel worksheet that use at workbook to track the progress of software development documentation from 10 different development teams. Our company uses a ?Document Management? product (Internet Application) from IBM. It?s called ?Ascendant?. Anyway, is there any way I can connect/link/update my spreadsheet through Excel itself.
Perhaps a click of a button would initiate a query, connection, link something like that?
I have experimented with ?Web Query? with no luck or I am not entering the Correct parameters. I just simply do not enough even to troubleshoot a solution.http://vbaexpress.com/forum/images/smilies/102.gif
~>Things you should know:_
-() You access the Ascendant (Doc manage system) through a Browser (IE, NetScape, etc)
https://www2.ascendanterp.ihost.com/ (https://www2.ascendanterp.ihost.com/)
I have attached a Excel file with screen shots and detailed information that will provide you with all the parameters.
Thanks itechxxiv
I have an Excel worksheet that use at workbook to track the progress of software development documentation from 10 different development teams. Our company uses a ?Document Management? product (Internet Application) from IBM. It?s called ?Ascendant?. Anyway, is there any way I can connect/link/update my spreadsheet through Excel itself.
Perhaps a click of a button would initiate a query, connection, link something like that?
I have experimented with ?Web Query? with no luck or I am not entering the Correct parameters. I just simply do not enough even to troubleshoot a solution.http://vbaexpress.com/forum/images/smilies/102.gif
~>Things you should know:_
-() You access the Ascendant (Doc manage system) through a Browser (IE, NetScape, etc)
https://www2.ascendanterp.ihost.com/ (https://www2.ascendanterp.ihost.com/)
I have attached a Excel file with screen shots and detailed information that will provide you with all the parameters.
Thanks itechxxiv