Results 1 to 3 of 3
  1. #1
    Sigzop is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2014
    Location
    DC
    Posts
    5

    how to export a product from Access into an Excel product with cells color coded


    Hello,
    I'm trying to export my queries into an Excel product color coded to one simple field. for example if a aircraft in maintenance will only be available for four months from oct-Jan in the Pacific i want it colored blue. I want it keying off the region EX: (Pacific) So far It shoots out the product with one color, and I have to manually change the colors in Excel. Any help would be great.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Options:

    1. set Conditional Formatting in the Excel sheet

    2. set cells to static fill color

    Both can probably be accomplished programmatically but I've never tried. Executing this code from Access would require VBA opening the workbook as an object that can be manipulated.

    I have an old book "Excel 2003 VBA - Programmer's Reference" that seems to have code example for setting Conditional Formatting on a range of cells. At the risk of copyright infringement, attached is a scan of the relevant page. I suggest you find this book or something like it.

    Click image for larger version. 

Name:	SKMBT_C55214081409380.jpg 
Views:	13 
Size:	207.8 KB 
ID:	17801
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Sigzop is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2014
    Location
    DC
    Posts
    5
    That is exactly what I'm trying to do. I'll fumble with the code, and look up the book you reference. Really appreciate the help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sum product convert to access
    By c.panteli@hartziotis.com. in forum Queries
    Replies: 9
    Last Post: 11-11-2013, 10:14 AM
  2. Replies: 4
    Last Post: 04-26-2013, 08:32 AM
  3. Replies: 3
    Last Post: 02-26-2013, 05:07 AM
  4. Replies: 1
    Last Post: 01-10-2013, 06:44 PM
  5. Replies: 1
    Last Post: 08-19-2010, 01:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums