Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Std width of object? (2000)

    Hi all,

    Was shown the following message recently in conjunction with the code below. Any idea what it is referring to? The book has worked fine up until now.

    This was highlighted in the VBE...

    DName = "C:Accounting 4.01ClientOutgoingSales" & ThisWorkbook.Sheets("Master").Range("a1").Value & " DailyInv.txt"
    Attached Images Attached Images

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Std width of object? (2000)

    I thought it was fairly peculiar also...will try the code cleaner. I finally figured that it happened after I removed two labels and added a button to a userform.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Std width of object? (2000)

    In my experience if unexpected error messages start to surface (especially if they don't seem to relate at all to the statement that gets highlighted) it is high time to clean the code. Strange things also happen to code modules that have become too large (compile errors most often).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Std width of object? (2000)

    Very peculiar indeed.
    Some trouble shooting questions then:

    - What is the length of this module?
    - Have you cleaned it yet? (Rob Bovey's code cleaner from http://www.bmsltd.ie/mvp does an excellent job at that)

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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