Hi Lisa,
Thanks for your response. The path variable is correct. That is my question as well. I did not create this script and the person who did no longer works here. But what I do not understand, is I can run the app in QV, and it runs without any errors.
Here is the full script, if that helps.
Sub UpdateQVD(xFile)
//*****************************************
//Based on file name, determine file type and define variables for incremental loading
//Assign File Type a Number for Switch Statement
Let xFileName = Subfield(SubField('$(xFile)','\',-1),'.',1);
Let xFileType = Match(Left('$(xFileName)',3),'CUW','Foc','Hit');
Let xPeriod = Right('$(xFileName)',6);
//Assign QVD name, Excel Document Prefix, Excel Sheet Name, and Period Suffix to file based on Type
Switch xFileType
Case 1 //Exceptions Summary
Set xQVD = 'ExceptionsSummary.qvd';
Set xExcel = '$(vExceptions)';
Set xSheet = '$(vExceptionsSheet)';
Case 2 //Policy Summary
Set xQVD = 'PolicySummary.qvd';
Set xExcel = '$(vPolicy)';
Set xSheet = '$(vPolicySheet)';
Case 3 //Hit Rate
Set xQVD = 'HitRate.qvd';
Set xExcel = '$(vHitRate)';
Set xSheet = '$(vHitRateSheet)';
EndSwitch
//*****************************************
//Incremental Load
If QvdCreateTime('$(vQVDPath)/$(xQVD)')
//OldData
Data:
Load * From "$(vQVDPath)/$(xQVD)" (qvd) WHERE Period <> '$(xPeriod)';
ENDIF
//NewData
Data:
Load '$(xPeriod)' as Period, *
FROM
"$(vFilePath)/$(xExcel)$(xPeriod).xlsx"
(ooxml, embedded labels, table is [$(xSheet)]);
//Store Data and Drop Table
Store * from Data into "$(vQVDPath)/$(xQVD)";
Drop Table Data;
ENDSUB
