Results 1 to 5 of 5

Thread: Can i get a quick yes or no answer? Its about vb6 and excel

  1. Mar 10th, 2011, 11:54 AM #1
    alacn
    alacn is offline

    Thread Starter
    Member
    Join Date
    Mar 2007
    Posts
    47

    Can i get a quick yes or no answer? Its about vb6 and excel

    Is it possible for me to create a vb program which can format an existing excel spreadsheet?

    I.E add/delete information in cells, add borders and colors etc.

    The reason why i am doing this is because i have an application which creates multiple spreadsheets which are unformated, so i wna write a small vb app which updates these spreadsheets with a single click
    Reply With Quote Reply With Quote
  2. Mar 10th, 2011, 12:20 PM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: Can i get a quick yes or no answer? Its about vb6 and excel

    Quote Originally Posted by alacn View Post
    is it possible for me to create a vb program which can format an existing excel spreadsheet?
    The quick answer is YES.
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  3. Mar 10th, 2011, 12:21 PM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Can i get a quick yes or no answer? Its about vb6 and excel

    Yes you can.

    My Excel tutorial (link in my signature) contains pretty much everything you need. For borders/colours/etc, see the Macro's section.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  4. Mar 11th, 2011, 12:11 PM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Can i get a quick yes or no answer? Its about vb6 and excel

    alacn: Your question on protocol packets has nothing to do with the original topic of this thread so I have split your question into its own, new, thread and moved it to Database Development.

    You can find it here.
    Reply With Quote Reply With Quote
  6. Mar 12th, 2011, 12:59 AM #5
    skemb321
    skemb321 is offline
    Junior Member
    Join Date
    Jan 2011
    Posts
    24

    Re: Can i get a quick yes or no answer? Its about vb6 and excel

    a BIG YES.

    but it's easier in Microsoft Access..

    interest controls curiosity.
    conscience controls karma.
    you alone can control yourself.
    know yourself and be above those who are lost.
    skemb321
    hehehe
    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