Results 1 to 4 of 4

Thread: Using Excel(from VB) and Delete rows

  1. Sep 11th, 2006, 06:24 AM #1
    mutley
    mutley is offline

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    709

    Using Excel(from VB) and Delete rows

    Hi

    I need to open a excel sheet , select some columns and to delete the rows , where a cell from a column is blank.
    For Example I to select the columns A, and the rows from column A is Blank I delete all row withou look column B or C or D

    I do not know to open Excel from VB and too How can I to do it ?


    Thank you in Advance
    Reply With Quote Reply With Quote
  2. Sep 11th, 2006, 06:49 AM #2
    Paradox
    Paradox is offline
    Addicted Member Paradox's Avatar
    Join Date
    Sep 2004
    Location
    Nairobi
    Posts
    189

    Re: Using Excel(from VB) and Delete rows

    check out this Link could get u started on Excel + VB
    Peny wise pound Foolish
    Reply With Quote Reply With Quote
  3. Sep 11th, 2006, 09:07 AM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Using Excel(from VB) and Delete rows

    Here is a short FAQ thread on automating an office app from VB 6. - http://vbforums.com/showthread.php?t=406640
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Sep 12th, 2006, 06:04 AM #4
    mutley
    mutley is offline

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    709

    Re: Using Excel(from VB) and Delete rows

    Thank You Very Much
    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