(redirected from Programming.ExcelParsing)

 

 

General Notes

dumping things here to find, later.

 

http://www.perlmonks.org/?node_id=544814
http://www.ozgrid.com/forum/showthread.php?t=13329
http://www.mvps.org/dmcritchie/excel/sheets.htm
http://p2p.wrox.com/topic.asp?TOPIC_ID=47783

 

http://www.rath.ca/Misc/VBA/index.html

 

 

Tips and Tricks

Excel Pasting Tricks
Splitting One Cell Row into Multiple Rows (and then columns, if that’s your thing)

 

 

Code Editing

 

VBE

  1. Tools >> Macro >> Visual Basic Editor
  2. Alt F11

 

Script Editor (???)

  1. Tools >> Macro >> Microsoft Script Editor
  2. Alt-Shift F11

 

 

 

 

Export all sheets as CSV files

 

Sub ExportAllSheets()

    Dim sht         As Worksheet
    Dim FName As String
    Dim Stamp As String

    Const PATH As String = "T:\ExportFileLayout\dec\"

    Stamp = "_" & Format(Now, "ddmmyyyy")

    For Each sht In Sheets
        Debug.Print sht.Name

        FName = PATH & sht.Name & ".csv"

        'TODO: trouble-spot, SaveAs changes the active name, not an export :-(
        Call sht.SaveAs(Filename:=FName, FileFormat:=xlCSV)

    Next sht

End Sub

 

 

See Also

 

 

Category tags

Programming VBA Excel


 

Comments

No comments yet.

 

 

Add Comment

Heading:
 Your Message
 
 Enter value ← Have you entered the code number?
Author: