if the workbook is already open no path information is requiredHow does excel know where the JPAPPDATA workbook is?
if you are using workbooks.open to add the .xls file to the workbook collection, full path is required
if the workbook is already open no path information is requiredHow does excel know where the JPAPPDATA workbook is?
if you are using workbooks.open to add the .xls file to the workbook collection, full path is required