Forum Discussion
Need to export data to existing worksheet, not workbook
I have setup a system to export a report from our reservation system to an Excel workbook so I can then do some calculations on the data and format a new report. The thing is that I have to then c...
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.
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.