Results 1 to 2 of 2

Thread: 'user defined type not defined ' error message????

  1. Aug 28th, 2000, 04:45 PM #1
    timbo
    timbo is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2000
    Posts
    31
    Hi

    I am attempting to write values into excel and this error message comes along pointing to the line of code:-

    Dim xlApp As New Excel.Application

    Please help!
    Reply With Quote Reply With Quote
  2. Aug 28th, 2000, 04:51 PM #2
    HeSaidJoe
    HeSaidJoe is offline
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946
    try this...
    'create and object (Excel SpreadSheet)
    Dim xlApp As Object
    Set xlApp = CreateObject("Excel.Application")
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."
    ___ Adolf Jensen
    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