HDD names in XP mode and excel 4.0


  1. Posts : 3
    Ultimate x64
       #1

    HDD names in XP mode and excel 4.0


    I have many excel 4.0 macro's and therefore installed excel 4.0 under Windows 7 in XP mode. However, HDD's in XP mode have complicated names (e.g. "D on xx PC") where xx is the username under Windows 7. The excel macro recognizes no such HDD names, it is used (as I am) to C: or D: etc.

    Is there a solution for this problem other then spending ages in rewriting these macro's in Virtual Basic or some other tragedy?
      My Computer


  2. Posts : 3,371
    W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
       #2

    Maybe I don't understand the qustion correctly but on my machine, the C: drive in the XP Mode VM is C:. Is it possible for you to right click on the drive in My Computer and select rename the rename it to C:? Where is it that you are seeing the complicated names for the drives?
      My Computer


  3. Posts : 3
    Ultimate x64
    Thread Starter
       #3

    complicated drive letters only in XP mode


    Thank you for your reply. In explorer in Windows 7 all drives have `normal` letters (C: D: etc.) it is only in the XP mode that the names of all drives become complicated. In fact it mentions a 3½ floppy (A: drive although I don't have such a drive on this (Lenovo W700) Laptop. Under the explorer in XP mode it reads (somewhat shortened) as follows:

    Desktop
    My documents
    +3½ Floppy (A: )
    +Local Disk (C: )
    +Repair disk Windows 7 64-bit (D: )
    +Control Panel
    +C on XX-PC
    +D on XX-PC
    +E on XX-PC
    +F on XX-PC
    +G on XX-PC
    +Shared Documents
    +XPMUser's Documents
    My Network Places
    Recycle Bin

    I have tried to rename "D on XX-PC" (intending to rename it as "D:") but the rename option remains grey (that is non accessible) when trying to do so.

    I will be grateful for other suggestions.
    Last edited by Abudirk; 22 Jul 2011 at 19:36. Reason: instead of :) some funny face appeared
      My Computer


  4. Posts : 6,285
    Windows 10 Pro X64
       #4

    Open a Command Prompt in XP Mode and try this:

    net use Z: \\hostname\sharename /user:userid password

    You must have the drive you want to access shared on the host computer.

    hostname is the name of the host computer
    sharename is the name of the share you setup on the host computer
    userid is the userid (account name) you login to the host computer with
    password is the password you login with

    My host (Win 7) computer is Dell-P370 and I setup shares for all the drives/partitons I have on it as:

    Dell_C
    Dell_D
    Dell_E
    etc.

    (ps: I also label my drives that way so they are easy to find, no matter how or where I access them)

    So, if my userid and password are owner and super10

    My command would look like this:
    Code:
     net use Z: \\dell-p370\dell_c /user:owner super10
    To detach the Z: drive, enter net use z: /d

    Put the net use command in a batch file and add a link to it in the Startup folder and it will run automatically a XP Mode boot.
      My Computer


  5. Posts : 3
    Ultimate x64
    Thread Starter
       #5

    Solution doesn't work, Excel appears to be the problem


    Thank you for your assistance. I had found also an alternative but this didn't work either as for some strange reason my excel macro doesn't wish to recognize directories or even filenames under the XP mode (mind you, this is excel 4.0 from 1992 I believe). So, now I will have to find a forum suitable to this problem. But thank you anyway.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 18:01.
Find Us