Results 1 to 4 of 4

Thread: run-time error 429 (Excel apllication)

  1. Jan 3rd, 2006, 03:07 PM #1
    tuyetanh
    tuyetanh is offline

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    2

    run-time error 429 (Excel apllication)

    Can I write a vb program that create an excel workbook and run it on a pc that doesn't have excel?
    I was just trying to see if it works, I wrote a vb form with a cmd button to add a Excel application, add a workbook, with 2 columns on sheet1, make an exe, install on a pc that doesn't have excel (Window XP Home Edition), ran the exe, and received a run-time error 429.
    Thanks.
    Reply With Quote Reply With Quote
  2. Jan 3rd, 2006, 04:31 PM #2
    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: run-time error 429 (Excel apllication)

    Hi, welcome to VBForums

    No you can't I'm afraid, as Excel does the work. You can use CSV files tho, as they are just text files which you can work with using normal VB code for files (see the FAQ link in my signature for code examples).
    (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
  3. Jan 5th, 2006, 10:55 AM #3
    Dave Sell
    Dave Sell is offline
    PowerPoster Dave Sell's Avatar
    Join Date
    Mar 2004
    Location
    /dev/null
    Posts
    2,961

    Re: run-time error 429 (Excel apllication)

    Yes you can create .XLS Workbooks with your own Sheet tabs and columns without having Excel installed at all. All it requires is ADO:

    http://www.vbforums.com/showthread.p...t=Excel+SELECT
    Nobody knows what software they want until after you've delivered what they originally asked for.

    Don't solve problems which don't exist.

    "If I had eight hours to cut down a tree, I'd spend six hours sharpening my axe." --- Abraham Lincoln (1809-1865)

    2 idiots don't make a genius.
    Reply With Quote Reply With Quote
  4. Jan 9th, 2006, 01:08 PM #4
    tuyetanh
    tuyetanh is offline

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    2

    Re: run-time error 429 (Excel apllication)

    Thanks for the help.
    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