Hi, can you set up Named Ranges in Easy Data Transform? I need the Named Ranges codes to input in access so I can link the file to both programs.
Thank you
Kim
Hi, can you set up Named Ranges in Easy Data Transform? I need the Named Ranges codes to input in access so I can link the file to both programs.
Thank you
Kim
We don’t have named ranges in Easy Data Transform. But, if you can tell me a bit more about what you are trying to do, there might be another way.
Hi, I will put this in steps
Here is the new part
I have an Access .mdb I’m editing as a way to personalize a Publisher newsletter.
However, I need the weekly sum to auto-update the Access file which updates the publisher newsletter. I will be using Access “Link to the data source by creating a linked table.” Unless I find a better way to link the sum directly into Publisher.
Everything works but setting up one sum cell in the xlsx spreadsheet to show Access (or Publisher) so it shows in publisher. I found I need a placeholder and read Named Ranges is how you do this.
Any advice
Thank you
Kim
So you want Easy Data Transform to create an .xlsx with a Named Range, so that you can integrate with Access/Publisher? Am I understanding that correctly?
Yes, I believe so. I think its only the name range. The instruction say to put the name range from excel into access or publisher.
I will add it to the wishlist. But I can’t make any promises about if and when it might get added. It depends partly on whether the 3rd party library we use to create Excel files supports it and also on whether we can any other requests for this.
Perfectly understandable. Have a great day.
Hello, Are you have news about creating a .xlsx with a Named Range?
It is on the wishlist. But you are only the 2nd person to ask for it, so it isn’t high on the wishlist at present. Perhaps you could tell us a bit more about why this would be useful.
We need to load the data to software that needs it as ODBC, so we must set a “TABLE” range