We help IT Professionals succeed at work.

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

195 Views
Last Modified: 2017-05-08
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

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
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
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Thanks for the help!!!!!

I really need to change my IDE. would you recommend anything in the line of ECLIPSE?
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
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!