Macro

[system]

Hi All,

Earlier I could get the macro code to run against the reports stored locally in a folder to get the list of objects in a data provider

120×120 10.4 KB

Author: Dwayne Hoffpauir, EDS The attached utility will record objects that are used in a series of reports. Usage is as follows: [quote:61cb8b7957=“Author’s notes”]- Create a temporary directory. Place all documents (.rep files) to be analyzed in that directory. Place this document in that same directory. Open this document, and refresh. Each document in the directory will be opened, and data provider objects recorded. There will be a lot of screen flashing as the documents are opened and…

But now instead of local the macro should go against the corporate douments and retrieve the same info as it did for local documents.

My question is where I should put the following code in the macro to get the desired result.

Application.ExchangeMode = boRepositoryMode
Call Application.Documents.Receive(RepFile, PathName)
Set Doc = Application.Documents.Open(PathName & RepFile)

Again I am newbie to VB so when tried to modify it is breaking:(,Please help me in acheiving it.

Thanks in advance
Vinni

---

sgummadi (BOB member since 2007-01-31)