Generating an Excel Worksheet

[AntonioPerera]

Hi ,

I need to use a VBA macro from within another apllication to pull data from a text file and create an excel sheet with multiple worksheets.

Can anybody give me an insight into how to convert the text file into excel with multiple worksheets ?

 

[HughLerwill]

thread707-1187154 may be of interest to you.

Hugh

 

[SkipVought]

From within WHAT application?

Why THAT application?

Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}