Re: VBA to simulate the enter button?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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 work***. 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 *** 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?action=getinfo&userid=26282
View this thread: http://www.excelforum.com/showthread.php?threadid=395692

.

Quantcast