Results 1 to 4 of 4
  1. #1
    thedao
    Guest

    DDE to Open exported Text file from Access (Access2000)

    I have just exported a query to a text file in VBA. I want to open this text file now in VBA in a sizable window. Can I use DDE to do this, or the call statement. Perhaps someone has a suggestion?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DDE to Open exported Text file from Access (Access2000)

    What are you trying to do ?
    You can't open a text file directly from vba into an access form. You have to import it first, but you have just export it ???
    What you can do is open the file with notepad from vba whit the code :
    Shell "notepad.exe c:yourdirectoryyourfile.txt"

    Hope this help

    Francois
    Francois

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DDE to Open exported Text file from Access (Access2000)

    Are you trying to open it in *Access* or just pop it up to look at it, or what? There's no reason to use DDE for this at all. You import the file back into Access if you wish or just open it in Excel or even Word or Notepad (if it's small enough).
    Charlotte

  4. #4
    thedao
    Guest

    Re: DDE to Open exported Text file from Access (Access2000)

    from access...Thanx for the help, all your suggestions worked!

Posting Permissions

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