Dave Posted November 8, 2015 Report Share Posted November 8, 2015 Hello. I tried to save a template that had a chart(on a separate sheet) that was linked to the exported data. I saved the template in "C:\Program Files (x86)\Unitronics\Unitronics DataXport\Excel Templates" when the data export takes place, the file is created, but without the sheet with the chart. Is what I am trying to do even possible? It would be really helpful if it was. Quote Link to comment Share on other sites More sharing options...
MVP 2023 Joe Tauser Posted November 10, 2015 MVP 2023 Report Share Posted November 10, 2015 Data Export creates a whole new file every time. It is oblivious to your template. You'll need to create a macro to bring your data in to where you want it. Joe T. Quote Link to comment Share on other sites More sharing options...
Dave Posted November 13, 2015 Author Report Share Posted November 13, 2015 It is oblivious to your template. Joe T. That's exactly how it appeared when I was first attempting this., however, I downloaded the latest version of DataExport, and now it does indeed use my template. I was using version 3.1.9 and Excel 2013. I am now using 3.1.18. It works now with both .xlsx and .xls file formats, provided I have the appropriate extension(s) on my template(s). I have the data populating Sheet2 and my chart is on Sheet1, referencing the data area on Sheet2. When the client opens the file, they get a nice, fully coloured and documented chart of their cure cycle, with the back up data readily available for detailed review. Quote Link to comment Share on other sites More sharing options...
MVP 2023 Joe Tauser Posted November 16, 2015 MVP 2023 Report Share Posted November 16, 2015 That is good! It's obviously been a few months since I played with DataXport. You learn something new every day. Joe T. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.