Another Excel Question

[m204prgmr]

Has anyone had one Excel document open, added at least one worksheet to that document and inserted a comma delimited .txt file into the new worksheet.

I have 4 .txt documents that I want to put into 1 Excel window using the worksheet tabs. Oh, and I need to rename the tabs..

 

thanks

[randallc]

Hi,

My Excel function will do that in the next version, but I have not heard if the last one is running on your machine yet so have not posted.

Best, Randall

You need new ExcelComWIZ;

And Only the "exe" in MEX directory from the zip;

{_ExcelComWIZ}.mxe

AddNameImportSheetExamples2

MEbasicWizard.zip

// Addto cell F1

Variable Set String %T1% "ExcelAdd2Cell$["C:\Program Files\Macro Express3\Book1.xls","1","F","1","Save","10","Visible","NoExit","NotLastRow","0"]"

Macro Run: {_ExcelComWIZ}

Text Box Display:

// SheetAdd============================================

Variable Set String %T1% "ExcelSheetAdd$["C:\Program Files\Macro Express3\Book1.xls","1","F","1","Save","Hi","Visible","NoExit","LastRow","0"]"

Macro Run: {_ExcelComWIZ}

// GetSheetName==========================================

Variable Set String %T1% "ExcelGetSheetName$["C:\Program Files\Macro Express3\Book1.xls","1","F","1","Save","Hi","Visible","NoExit","LastRow","0"]"

Macro Run: {_ExcelComWIZ}

Text Box Display:

// NameSheet============================================

Variable Set String %T1% "ExcelNameSheet$["C:\Program Files\Macro Express3\Book1.xls","1","F","1","Save","NewSheetNamed","Visible","NoExit","0","0"]"

Macro Run: {_ExcelComWIZ}

// Import CSV into Sheet======================================

Variable Set String %T99% "*.csv"

Variable Set String %T99% from File Name

If File Exists "%T99%"

  Variable Set String %T1% "ExcelImport$["C:\Program Files\Macro Express3\Book1.xls","1","A","1","Save","%T99%","Visible","NoExit","0","0"]"

  Macro Run: {_ExcelComWIZ}

End If

// Import only a specified range from a CSV into Sheet=============

Variable Set String %T99% "*.csv"

Variable Set String %T99% from File Name

If File Exists "%T99%"

  Variable Set String %T2% "%T99%///Sheet1///A1:B7"

  Variable Set String %T1% "ExcelCopyTo$["C:\Program Files\Macro Express3\Book1.xls","1","A","1","Save","%T2%","Visible","NoExit","0","0"]"

  Macro Run: {_ExcelComWIZ}

End If

==========================================

Best, Randall

[m204prgmr]

Randall,

Thanks so much, I'll try it in a bit...have a great Saturday, wherever you are