|
If you can run an external command, you can often get away with running "start filename.ext" to get the shell to open it. i.e. Call Shell("start " & filename) (untested, I don't have access to windows machines) Although for future reference, there are alternatives if you need a little more freedom: Resolver One is a spreadsheet that uses python on .net internally: http://en.wikipedia.org/wiki/Resolver_One And if you're that way inclined, there are always libraries to interact with excel in other programming languages, even Haskell has one: http://alfa.di.uminho.pt/~jacome/HaExcel.html
|
# ¿ May 7, 2009 21:10 |
|
|
# ¿ Apr 28, 2024 12:08 |
|
If it's possible to create elegant works of art out of poop, then I'm sure you can make better code in vba. Learning the document model helps a lot - I have read VB&VBA in a nutshell, which is pretty useful and flawed at the same time. A good reference when you know what to look for. And I also have a copy of 'writing word macros'. I can't recall it being that useful. In the end cargo culting VBA code together works pretty well for the trivial tasks it can cope with
|
# ¿ Jul 13, 2009 12:06 |