+ Reply to Thread
Results 1 to 12 of 12

copy range from excel and paste to text file

  1. #1
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    398

    copy range from excel and paste to text file

    Hi,

    I have a VB code which copy range from excel and paste to text file, but the text file contains some double quotation marks (") but I dont want it (") .

    How to remove it.

    Please help

    here is my vb code.

    Please Login or Register  to view this content.
    My English is very poor, so please be patient >_<"

    Thanks & Regards.
    hkbhansali

  2. #2
    Registered User
    Join Date
    07-21-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    58

    Re: copy range from excel and paste to text file

    Hi,
    i don't see any marks (")

  3. #3
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,312

    Re: copy range from excel and paste to text file

    Possibly adding this after setting the Workrng...
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    398

    Re: copy range from excel and paste to text file

    Hi dangelor

    where to add your code?

  5. #5
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    398

    Re: copy range from excel and paste to text file

    Hi MrGes,

    Here is my Test Sheet.
    Attached Files Attached Files

  6. #6
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,312

    Re: copy range from excel and paste to text file

    where to add your code?
    As I stated, after the range Workrng was set...
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-21-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    58

    Re: copy range from excel and paste to text file

    Try this
    Please Login or Register  to view this content.

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

    Re: copy range from excel and paste to text file


  9. #9
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    398

    Re: copy range from excel and paste to text file

    Hi dangelor

    I have add code but still text file contains some double quotation marks (") (in start and end)
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    398

    Re: copy range from excel and paste to text file

    Hi MrGes

    Your code works perfect but I can't select text file.

    see attach file and use module2
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    07-21-2019
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    58

    Re: copy range from excel and paste to text file

    I can select the text
    try now
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    398

    Re: copy range from excel and paste to text file

    yes, it is but I want to select folder and save it in my exist txt file

+ 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. Copy specified text file and paste to correspondence excel sheets
    By nicks1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2018, 11:35 AM
  2. [SOLVED] Copy range and paste in a new excel file.
    By Vagelisr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2018, 07:31 AM
  3. [SOLVED] VB Code to copy and paste text file into excel.
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-06-2017, 03:46 PM
  4. Copy Visible Range in Excel and Paste into Text File
    By jpv5 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-14-2016, 09:15 AM
  5. [SOLVED] Copy same range in many excel files and paste into a main file
    By dualaudio454252 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2014, 05:25 PM
  6. macro to copy used range and paste in the body tag of a html file/text file
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 08:34 PM
  7. [SOLVED] Unable to copy and paste a text file into excel
    By Jack40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 10:53 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