manipulating Excel via Access

[Guest]

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

 

[Arvin Meyer]

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?

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