I want to open an xls file in the browser(Let's say, http://host/Main.xls
). This xls file has a button and executes the macro when clicked. The macro should open another xls file(http://host/Branch.xls
) in the browser and copy some cells and paste to Main.xls
The problem seems to be in Windows().Activate function when the xls file is opened in the browser. So how to activate an excel file opened in a browser to be able to copy some cells?
Could anyone help me please.....
Thank you so much