If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Excell macro

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-26-04, 10:04
monaco monaco is offline
Registered User
 
Join Date: Aug 2004
Posts: 1
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.
Reply With Quote
  #2 (permalink)  
Old 08-26-04, 11:15
DavidCoutts DavidCoutts is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On