Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: HDD names in XP mode and excel 4.0

22 Jul 2011   #1
Abudirk

Ultimate x64
 
 
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 System SpecsSystem Spec
.

22 Jul 2011   #2
strollin

W7 Ult desktop, W8.1 laptop, W7 Home netbook, W8.1 tablet, Win 10 TP VM
 
 

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 System SpecsSystem Spec
22 Jul 2011   #3
Abudirk

Ultimate x64
 
 
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.
My System SpecsSystem Spec
.


22 Jul 2011   #4
Ztruker

Windows 8.1 Pro X64
 
 

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 System SpecsSystem Spec
23 Jul 2011   #5
Abudirk

Ultimate x64
 
 
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 System SpecsSystem Spec
Reply

 HDD names in XP mode and excel 4.0




Thread Tools





Similar help and support threads
Thread Forum
Does Windows save logs somewhere that shows folder names / file names?
Probably it doesn't and my question is a long shot - but I recently toasted a drive, and it had many folders and files which I have little memory of. I also never used one of those nice apps that makes a list. Any help appreciated. Much obliged. Tt
General Discussion
All excel files opening in read only mode in Windows 7
in windows 7, when i open any excel file from any folder (network & desktop both), it opens as read only.. but when i open the excel file by going to open option in the Menu Bar in MS Excel, it opens correctly.. but that takes hell lot of time everytime i wanna open a excel file.. :mad: can...
Microsoft Office
BSOD d1 when coming out of sleep mode, + possibl excel. Lapt restarts.
Hi! :) I am new to the forum but I hope that you will help me with my BSOD problem. Last week I got the first BSOD when I was working and testing VB/macros in Excel, and the laptop (Asus U46S SSD) restarted itself afterwards. The same thing happened this week, but now as it was when coming out of...
BSOD Help and Support
Microsoft Office Outlook 2007 - Change middle names to last names
Hello everyone, I need a help regarding the contacts being synchronized with Outlook. All my contacts have their first names under 'First Name', but their last names under 'Middle Name'. I want to copy the middle names of everyone to the 'Last Name' box. Can anyone please help me on this. There...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office

Our Sites

Site Links

About Us

Find 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 04:40.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App