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

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
João serras-pereiraAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
0
João serras-pereiraAuthor Commented:
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
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

João serras-pereiraAuthor Commented:
Thanks for the help!!!!!

I really need to change my IDE. would you recommend anything in the line of ECLIPSE?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
João serras-pereiraAuthor Commented:
Ok. Thanks again!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.