Solved HDD names in XP mode and excel 4.0

[Abudirk]

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?

 

[strollin]

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?

 

[Abudirk]

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.

 

[Ztruker]

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:

 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.

 

[Abudirk]

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.