personally, i would never use VBA for anything: there are better ways.   My own SAS/C#/PowerShell solutions are on github under https://github.com/savian-net   None of my EG add-ins are there at this time since it has not been checked against the latest EG. That said, it can help guide you in today's world since all of my code is written using .NET Core.    Chris has loads of examples out there as well as a very good book on it: https://www.amazon.com/Custom-Tasks-Enterprise-Guide-Microsoft-ebook/dp/B00AWSMT9K/ref=sr_1_1?crid=3KQRKG47RUVPQ&dchild=1&keywords=sas+enterprise+guide+custom+tasks&sprefix=SAS+Enterop%2Caps%2C190&sr=8-1     ... View more

Well, that puts you in a challenging place. ActiveX is dead so no need to pursue that path. MS Access and VBA are close to dead. I am not familiar enough with your needs to recommend an overall architecture. However...   Look at Microsoft PowerApps. That would probably be the best tech I can think of for what you are facing. Connect the data to a SAS dataset using the SAS OleDb/ODBC driver. Barring that, use something like Sqlite to house the data so it is standalone.   FYI, I am writing a SAS dataset to Sqlite converter right now but it won't be ready for primetime for a week or so. Once it looks good, I will put in on github.   You are welcome to reach out and ask questions. Unfortunately, you have an XY Problem that is hard to answer remotely.  ... View more

Are you sharing this out to other people or just for your own use? ... View more

First of all, do not use ActiveX. It is very old technology not supported anywhere except IE (pretty sure) so bad choice. IE, I think, is on the chopping block soon so it is dead as a browser.   3D pie chart is bad: 2 things (3d and pie) combined so poor choice of communicating percentages: See here: https://depictdatastudio.com/when-pie-charts-are-okay-seriously-guidelines-for-using-pie-and-donut-charts/   The question then becomes what to use in your Access form. I suggest using a png and just embed the image, if that is the question.    However, I think you asking how to solve an issue that should not exist. Ultimately, what are you trying to do? Provide some data dropdowns. let a user choose, then return a graph? If so, ActiveX is the wrong tech.   Sorry to be a downer but do not use ActiveX, 3D graphs, VBA. That puts you back to what and how. Give us more details and we help craft a directional solution. ... View more

Can I ask for clarification? You have a few technologies mentioned here and i am not sure the validity of each part. What are you trying to do?   VBA is the wrong tech and, perhaps, MS Access is as well. SAS/Graph may be as well but that is not as important. Describe what you are trying to do. You can always generate SAS/Graph code using text and then %include it into the solution. I would use C#, read the access db and then generate a png using one of the nuget packages. However, if you have this as part of the processing chain it may be different.   What version of Access would help as well. ... View more

In EG, can't you just do File ==> Export? Then have a SAS program run them one at a time using %includes?   %include 'file1'; %include 'file2'; %include 'file3';     ... View more