G
Greg
Using the TransferSpreadsheet method, how do you import a
named range from an Excel spreadsheet? The code I have
so far is:
DoCmd.TransferSpreadsheet acImport,
acSpreadsheetTypeExcel9, "AccessTable
Name", "LocationofExcelFile", True, "Percent of Sales
Applied.Range(StatSample)"
with Percent of Sales being my Worksheet name and
StatSample being my Named Range in Excel.
named range from an Excel spreadsheet? The code I have
so far is:
DoCmd.TransferSpreadsheet acImport,
acSpreadsheetTypeExcel9, "AccessTable
Name", "LocationofExcelFile", True, "Percent of Sales
Applied.Range(StatSample)"
with Percent of Sales being my Worksheet name and
StatSample being my Named Range in Excel.