Need help defining variables within the Chdir function
Posted by Travis on July 16, 2001 7:28 AM
I need help in writing a macro to open a file based off specific cell information.
Workbooks.Open Filename:= _
Example: I have a spreedsheet that has Molding in cell A1, Primary in A2, 06-Jun-pchart in A3. Cells A1-A3 will change each month. I need to open the file based off the information in these cells.
VB help is not doing me alot of good!!