Consulting

Results 1 to 5 of 5

Thread: Export data to file

  1. #1

    Export data to file

    I have several slides with check boxes and text boxes. Through VBA, I can create one or more text strings and print them to the debugger. However, I would like to save the string to a file. Before a user begins making choices, I use an inputbox to get his/her initials. I should be able to use these initials plus the date to generate the file name.

    Is there a quick and dirty way of creating and closing the file?
    ttfn

    Kicker

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,094
    Location
    There are examples on pptfaq.com in the programming > exporting section

  3. #3
    John:
    Never knew that site existed. Do now and have it bookmarked. Looks like a good site for some misc information. Thank you. I found what I needed and will put it to work later.
    ttfn

    Kicker

  4. #4
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Hi Kicker
    Will you post your solution when you have it for the benefit of others.
    Regards
    MD
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  5. #5
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,094
    Location
    This is the code I use to output text . Obviously other users would need to change the path. The text can be a variable or text as here.[vba]Sub TextOut()
    FileNum = FreeFile
    Open "C:/Documents and Settings/John/My Documents/" & "NotesText2.TXT" For Output As FileNum
    Print #FileNum, "This is the text to save"
    Close FileNum
    End Sub[/vba]
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

Posting Permissions

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