Hello,

I m working on a macro that will basically sort, filter and subtotal the data. The data to be used is available in another application wherein i can run a query and get the data in excel friendly format. to get such data i need to click some options manually which i want to avoid

Can anyone suggest if there any function or command so that i can run the application other than excel and get data from such and manipulate it in excel.

Such application is not registered in objects library if excel.