Results 1 to 2 of 2

Thread: Excel File

  1. Jul 31st, 2002, 04:41 AM #1
    peach12
    peach12 is offline

    Thread Starter
    Member
    Join Date
    Jun 2002
    Posts
    44

    Excel File

    Hi,

    Could someone be able to tell me how I open an excel file and save it as a text file.

    I need to format it as a text file

    tks
    Reply With Quote Reply With Quote
  2. Jul 31st, 2002, 04:56 AM #2
    reznor
    reznor is offline
    Addicted Member reznor's Avatar
    Join Date
    May 2001
    Location
    Netherlands
    Posts
    151
    In Excel choose file -> Save As
    The just choose the tabbed (*.txt) or the CSV format. Both are ASCII exports. The same functionality can be controlled from VB. In VB you'll have to set a reference to the Excel object library and make an Excel.Applicatio object. Just record a macro in Excel and look at the code for the export.

    hope this helps,
    Rick
    "Computers are incredibly fast, accurate and stupid. Human beings are incredibly slow, inaccurate and brilliant. Together they are powerful beyond imagination." - Albert Einstein
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width