TheAceMan1
Programmer
Howdy All,
Office 2003
Need to pass a value from Access to Excel (VBA preferred). The value tells excel which files in 1 of 2 folders to process. I had the idea of a custom environment variable but would perfer a more up to date method.
In this scenario Access opens an Excel file that does most of the processing.
Your Thoughts? ...
See Ya . . .
Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!
Office 2003
Need to pass a value from Access to Excel (VBA preferred). The value tells excel which files in 1 of 2 folders to process. I had the idea of a custom environment variable but would perfer a more up to date method.
In this scenario Access opens an Excel file that does most of the processing.
Your Thoughts? ...
See Ya . . .
Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!