NACCAS Pre-Visit Survey

This is a guide to using the Pre-Visit Survey macro for NACCAS visits.
Per NACCAS this is to be ran and submitted no later than 7 days before the visit.


1.Open the NACCAS Visit Macro file (included below)
2.Run a query on the Student General Report using Is Active On: [1year prior to visit date] - [day you are running report]
3.Run a query on the SAP As Of report using the same criteria
4.Input AsOf [yesterday] in the top left corner and click View Report in the top right corner.
5.Export both reports to CSV
6.Click on View in Excel
7.Click on Macros (the upper half of the button)
8.Select NACCAS_PreVisit_Survey from the macro list (may also say 'NACCAS Visit Macro.xlsm'!NACCAS_PreVisit_Survey)
9.Click on Run
10.When saving the report, be sure to change the file type to Excel Workbook (either .xls or .xlsx)
Creation date: 11/18/2019 3:27 PM      Updated: 7/26/2024 1:24 PM
Files   
DataImage26.png
5.8 KB
DataImage26.png
21.3 KB
DataImage31.png
23.2 KB
DataImage32.png
40.3 KB
DataImage32.png
22.9 KB
DataImage45.png
12 KB
DataImage48.png
7.5 KB
DataImage48.png
3.6 KB
DataImage61.png
21.4 KB
DataImage61.png
11.8 KB
DataImage61.png
13.6 KB
DataImage67.png
48.2 KB
NACCAS Visit Macro.xlsm
35 KB