Results 1 to 3 of 3

Thread: Variable Not Defined

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2010
    Posts
    1,415

    Variable Not Defined

    I'm getting this error with

    Code:
    Dim fd as FileDialog
    Set fd = Application.FileDialog(msoFileDialogFolderPicker)
    Highlighting Application.
    But this should work I think ?
    I have a reference to Microsoft Office 14 Object Library

  2. #2
    PowerPoster
    Join Date
    Jul 2010
    Location
    NYC
    Posts
    4,893

    Re: Variable Not Defined

    You would need the application-specific object libraries, like Microsoft Excel 14.0 Object Library

    Keep in mind this will only work on computers that have 32bit Office installed.

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2010
    Posts
    1,415

    Re: Variable Not Defined

    Thanks fafalone, I'll abandon this and concentrate on the other file dialog we're discussing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width