Excel Macro/VBA to Notes?

HCL Domino Domino Forum
1

I have been requested to write some kind of routine, using like VBA or whatever, that users can call when they are creating cell formulas in Excel. That function would reach out to Notes and grab the value stored somewhere in Notes, and place it into the Excel cell (the same way as you can create an Excel cell formula that refers to other cells in Excel).

I guess it would be a VBA thing. I guess too the first thing it would need to do is somehow allow the user to define what database and field in Notes that they want to link to.

Has anyone ever heard of anything like that ? Does anyone know any OTHER way of linking/synching Notes and Excel ? I could definitely write a JDBC agent or application that does it - the catch is that management is requiring that it be something that the users can call themselves, that when they want to pull values from Notes to appear in a spreadsheet, they don’t have to come to a programmer to get it done.

2

Subject: Excel Macro/VBA to Notes ?

It’s the reverse of figuring out how to convert a VBA macro to LS - do it in Notes, then figure out how to convert the code to VBA.

I think there’s an example in the Sandbox.

I did a quick search here and can’t find anything, but you may want to poke around the 4/5 forum.

Always good to look at OpenNTF as well.

I believe you can also ‘handle’ embedded sheets in Notes - again, code for that may be floating around (like in the FAQ of FAQs which you can access when you submit new entries via the ‘faq’ link).

You may also want to poke around the MS forums and see if there’s code available.

That should get you started. If you get something clever working, let me know and I’ll add it to the FAQ of FAQs.

Doug