Results 1 to 2 of 2

Thread: Excell macro

  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Unanswered: Excell macro

    Hi all,

    i need to create a macro inside of excell.
    The purpose is from a list of excell cells (which contains a list of tables) y need to generate two text files.
    The first one has to contain a esquelet per table. And the second one the same but with different esquelet.

    LEt me explain: i call esquelet a group of sentence. This group of sentences has a parameter (table name). If the initial list has 10 tables, the text file has ten times the same group of sentences where the parameter is changing.

    The input items are a list of cell and two esqueltes. And the output items are two text files.

    Thanks a lot.

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    not sure what you mean but to open a file to write to you can use

    Code:
    Sub test()
        Open "TestFile" For Output As #1
            Write #1, Range("A1").Value
        Close #1
    End Sub
    David

Posting Permissions

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