Excel VBA

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 ...it 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?

Thanks
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Naresh PatelTraderAuthor Commented:
Thanks
0
SteveCommented:
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.

ATB
Steve.
0
Naresh PatelTraderAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.