Results 1 to 2 of 2

Thread: Need Help with Excel

  1. Dec 6th, 2000, 12:47 PM #1
    fnajar
    fnajar is offline

    Thread Starter
    Lively Member
    Join Date
    Nov 2000
    Location
    Guadalajara, Jalisco, Mex
    Posts
    105
    I want to expor data like data in a msflexgrid or listview to a excel file, from a VB proyect

    But i want to change the colums properties, and put formulas or totals.

    I don't know and i can't find, for example, to change the backcolor of a cell.

    Another thing, when i fill the cell with some text like this

    xlsApp.Cells(15, 2) = "=SUM(B2,B10)",

    when i open the file in excel, the cell appears with "#######".





    Reply With Quote Reply With Quote
  2. Dec 6th, 2000, 01:10 PM #2
    Static
    Static is offline
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    #####

    That means the cell is not wide enough...

    just adjust the cell width

    as far as settings...
    create a macro in excel...and then check the code...
    usually you can change it for VB
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width