The tag has no usage guidance.

learn more… | top users | synonyms

4
votes
0answers
444 views

Implement FBP / Dataflow programming in VBA?

Intrigued by Flow Based Programming a la J Paul Morrison. I wonder if one can implement FBP in Excel/VBA. I searched quite a bit for a Basic-Lang FBP implementation to no avail. I've looked at some ...
3
votes
0answers
42 views

Is it OK to have a property of type COM object

I am developing a COM addin for Microsoft Excel, using VB.Net. I wrote a class to represent a worksheet that contains certain elements. Let's say for example it has a ListObject. I create a property ...
1
vote
0answers
2k views

Excel: Vba Copy and paste efficiency with 000's of rows and columns

I'm sure this is probably out there but I can't seem to find it. Updates I have tested some different code, and reduced my time to complete the task from 50/60 seconds to 10 seconds. This is what I ...
0
votes
0answers
25 views

What is needed server side in order to feed excel pivot users?

Our company has a lot of different business service "silos". They come with their client software, but they do not interop or offer cross domain searches. It is hard to compile the costs of a project ...
0
votes
0answers
130 views

Generating dual .xlsx files and .htm pages of the same data

Here are my requirements: Generate Excel reports for users, attaching them to emails Additionally, insert hyperlinks into those emails where the user can view the same report on a web page. I have ...
-3
votes
0answers
25 views

Making a Call to an API service to Test Service is Up

I would like to build a call to the CallCredit (used by, amongst others, UK Fin Services organizations to validate ID's) service to only test the service is up and running and responsive to 'real' ...