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

F2, then shift + home, ctrl + c then esc


--


Regards,


Peo Sjoblom


"mcmilja" wrote in message
...
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

On Mon, 5 May 2008 12:57:02 -0700, mcmilja
wrote:

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

Thank you very much!!

"Peo Sjoblom" wrote:

F2, then shift + home, ctrl + c then esc


--


Regards,


Peo Sjoblom


"mcmilja" wrote in message
...
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

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

"Gord Dibben" wrote:

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

On Mon, 5 May 2008 12:57:02 -0700, mcmilja
wrote:

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