Saving Selected Cells in Excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ebs57
    New Member
    • May 2007
    • 18

    Saving Selected Cells in Excel

    Does anyone know how to easily and programmaticall y save a range of cells with Excel VBA to a CSV, text or other file? It would be nice if I did not have to create another worksheet first, too, but if not possible then so be it.

    I cannot even find a menu selection that will let me save a selected range of cells from a worksheet so I can't run a macro and then borrow the code.

    From what I can find online is to use GetFromClipboar d with some sort of Save or SaveAs operation but I can't make it work. Any hints would be just lovely.

    - Lumpy
Working...