How to open,copy and save as .. want to automate

Hi Guys,

I am working on a macro and looking for little help on completing that macro. I am looking for help on below task.

I want to have three files under my macro

File 1 - First Spreadsheet would be carrying my macro under a command button would be give to perform the task.On Clicking the command button the input file would be open ,perform the diffrent function and save the new file using saveas option for giving location to save new file.


file 2 - File 2 - Input FIle


FIle 3 - OutPut file

Through macro file, i would firstly browse the input file and after that it would create a new workbook with data of TV from input file by filtering on raw file and with extra column of result which going to reflect the multiplication of qty and price. It would also highlight the row whose result comes above 100. And at last that it ask us to save the output file.


I have attached my images, input file and output file for reference.



Please help me on this.

I am new on vba so still learning.

What difficulties you are facing??

It is not a Query.. %O

Satishdu, do you want to try and put together some piece of code and then ask specific queries. As in.vaibhav mentioned, what you've posted above is not a query (but more like a request for a project help).