Timeline for Calling MS Excel function from MS Access VBA
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 22, 2015 at 14:02 | vote | accept | Nishith | ||
| Jun 19, 2015 at 8:33 | comment | added | Coder375 | Sprinkle some, debug.print "x" & time, lines into your code to see which part exactly is taking the longest time... you can take it from there. | |
| Jun 18, 2015 at 12:12 | answer | added | Gustav | timeline score: 1 | |
| Jun 18, 2015 at 11:43 | answer | added | AnalystCave.com | timeline score: 2 | |
| Jun 18, 2015 at 10:57 | comment | added | Rory | Hard to say - I would never use an implicit reference like that. You should create your own instance and use that, or write/find your own BetaDist function. | |
| Jun 18, 2015 at 10:23 | comment | added | Nishith | Yes. But will it start and close excel for every iteration? | |
| Jun 18, 2015 at 10:17 | comment | added | Rory | Your code has to start Excel which is probably why it takes so long. You'll also be left with an orphaned excel.exe process running doing it that way. | |
| Jun 18, 2015 at 10:15 | history | asked | Nishith | CC BY-SA 3.0 |