pratish2005
New Member
- Joined
- Dec 6, 2010
- Messages
- 2
Hi,
I need a little bit of help for the following problem in VBA. If anyone could help me, that would be great -
I have an excel sheet which is being dynamically updated every few seconds (lets call is "live.xls"). I want to store the dynamically updated data from one of the worksheets of "live.xls" into another excel sheet (called "backup.xls") everytime "live.xls" is updated. So in a sense, "backup.xls" will also become a dynamically updated sheet.
More specifically, I want to copy cells "A5" to "DQ5" from a worksheet "live_worksheet" of "live.xls" to the backup workbook "backup.xls" in a sheet titled "live_backup_worksheet". How do I code this in VBA? Also, is it possible to do this copying work from an Excel window different from the one in which "live.xls" is working?
Also is there a way by which I can stop the live updating process? Suppose I feel like stopping the update ath this moment, I would like to just run a VBA macro and stop it.
Thanks for the help
I need a little bit of help for the following problem in VBA. If anyone could help me, that would be great -
I have an excel sheet which is being dynamically updated every few seconds (lets call is "live.xls"). I want to store the dynamically updated data from one of the worksheets of "live.xls" into another excel sheet (called "backup.xls") everytime "live.xls" is updated. So in a sense, "backup.xls" will also become a dynamically updated sheet.
More specifically, I want to copy cells "A5" to "DQ5" from a worksheet "live_worksheet" of "live.xls" to the backup workbook "backup.xls" in a sheet titled "live_backup_worksheet". How do I code this in VBA? Also, is it possible to do this copying work from an Excel window different from the one in which "live.xls" is working?
Also is there a way by which I can stop the live updating process? Suppose I feel like stopping the update ath this moment, I would like to just run a VBA macro and stop it.
Thanks for the help
