usage of ms/excell 3d maps in ms/access 2016

João serras-pereira
João serras-pereira used Ask the Experts™
on
Is there a way of invoking this excell set of capabilities from within ms/access 2016 in VBA? That would be great for my app
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
You can embed an Excel object into a form or report, and you could use those items. Here's an EE question that shows how:

https://www.experts-exchange.com/questions/27587733/How-to-embed-existing-Excel-worksheet-in-Access-form.html
Hi Scott -
I went through the documentation but, from what I could understand, it is a way of invoking a spreadsheet, and even a part of a sheet, bot not a  component as the 3d maps, using data that resides on a query (and a predefined map, of course), which is what I need,

Please let me know if I am wrong. If not, that I mus try to look for another option

joao
Most Valuable Expert 2012
Top Expert 2014
Commented:
If you're asking if you can use native Excel code/processes directly in your Access app, then the answer is no, you cannot do that. The best you can do is embed Excel as an OLE object, and control it from there. You could certainly export your data to the Excel workbook and have Excel build the 3D map based on that exported data.

But you cannot have the 3D map drawn directly in Access, using Access commands.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Thanks for the help!!!!!

I really need to change my IDE. would you recommend anything in the line of ECLIPSE?
Most Valuable Expert 2012
Top Expert 2014

Commented:
I don't know anything about Eclipse, so could not speak to that. If you're going to continue working with Access, however, you don't have any choice other than the Access environment. You cannot program Access outside of the Access environment.

Personally I find Visual Studio to be a great IDE. The Community Editions are free and are more than robust enough for the average one-man shop.
Ok. Thanks again!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial