so how would one go about making the call to excel and launching that macro from within VB. how do you declare a new instance of an application from within my code? then how do i make it execute that macro once excel is loaded?
i have a project written in VB that creates a comma delimited text file and i was wondering if someone can help me create a function (a button_click action?) that will launch excel and read in the comma delimited file. any help with what this code might look like, or a good source for a tutorial on this would be greatly appreciated. I've looked around the W3 lessons on Vb and haven't found anything, but maybe i'm not looking in the right place. thanks!