Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Deer Park, Long Island
    Posts
    12

    Unanswered: How to open Excel from Access and format a cell

    How do I simply open Excel from Access using VBA (I would prefer early binding, but anything will do) and just change the color of a cell then save and Exit.
    jeffcoach

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Quote Originally Posted by jeffcoach
    How do I simply open Excel from Access using VBA (I would prefer early binding, but anything will do) and just change the color of a cell then save and Exit.
    Well, you'll have to sift through some code, but this is a prototype I did for exporting data to Excel from Access. Because it was prototype code, I don't think it hides Excel when it launches. You'll have to dig around to find out how to do this, it's just one parameter though.

    It doesn't exit, but I'm pretty sure that's just something like Application.Exit or Application.Quit.
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2004
    Location
    Deer Park, Long Island
    Posts
    12
    Thank you!
    jeffcoach

  4. #4
    Join Date
    Feb 2009
    Posts
    3
    Below are some tips on how to insert date and time in an excel cell for a specific purpose:-

    To insert current date, press “CTRL”+ “;” in the chosen cell.

    To insert current time, press “CTRL”+ “SHIFT”+ “;”.

    To insert current date and time together, press “CTRL”+ “;” “SPACEBAR”+ “CTRL”+”SHIFT”+ “;"

  5. #5
    Join Date
    Jan 2004
    Location
    Deer Park, Long Island
    Posts
    12
    Thanks for your reply
    jeffcoach

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •