Results 1 to 3 of 3
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question Format Excel through VBA


    Does anyone have any information on this? (i.e. a list of commands)? I'm trying to format a sheet, which I have never done, and I would like to review a list of commands to know what I can do and can't do. Thanks in advance.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    jg,

    have you tried recording what you want to do first? excel will give you the syntax.

  3. #3
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Brilliant....I was really trying to make it more difficult on myself. Thanks for the sanity once again!

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

Similar Threads

  1. Access Report to Excel format
    By mar_t in forum Access
    Replies: 3
    Last Post: 04-11-2011, 12:27 PM
  2. Create Report in a Matrix Format Like Excel
    By ortley77 in forum Reports
    Replies: 1
    Last Post: 08-24-2010, 09:56 AM
  3. Replies: 0
    Last Post: 11-17-2009, 02:35 PM
  4. Open / Save as Excel File and specifiy format
    By jaykappy in forum Access
    Replies: 8
    Last Post: 03-24-2009, 03:26 PM
  5. Excel number format not working in Access
    By toad848 in forum Access
    Replies: 3
    Last Post: 03-24-2009, 11:06 AM

Tags for this Thread

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