+ Reply to Thread
Results 1 to 4 of 4

Open text file a subtle way

  1. #1
    Registered User
    Join Date
    02-27-2015
    Location
    Lithuania
    MS-Off Ver
    2010, 2013
    Posts
    26

    Open text file a subtle way

    Hey ladies and gents,

    I have to regularly paste a certain range of data from an Excel file to a text file. And so I have this macro:

    Please Login or Register  to view this content.
    It works fine. But the last bit just doesn't feel right.

    Is there a way of keeping the text file open without having to use a shell command after the file is already created?

    Your help would be greatly appreciated.

    Best,

    mellowtang

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Open text file a subtle way

    Why have you asked this question again, when I've already responded?

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

  3. #3
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Open text file a subtle way

    Do you even need the file open?

    If you want to append data, see if these routines give you an idea or two.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-27-2015
    Location
    Lithuania
    MS-Off Ver
    2010, 2013
    Posts
    26

    Re: Open text file a subtle way

    I am sorry for creating a duplicate thread.

    Originally this one had to be the original but when I pressed a button to post a thread it got stuck. I assumed it was not going to be published. But I was wrong.

    Sorry. And thank you for all of your input.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA code to open many files, copy text, close file, paste text in second work
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-11-2014, 12:59 PM
  2. Open an excell file or text file or pdf from anywhere in the system
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2013, 04:13 PM
  3. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  4. looping, Open text file, copy text, close text file
    By jwilds1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2009, 05:12 PM
  5. Some Subtle Issues with Some Formulas
    By Niester Rabbit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2007, 09:52 PM
  6. Replies: 0
    Last Post: 06-25-2007, 11:56 AM
  7. [SOLVED] Open CSV file, format data and write output to a text file.
    By BristolBloos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2005, 11:05 AM
  8. [SOLVED] How do I import text file, analyze data, export results, open next file
    By Geoffro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2005, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1