Is there a shortcut to copy data from Formula Bar?

  • Thread starter Thread starter mcmilja
  • Start date Start date
M

mcmilja

Hello,

I have created a database update macro using macroexpress which copies data
from excel and pastes it into a database. I have the macro set up to click
on a specific cell in the worksheet and it types ctrl+c to copy the data.
The problem is that 50% of the time when I copy from the cell, whether I'm
using my macro or copying manually, it does not paste into the field in the
database. I have found that if I click on the cell and then copy the data
from the Formula Bar that it will paste into the database field 99% of the
time. So my question is, is there a shortcut to copy data from the Formula
Bar that I can use in my macro?

Thanks,
Jaret
 
Have you thought about getting rid of the third-party macroexpress and using
Excel's built-in VBA macro capabilities?

See Ron de Bruin's site for copy/paste/merge example code for moiving data to a
database.

http://www.rondebruin.nl/tips.htm

There is no shortcut that I know of for copying directly from the Formula Bar.


Gord Dibben MS Excel MVP
 
Hello Gord,

I have to use macroexpress because I need the use of mouse and keyboard
stroke commands to have the macro navigate to where the fields are located
within the software client to update them.

Thanks,
Jaret
 
Back
Top