+ Reply to Thread
Results 1 to 1 of 1

Macro modification that extracts the emails present in the links indicated in the column.

  1. #1
    Registered User
    Join Date
    04-03-2017
    Location
    italy
    MS-Off Ver
    2010
    Posts
    76

    Macro modification that extracts the emails present in the links indicated in the column.

    I have attached a macro that extrapolates the emails that are present in the web page of the url inserted in column "H" of sheet 1.

    The e-mails extracted are arranged by column in sheet 2. Besides the e-mails other characters / words are also extracted.

    Could you do so by inserting the addresses in column "a" and the results in the cell next to column "b" of sheet 1?

    I noticed that the e-mail extraction is slow when I insert multiple links and that the macro does not extrapolate the e-mails in the form of a hyperlink.

    Is it possible to speed up the macro in the hypothesis of inserting so many url and allow the extraction of emails in the form of a hypertext link beyond the withdrawal modifications (colon a) and the results entry (column b)?

    If you know a better method could you insert it here?

    Thank you
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 05-02-2016, 09:54 PM
  2. Replies: 2
    Last Post: 09-03-2014, 03:37 AM
  3. [SOLVED] Macro To Send Emails with PDF: Multiple Emails and PDF's
    By totoga12 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-19-2014, 06:13 PM
  4. Replies: 1
    Last Post: 04-28-2011, 08:16 PM
  5. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 PM
  6. [SOLVED] a macro that extracts sheets into a new file
    By hygum in forum Excel General
    Replies: 0
    Last Post: 04-19-2006, 03:30 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