Forum Discussion
Need to export data to existing worksheet, not workbook
It would be possible to create a VBA routine which would move the exported data sheet to the destination file where you will work on it. You would need to create the code in your PERSONAL.XLSB (which means it is resident in Excel itself, rather than a specific workbook) which you could run once you have the exported workbook.
The whole idea is to not have to create the second workbook to begin with. I already have routines to copy the data from the exported workbook to my calculation workbook. Is there a way to change the "Save as" function to say a specific workbook and worksheet, vs just the name of a workbook? Right now my save as command says save my data to: ".../desktop/dailyreport.xls" Which completely overwrites this file every time. Is there a way to change this to say ".../desktop/dailyreport:worksheet1.xls" ?? and NOT have it completely overwrite the entire file, just the worksheet specified?
- lamplighterInn
This then becomes a question about your reservation software rather than Excel, which I am not able to answer with any authority, sorry. At a guess, I would say this would not be possible as you're essentially asking your reservation system to open / edit an existing workbook, and more to the point, it should know exactly what do in there.