Hi everybody, thanks in advance for the feedback.
I am automating some excel sheets from VB. What I have now is the
below code that calls up an excel sheet and sets it running. This works
great when everything runs locally on my comp. Code below:
Sub foo()
Dim bar As Object
Dim ws As Object
Set bar = CreateObject("Excel.Application")
bar.Visible = True
Set ws = bar.Workbooks.Open("C:\Documents and Settings\p\My
Documents\book1.xls")
bar.Run "thisworkbook.doAnalysis"
End Sub
Is there any way to make the isntance of excel come up and start
running on a different computer?
I've tried this for the createObject call but it doesn't seem to be
working:
Set bar = CreateObject("Excel.Application", "otherCompName")
Any ideas?
Thanks,
P
Bookmarks