Page 1 of 3 123 LastLast
Results 1 to 15 of 32
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A weird problem occured to me.. (2000)

    I'm not gus, but I'll try to answer. You wrote

    >> here the code..i found it in the workbook event

    What is the name of the workbook that contains this code? Write it down. Then quit Excel, and search for this workbook. You will probably find it in a folder named XLSTART; its exact location depends on your Windows version. All files in the XLSTART folder will be opened automatically when you start Excel.

    If you find the workbook, move it to another folder to stop loading it with Excel.

    Note: in Windows 2000/XP, the default location for XLSTART is in a hidden folder, so make sure that your Windows Explorer shows hidden files and folders.

  2. #2
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    thanks hans for the answer...

    i follow your step , unfortunately , in the xlt is empty..

    fyi , i didnt open any wb ...i just try open a blank wb..i mean a fresh empty wb also , this code will always boot with my excel

    any ideas..

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    another snapshot from my vbe

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A weird problem occured to me.. (2000)

    From your sceenshots, you can see that the workbook is named Schedule.xls. In Windows Explorer, do a search for Schedule.xls.

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    hahahhaha..

    its getting weird and weird..

    i have unhide all the folders , make a search like you recommend and still cant find Schedule.xls

    what sins have i done :wink:

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A weird problem occured to me.. (2000)

    Your screenshots clearly show that you have a workbook named Schedule.xls open. It MUST be somewhere on your PC.

    MSKB article HOW TO: Use Excel Startup Folders in Excel 2000 describes which folders act as startup folders for Excel 2000.

    You can also try the steps in Pieterse's star post <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    Try placing the following code in a module in a different workbook :

    Sub RemoveWorkBook()
    Dim strWBName As String
    With Workbooks("Schedule.xls")
    strWBName = .FullName
    <font color=red>.SaveCopyAs "C:Temp" & .Name</font color=red>
    .Close 0
    End With
    Application.DisplayAlerts = False
    Kill strWBName
    Application.DisplayAlerts = True
    End Sub

    This should remove the offending file from it's current location. The line in red wil save a copy to C:Temp, so if you want to include that line make sure the folder exists.

    Andrew C

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: A weird problem occured to me.. (2000)

    If you can see Schedule.xls in the VBE it is open. You could follow HansV's steps or you could also try this:

    Click on your Excel application, if Schedule.xls is not an apparently open file, I I expect Schedule.xls is hidden, so select Window, Unhide, and unhide it. Go back to any cell in Schedule.xls, enter this formula, and it should show you where Schedule.xls is located:

    =CELL("filename")

    (BTW, what Custom Document Properties show in the Properties tab for Schedule.xls, and what values do they show? You may want to keep the answer to yourself.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    Thanks again hans..

    i try the method..using these :

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Automation

    and

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Safe

    when i go to vbe..its clear...teh schedule.xls is not there..

    so i try open excel from my shortcut..and its there again :wink:

    i have try search for the xlt annd found it..but its empt

    i search for the schedule.xls also and find nothing..altough i have unhide all the folders in the windows..

    any more idea ?

  10. #10
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    thanks andrew for the code..

    but its still there..this thing driving me nuts...grrrrrr...

  11. #11
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    Edited by HansV to provide link to post - see <!help=19>Help 19<!/help>

    i have try all the method john even with your formula and when i hit enter , nothing came out.just empty

    i have nothing to hide, because i dont know about this code..but recently , i have try this..but it using power point..refer to this thread

    <post#=375847>post 375847</post#>

  12. #12
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    What happens if you run the following ?:

    Sub ShowWorkbookName()
    MsgBox Workbooks("Schedule.xls").FullName
    End Sub

    Andrew

  13. #13
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    hi again andrew,

    what ever code i attach to this code in the same wb of schedule.xls , after i close it and reopened it , it will dissapear..

    i've try put your code to the wb names..Book1.xls and nothing happen

  14. #14
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: A weird problem occured to me.. (2000)

    Place all the code in a different workbook. !

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A weird problem occured to me.. (2000)

    OK, try the following:
    - Activate the Visual Basic Editor (Alt+F11)
    - Activate the Immediate window (Ctrl+G)
    - Type

    Debug.Print Workbooks("Schedule.xls").FullName

    and press Enter.
    The result should be a line containing the full path and filename of Schedule.xls.
    Select this line as a whole, copy it to the clipboard (Ctrl+V) and paste it into a reply.

Page 1 of 3 123 LastLast

Posting Permissions

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