What I want to do is have the user input data into the spreadsheet. Then press a SAVE button on the sheet and have it do the following:
!. Check to make sure data exits in three of the cells and give error messgae if not.
2. Change to a different drive letter.
3. Once on that drive chnage to the correct directory using cells from the sheet.
4. Automatically create the file name to save it as based upon cells in the sheet.
I have tried the following with mixed (not everything works)results:
Please Login or Register to view this content.
Bookmarks