Is it possible to use an Excel addin from Access ?

[tsgiannis]

Well I know its a bit bizarre question but I am constantly stumbling on some interesting addins for Excel and I wanted to know if there is some way to use them via Access...possibly call it..feed it..do the math and return the results...even as raw data.

[June7]

The only Excel add-in I have is PowerQuery. I found VBA for manipulating PowerQuery but code is behind Excel workbook.

With Access VBA Excel automation to manipulate workbook, I expect the same code could be implemented.

[tsgiannis]

I guess this is the way but I was curious if we can directly talk to it...
I will check the automation...
If you can share some code about PowerQuery probably I will do the modifications to cover my needs

[Micron]

Not sure what additional features you're after but you can use Excel functions within Access code if you set a reference to Excel. It's not a simple matter of just pasting in the function formula as if you were doing so in a cell. I've found that you have to know its parent (which I believe is the worksheet) and its vba name. I have only done this 2 or 3 times. Look at the Excel object model for a start?

Office Object Model

[June7]

Google or Bing "vba automation powerquery"

Excel VBA command to run Power Query | MrExcel Message Board

Google or Bing "Access VBA Excel functions"

Excel Functions in Access - Microsoft Access / VBA (bytes.com)

[tsgiannis]

Google or Bing "vba automation powerquery"

Excel VBA command to run Power Query | MrExcel Message Board

Google or Bing "Access VBA Excel functions"

Excel Functions in Access - Microsoft Access / VBA (bytes.com)

I am familiar with the Excel object I just never worked with addins
Strange 1st result in searching :

fortunately Power Query doesn't support vba in any way

[pbaldy]

Post 6 was moderated, I'm posting to trigger email notifications.

[tsgiannis]

Please close the question...the author of the addin I was interested contacted me and offered me the source code...so no need for external manipulation

[June7]

Only way to 'close' is to mark Solved with Thread Tools dropdown above first post.