Sorry in advance if I'm just being blind but It all looked like it was creating a new .xls and copying data from the db into it. I want to open an .xls file that has nothing to do with the db?
I did see something in one of the codes that might help:
If I put this into some vb could it work? How would I write the 'BookName'?
Myexcel.xls or would I have to put the whole file path into it?
I would like to have a button on a form to open an Excel spreadsheet. I can make a button that opens a blank spreadsheet, but I'd like the button to open a specific excel spreadsheet.
Any help would be great.
Not sure if this gets you exactly what you want but what I did in one of my databases is in DesignView, right click on the button, click on Properties. Then on the FormatTab click inside Hyperlink Address and just map it to where that form is. I'm sure there are more elaborate ways, but this got the sheet that I needed.