Consulting

Results 1 to 2 of 2

Thread: OLE created workbook vs User Created

  1. #1
    VBAX Regular
    Joined
    Aug 2008
    Location
    Manchester,UK
    Posts
    14
    Location

    OLE created workbook vs User Created

    Hi there,

    Can anyone point me to the correct property for finding out of a workbook has been created through code/automation or if a user has created a new workbook?

    I know it exists but Ive scoured all documentation i can possible look at but am unable to find it?

    Any help most appreciated.

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Hi there,

    I would be happy to be corrrected, but as far as I know, there is no property saved with a workbook to indicate how it was created. Might you be remembering Application.UserControl?

    Mark

Posting Permissions

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