Is it possible to call a vba macro from visual basic?

[lbrooks]

I have created an application that imports an excel file to create individual word documents for each entry and then is suppose to save each word document as a PDF. The problem is that the Adobe Acrobat PDFMaker function for Visual Basic seems to be unstable, but the VBA function works. So I would like to call the VBA function from Visual Basic. Is this possible. If not, any suggestions?

 

[HANSGIELEN]

Hi there,

as far as I understand you want to programmatically start
an excel macro from your code. Maybe this is helpful:

Create an excel file named e.g. "C:\Progs\MyCode.Xls"
Record or write the code necessary to perform the required operations in a Public Sub in any VBA module:

Public Sub MySub
Msgbox "Running"
... your code here
End Sub

In your code, launch excel, load the file and start the Sub:

Dim Excel as Object
Set Excel = CreateObject("Excel.Application&quot
Excel.Workbooks.Open "C:\Progs\MyCode.XLS", 0
Excel.Application.Run ("MyCode.XLS!MySub&quot
Excel.Application.Quit
Set Excel = Nothing

This should work in all Versions from Excel 97 up.

If you want to start a word macro, it should work with the same technique...