+ Reply to Thread
Results 1 to 11 of 11

Selection Copies Text and Saves File with Date and Time

  1. #1
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Selection Copies Text and Saves File with Date and Time

    Well....Good day to all of you.....i just was searching for a vba code to do the following;
    1. While in the webbrowser when I try to Select a part of the text, I want that text to be Copied to a document file and saved with current system date and time. (I use MS Word 2007). Thank you all.....for your great job on this site....

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Selection Copies Text and Saves File with Date and Time

    Rather than trying to automate the browser to try to find out what has already been selected, you'd do better to simply copy it yourself, then run a macro like:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Selection Copies Text and Saves File with Date and Time

    well i was actually not asking the browser to be automated.....think you got me wrongly...... actually what i am doing is....i log into a software of company which is a webbased browser first. 2. and while in there....... i see that want a part of the text in the file there...... and as soon as i select the part of the "text" using either mouse or by keyboard........ 3.. All i want is that particular "text" copied should be saved as a document file in a certain folder..along with date time. ..Hope I am clear now.....thanks for your response....

  4. #4
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Selection Copies Text and Saves File with Date and Time

    SINCE COPYING MANUALLY IS WHAT WE DO FOR AS OF NOW AND THERE ARE MORE THAN 6000 FILES WE DEAL WITH IT IN A DAY.....so it is not possible physically to copy every time...that is the reason we requested coding to this automatically.......i hope you get the point....

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Selection Copies Text and Saves File with Date and Time

    There is no mechanism for automatically generating a Word document simply from the mere fact you've selected something on a web page. In reality, this isn't even a Word question, since the only thing this has to do with Word is the format in which you want to save the selected content - and you don't really need to use Word for that.

  6. #6
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Selection Copies Text and Saves File with Date and Time

    macropod....this i actually need a ms word document opened and copied of the selected contents.......

  7. #7
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Selection Copies Text and Saves File with Date and Time

    correct me if i am wrong....... as soon as i select... a piece of text..... all i want is to copy to already opened blank MS word document and that needs to be saved with date and time.....hope i xplained it better..now.. thanks...for ur patience...and time...

  8. #8
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Selection Copies Text and Saves File with Date and Time

    Quote Originally Posted by Quivolt View Post
    correct me if i am wrong....... as soon as i select... a piece of text..... all i want is to copy to already opened blank MS word document
    Word cannot detect the fact that you've selected something on a web page. Period.

  9. #9
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Selection Copies Text and Saves File with Date and Time

    ohhhh.....ok thanks macropod for shedding some light on this......got your point.... is there any other way to do this....please suggest...awaiting something favorable..

  10. #10
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Selection Copies Text and Saves File with Date and Time

    You would have to do the copying manually, then switch to Word, where you could run a macro to paste the content into a currently-open document and save that with your filename specs.

  11. #11
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Selection Copies Text and Saves File with Date and Time

    ohhh ....ok

+ 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] Macro that copies a formula to another sheet and copies data at same time
    By Newbienewbster0932 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2017, 02:49 PM
  2. Replies: 15
    Last Post: 03-25-2017, 04:23 PM
  3. [SOLVED] Macro that copies workseet into new book saves as broken unless converted first
    By Ozman89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2016, 01:28 PM
  4. Loop through Code that copies the content of a text file to another text file
    By michiel soede in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2013, 01:34 PM
  5. Problem with importing Date (& time) on CSV file using text to columns and macro
    By Rikkdh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 06:19 AM
  6. Macro Saves & Names File with Current Date & Range
    By BluTalon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-30-2008, 03:51 PM
  7. build a macro that saves & names a file with the current day's date
    By mariusescu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2008, 10:22 AM

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