Automation Problems

[CLee]

OK. I have an excel spreadsheet and a vba subroutine called "DoOpenSourceFile" When run it reads a text file and processes a series of records. Ok so far.
I need to execute this inside of ms word.

I can use CreateObject to start an instance of excel and brin in my spreadsheet. I can set the property visible = true, so excel become visible.

Now I need to execute my excel subroutine. (Its not a recorded macro.)

Thank
Chris

 

[Dreamboat]

Well, Chris, can you make it auto-open macro in Excel?
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[kruskovac]

I agree with dreamboat, you should be able to call the function from the open event of the workbook when it first opens

 

[CLee]

Thanks to Dreamboat and kruskovac,

I moved my code behind the sheet1 to a
module, changed a few private subs to public,
set the Open event to action the sub and
that did it.

Import to understand about SCOPE of vars, subs and functions.