So the code i'm writing is using aliases, and lauching notepad, saving the file and i'm linking to an excel driver to give the name of the file. I know the code for lauching/save as is working.
But when I try to run it I get this error:
The Microsoft office access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.
Here is the line of code it has a problem with:
Set Driver = DDT.ExcelDriver("NotepadFileName","Sheet1",True)
I have my excel file saved in 97-2003 format, and is loaded under Stores/Files. I have also tried sending it to C:\ to look for the file. My sheet is named, "Sheet1". Not sure why it keeps giving me this error?