• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

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
0
Naresh Patel
Asked:
Naresh Patel
  • 2
1 Solution
 
QlemoC++ DeveloperCommented:
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now