manipulating Excel via Access

K

Kim

I have an Excel file that is created using Access. I am adding comment
boxes to certain cells in the spreadsheet, but if a cell already has a
comment, I want to skip it. Any ideas?

Kim
 
A

Arvin Meyer

Kim said:
I have an Excel file that is created using Access. I am adding comment
boxes to certain cells in the spreadsheet, but if a cell already has a
comment, I want to skip it. Any ideas?
Click to expand...

Once establishing a connection to Excel through Early or Late Binding, you
can treat Excel as an object variable and program it within Access somewhat
like any other variable. Have a look at this KB article which may help you
get what you need:

http://support.microsoft.com/default.aspx?scid=kb;en-us;142119
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top