Jeff Barrows
Jeff at outbaktech.com
Wed Feb 1 11:06:43 CST 2006
John, I have done something similar to this not too long ago. I will look for the specific code samples and send them to you as soon as possible (might not be able to send them till tomorrow). Jeff Barrows MCP, MCAD, MCSD Outbak Technologies, LLC Racine, WI jeff at outbaktech.com ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin - Beach Access Software Sent: Wed 2/1/2006 10:20 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Manipulating Excel Cells Can you use the old trick of recording a macro and looking at the code? Rocky John Colby wrote: > I'm baaaack. ;-) > > Here's the deal. I am working with a spreadsheet that has columns of > systems and rows of documents. Therefore each cell represents a > system-document. BTW, this was a "source" for me to build a pair of tables > - tblSystem and tblDocument. I then added a field to tblDocument called > SpreadsheetRow and a field to tblSystem called SpreadsheetColumn. > > > We are tracking the receipt of these documents. The client now wants to > see, back in his original spreadsheet, the "status" of a given system > document using colors to express the status - white = not assigned, red = > not received, yellow = partial receipt, green = received. > > So... I have to go "poke colors" out into the spreadsheet. I have > discovered the "area" property which has a color attribute. What I need now > is a translation from the column LETTERS to a column number since for some > bizarre reason the columns have letter names but cells are referenced by > column numbers. "Brain damaged children" as Bill Cosby would say. > > Does anyone have code for manipulating cells by cell(intRowNumbers, > strColNames)? > > John W. Colby > www.ColbyConsulting.com > > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com