How can I make Excel copy and paste specific cells every 15minuts

  • Thread starter Thread starter Vico
  • Start date Start date
V

Vico

Can you please help me to make a function in Excel to copy a specific group
of cells (updated by DDE) and paste them every 15 minutes in a new line
 
Take a look at Application.OnTtime function

Application.OnTime Now + TimeValue("00:15:00"), "CopyLine"

Procedure CopyLine would be executed in 15 minutes time, put above in a
controlled loop to repeat.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy value from changing cells without VBA 1
On-sheet activeX component disables copy/paste 6
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
How to make web image on Excel worksheet permanent 3
How to use AT command for every 15minutes? 2
Automate Copy and Paste? 10
Red cell for negative numbers in Excel 1
Event triggered in Excel's cell by DDE 3

Back
Top