Instructions to download and install the QDB GL/PPP FPM AD HOC Reporting

 

Note: Images on your pc might not look like the following images. Steps should be the same.

 

Downloading the Program

Close Excel

Click QDBGPFPM.exe

You will get a download screen. The following screen is a sample:

 

 

 

Click the Run/Open button. The unzip screen will be displayed.

 

 

 

Click the Unzip button. You will be prompted for a password.

Call Alan Illescas at 40775 if you do not know the password.

When the download is completed, click the Close button.

 

Accessing the Program

For Excel 2000-2003

For Excel 2007

Click Tools

Click Add-ins

Click Browse  (go to c:\qdb)

Select QDBGPFPM.xla

Click OK (or open)

Click OK

Click Open  (go to c:\qdb)

Select QDBGPFPM.xla

Click Open

 

Running the Program

For Excel 2000-2003

For Excel 2007

To run each report,

Click Tools

Click GL/PPP FPM AD HOC Reporting

Enter your QDB login id and and password

To run each report,

Click Add-ins

Click GL/PPP FPM AD HOC Reporting

Enter your QDB login id and and password

 

 

Security If you get a message like "Cannot Find..." message, do these:

For Excel 2000-2003

For Excel 2007

Click tools

Click Marco

Click Security

 

 

If Security Level is high, try a lower setting and press OK.

Run the program again.

You might need to close and open your Excel.

 

If you check the Medium Security, Excel will ask you if you want to enable macros.

You need to say YES.

Click Developer

Click Macro Security

Modify the Macro Settings or the Trusted Location

 

 

(You might need help from your IT)