J
JT
Currently, everything starts from Excel and I have hardcoded the file name
and path into Access.
When I kick off the macro in Excel, I create an Excel variable that contains
the file name and path. I then open an Access application and want to use
that Excel variable in the transfer spreadsheet command.
However, the variable is empty when it gets to Access.
My latest braindrizzle was to write the name and path in my Excel workbook
and then have Access pick it up before and create an Access variable before
it executes the transferspreadsheet command. But I'm not having much luck
with that plan either.
and path into Access.
When I kick off the macro in Excel, I create an Excel variable that contains
the file name and path. I then open an Access application and want to use
that Excel variable in the transfer spreadsheet command.
However, the variable is empty when it gets to Access.
My latest braindrizzle was to write the name and path in my Excel workbook
and then have Access pick it up before and create an Access variable before
it executes the transferspreadsheet command. But I'm not having much luck
with that plan either.