URL Creation for search and data find - Excel Macro

Hi

I am trying to develop a quick excel macro that will open a number of Windchill searches and pull certain data from each page.

Any tips on how to manipulate the URL to open a particular item in Windchill?

And then how to pull particular data once I get there?

ie...

What to find DocFun.

Type DocFun into excel.

Use macro to construct a URL something like: http://windchill.com/GoTo=DocFun

Once Im there pull one of the data fields for that doc back into Excel.

Thanks!

Sign up