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

's Computer Specifications

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

's Computer Specifications

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.

--

Regards,
Nigel
(E-Mail Removed)

"Vico" <(E-Mail Removed)> wrote in message
news:35E8F0D4-97A7-4126-AF3B-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel VBA - copy csv info to specific cells	Vince Bowman	Microsoft Excel Programming	4	23rd Dec 2009 01:10 AM
How can I copy/paste protected cells in excel	JeneeLynn	Microsoft Excel Misc	0	18th Apr 2008 06:09 PM
in excel paste images to specific cells that can be sorted	=?Utf-8?B?dHNz?=	Microsoft Excel Misc	0	26th Apr 2006 02:12 AM
Re: Copy/Paste in Excel prints highlighted cells and does not paste	Debra Dalgleish	Microsoft Excel Misc	0	30th Jul 2003 11:59 PM
Re: Copy/Paste in Excel prints highlighted cells and does not paste	Dave Peterson	Microsoft Excel Misc	0	30th Jul 2003 11:08 PM