+ Reply to Thread
Results 1 to 5 of 5

Need Web zacks data in excel sheet and word document automatically

Hybrid View

alialimian12 Need Web zacks data in excel... 12-09-2017, 03:33 AM
FDibbins Re: Need Web zacks data in... 12-09-2017, 03:37 AM
alialimian12 Re: Need Web zacks data in... 12-09-2017, 04:06 AM
Pepe Le Mokko Re: Need Web zacks data in... 12-09-2017, 01:44 PM
alialimian12 Re: Need Web zacks data in... 12-10-2017, 05:42 AM
  1. #1
    Registered User
    Join Date
    12-09-2017
    Location
    Islamabad
    MS-Off Ver
    2007
    Posts
    3

    Need Web zacks data in excel sheet and word document automatically

    Need zacks data in excel sheet automatically
    Dear Members
    I need to zacks data in excel sheets automatically
    Then From that excel sheet to word document

    https://www.zacks.com/stock/quote/AA?q=aa?q=AA
    https://www.zacks.com/stock/quote/AA/detailed-estimates
    Then From that excel sheet to word document
    Like from this table
    Next Report Date 1/23/18
    Current Quarter 1.24
    EPS Last Quarter 0.75
    Last EPS Surprise -4.00%
    ABR
    1.59

    I want to covert table data in readable paragraph form. Interpreting and explaining in details this table data.

    The company expects to report next earnings on 1/23/18. Zacks Expert says that the company estimated to report current quarter earnings of 1.24. AA reports earnings of 0.75 in last quarter earnings report
    I need your help
    Note:::
    I posted the same issue on following forum also
    I need Urgent solution therefore posted on these forum also
    https://www.mrexcel.com/forum/excel-...cel-sheet.html
    https://chandoo.org/forum/threads/ne...tically.36656/
    Attached Files Attached Files
    Last edited by alialimian12; 12-10-2017 at 05:39 AM. Reason: Attach Dummy sample

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Need Web zacks data in excel sheet and word document automatically

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-09-2017
    Location
    Islamabad
    MS-Off Ver
    2007
    Posts
    3

    Re: Need Web zacks data in excel sheet and word document automatically

    FDibbins Thread is updated with sample file

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,605

    Re: Need Web zacks data in excel sheet and word document automatically

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

  5. #5
    Registered User
    Join Date
    12-09-2017
    Location
    Islamabad
    MS-Off Ver
    2007
    Posts
    3

    Re: Need Web zacks data in excel sheet and word document automatically

    Dear Updated that thread and mentioned the cross-positng on this forum and also highlighted on others forum too.
    Sorry Cross posting and did not mention the thread which I created to resolve the issue
    Currently I updated every forum thread and mention the links of cross-posting question
    I need Urgent solution therefore posted on these forum also
    I posted the same issue on following forum also and mentioned cross-posting there too
    https://chandoo.org/forum/threads/ne...tically.36656/
    https://www.excelguru.ca/forums/show...-sheet&p=35618
    https://www.mrexcel.com/forum/excel-...cel-sheet.html
    Last edited by alialimian12; 12-10-2017 at 06:05 AM.

+ 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. Extract Word header table data to excel (closed word document)
    By Yakov on Excel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2017, 02:12 PM
  2. Mail merge of Excel data to Excel document, not using a Word document
    By Howie D in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2015, 07:35 AM
  3. [SOLVED] Browse Word Document data into excel sheet
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2015, 07:43 AM
  4. [SOLVED] Want to insert Excel sheet in Word document - comes out too big.
    By Chicago in forum Excel General
    Replies: 4
    Last Post: 03-30-2006, 06:55 PM
  5. Replies: 0
    Last Post: 01-19-2006, 01:10 PM
  6. Replies: 1
    Last Post: 10-31-2005, 03:05 PM
  7. [SOLVED] How to transfer info automatically from an excel data base to a word document OR an excel
    By Starriol in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 03:05 PM

Tags for this Thread

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