Jump to content
Macro Express Forums

Another Excel Question


m204prgmr
 Share

Recommended Posts

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...