Excel VBA

Posted on 2014-09-01
Last Modified: 2014-09-01
Hi Experts,

I am not sure it can be done or not.I have one application which scan server data and produce results which fall in criteria. After that there is export option tab in application which export those results to excel.I just want to instead of manual clicks can be done via excel vba from excel spreadsheet it self?

Application scan run automatic 1 min so excel vba export those result in excel automatic in 1 min?

Question by:itjockey
    LVL 67

    Accepted Solution

    In general: no. You'll have to build the logic in VBA itself, but you (usually) can't control other applications. With the exception of simulating keyboard input, so the application thinks you are entering data or pressing keys.
    LVL 8

    Author Closing Comment

    LVL 24

    Expert Comment

    What is the architecture of the system you are working with?
    You are scanning server data... is this a database?
    Databases can be read by Excel, Access and many other VBA accessible methods.
    So there may be a method to achieve the results you desire.

    So, can you provide a little more information on what is being 'scanned'.
    I would expect it to be some form of database.

    LVL 8

    Author Comment

    Thank You Sir Steve,

    even I am sure  it would be some form of database. but I cant have access to that data base - I have to add criteria in application it self & it produce result. sever of this data base far from my location & I cant have access.

    Again thank you for posting comment on closed question .....sure I will connect you if I have any query regarding data base.

    Thank You

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    Title # Comments Views Activity
    Outlook import PST file missing emails 9 45
    Determine Office 2013 Bit Version 3 16
    Min Month 11 29
    Excel 2010 question 3 20
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now