| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
do anybody have a sample code for executing excel macro from vb code?<eom
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
do anybody have a sample code for executing excel macro from vb code?<eom
xlapp.run "macroname", any arguments [the ugly way]
or callbyname or wb.ws.yourProc if you post your vb code and vba routine and I'll do a full example Access is cleaner if your vba code is in classes either your own or behind the excel objects cheers Simon "B Deepak" wrote in message ... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
do anybody have a sample code for executing excel macro from vb code?<eom
Simon,
As such, I dont have any specific requirement. But for the time being, I have to define a macro with array as a argument. And this macro should be called from our vb class with array as a argument. Waiting for ur reply... Thanks, Deepak "Simon Murphy" wrote in message ... xlapp.run "macroname", any arguments [the ugly way] or callbyname or wb.ws.yourProc if you post your vb code and vba routine and I'll do a full example Access is cleaner if your vba code is in classes either your own or behind the excel objects cheers Simon "B Deepak" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code sample for executing a VB function in Excel using perl | Excel Worksheet Functions | |||
| VC7.1++ Excel add-in sample code? Visual Studio 2003 | Excel Programming | |||
| Blogs, sites, books, sample code, Excel+VBA+Finance | Excel Programming | |||
| Excel VBA code executing a variable as a Sub. | Excel Programming | |||
| Problems executing Excel VBA code in Microsoft Office 2003 | Excel Programming | |||
Linear Mode
