Results 1 to 2 of 2

Thread: Workbooks("q.xls").author = ""

  1. Jan 12th, 2000, 10:47 PM #1
    michelle
    michelle is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2002
    Location
    Canada
    Posts
    455

    Post

    Dear vb users,

    I am trying to reset the author of an Excel sheet with the next command:

    Workbooks("q.xls").author = "New"


    The only choice I do have is:

    - Workbooks("q.xls").AutoUpdateFrequency
    - Workbooks("q.xls").AutoUpdateSaveChanges

    How can I make the choice for .Author?

    My references are connected with: Microsoft Excel8.0 Object Library

    Nice regards,

    Michelle.
    Reply With Quote Reply With Quote
  2. Jan 12th, 2000, 10:57 PM #2
    netSurfer
    netSurfer is offline
    Hyperactive Member
    Join Date
    Jun 1999
    Location
    Calgary Alberta
    Posts
    359

    Post

    Are you doig this in VB or excel's VBA macros? I'm not sure if you can do it via VB. An interesting thing I found access Word and Excell via Access was that there is an pobject browser that lets you see properties etc. Doing this really helped alot figuring out the property name etc that I needed to edit. Hope this helps a little. I'm in the middle of something but when I get a chance I'll try to figure the exact syntax. Are you sure that you are able to edit the Author of an Excel sheet?
    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