Tim,
Thanks for the reply. I have a macro that runs every 5 sec. that takes
data from and Access table and places it in to an Excel worksheet. I
then need to send this out to a PLC on our production floor for quality
inspection reasons. Right now I am simulating our scheduling software by
typing in the data manually and I have to hit enter and then going into
the excel spread sheet and hitting enter before all the updates work. I
am hoping that I can place a number in the access table without hitting
enter and have a VBA macro simulate the enter button in both Access and
Excel.

Hope this makes more sense,
Bob O


--
Bob O
------------------------------------------------------------------------
Bob O's Profile: http://www.excelforum.com/member.php...o&userid=26282
View this thread: http://www.excelforum.com/showthread...hreadid=395692