O
Opal
I am struggling with one last piece of the puzzle to a project and
would
appreciate any help I can get. I need to create a macro that will
copy
and paste a range of cells from one workbook to another.
I am a bit of a newbie to VB in Excel, so I tried to simply record a
macro
to do what I want, but I need to call the macro from Access and I was
getting several errors.
I have a database with a table containing employee information. Our
HR department updates an excel spreadsheet every week and I need to
import this spreadsheet to Access. I have created a temporary Excel
file
that will run several macros to format the spreadsheet to match the
table
I am importing to but I need to be able to copy and paste a range of
cells
from the HR file to my temporary file first. I have already been able
to call
all the formatting macros from Access sucessfully.
would
appreciate any help I can get. I need to create a macro that will
copy
and paste a range of cells from one workbook to another.
I am a bit of a newbie to VB in Excel, so I tried to simply record a
macro
to do what I want, but I need to call the macro from Access and I was
getting several errors.
I have a database with a table containing employee information. Our
HR department updates an excel spreadsheet every week and I need to
import this spreadsheet to Access. I have created a temporary Excel
file
that will run several macros to format the spreadsheet to match the
table
I am importing to but I need to be able to copy and paste a range of
cells
from the HR file to my temporary file first. I have already been able
to call
all the formatting macros from Access sucessfully.