how to run Excel from VB macro

[Walt Horn]

I am using Excel 2003. I am in the vb macro and would like to fire off my next program. It is also an Excel workbook. Can anyone guide me in this?

[ajryan88]

Hi Walt,

Insert this code into the macro (and change the file name and path where indicated):

Please Login or Register  to view this content.

Hope this helps

[Walt Horn]

Thanks for the suggestion, but it did not work for me. Here is where I am trying it:

My directory has exactly 5 files in it-
Select.xls
index5.html
SelectAI.xls
lists.csv
lists.txt
The macro I am working in is Select.xls
Here is where I placed your suggestion-

Please Login or Register  to view this content.

Here are a couple more items that may harm or help:
my goal is to move this to a web page
I am very glad you did not suggest using Shell, becausse I want to avoid this.

[Walt Horn]

I forgot to add the program name. It works great now

Set WB = Workbooks.Open(filePath & "/SelectAI.xls")

Many thanks.

[shg]

Walt,

Please take a few minutes to read the forum rules, then edit your posts to add CODE tags.

Thanks.

[ajryan88]

No worries Walt.

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks