Need for VBA Macro

[system]

Hi,

Almost exactly same question was post here:

120×120 10.4 KB

Hi All, I have a macro for settign a default value in the prompt while refreshing the report. But i dont have the macro for the same while opening the report. Could any body help out me for using the macro. The macro which i am using for setting the default value while refreshing is below. Private Sub Document_BeforeRefresh(Cancel As Boolean) Dim i As Integer For i = 1 To ActiveDocument.Variables.Count If ActiveDocument.Variables.Item(i).IsUserPrompt = True Then If ActiveDocument.Variables…

Please continue in the discussion only there.

This topic is now locked.

---

Marek Chladny (BOB member since 2003-11-27)