Over 1 million tech questions and answers.

Folder inside drive will not open - telling me to format entire drive..

Q: Folder inside drive will not open - telling me to format entire drive..

Hey any help would this would be GREATLY apprciated.

One of the hard drives on my pc [250gb drive , drive E:\] has about 180gb of that data inside one folder. Today I went to open the folder and the pc locked up for a second and then said that DRIVE E:\ is not formated and asked if I wanted to format it. If I select no and try to access the folder again it does the same thing. I cannot risk loosing any of the data that is inside this folder on this drive. IF anyone could try and help me access the files inside this folder I would be so appriciative!!!

Someone please help....


btw...

All other folders on the drive open just fine...

RELEVANCY SCORE 200
Preferred Solution: Folder inside drive will not open - telling me to format entire drive..

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Folder inside drive will not open - telling me to format entire drive..

It also says that there is 0 bytes in the folder when there should be over 110gb ...

Is there any sort of program that will repair something like this...

When I right click the drive in my computer and check properties it says used space 184gb...but then when I go into the E:\ drive and select all the folders and select properties it says there is only 74.2gb used ?

The other 110gb is in that folder that I am not able to access....

Read other 1 answers
RELEVANCY SCORE 123.2

Hey any help would this would be GREATLY apprciated.

One of the hard drives on my pc [250gb drive , drive E:\] has about 180gb of that data inside one folder. Today I went to open the folder and the pc locked up for a second and then said that DRIVE E:\ is not formated and asked if I wanted to format it. If I select no and try to access the folder again it does the same thing. I cannot risk loosing any of the data that is inside this folder on this drive. IF anyone could try and help me access the files inside this folder I would be so appriciative!!!

Someone please help....
btw...

All other folders on the drive open just fine...
 

A:Telling me I need to format drive to open folder??...

This has to be one of the wierdest things I have seen....only thing I can think is that the drive has gone corrupt...but I dont understand why its just that one folder and not the whole drive...

It also says that there is 0 bytes in the folder when there should be over 110gb ...

Is there any sort of program that will repair something like this...

When I right click the drive in my computer and check properties it says used space 184gb...but then when I go into the E:\ drive and select all the folders and select properties it says there is only 74.2gb used ?

The other 110gb is in that folder that I am not able to access....
 

Read other 3 answers
RELEVANCY SCORE 88.4

os: vista
very strange problem.

i have a folder on my desktop that used to be called "c++ programs" and has since been renamed to "goaway" (since it won't)

inside this folder which is located at C:\Users\bert\Desktop\goaway is a folder called C:

when i click it it brings me back to just C:\ - it acts like a shortcut - but it isn't! its my actual C drive. when i try to delete "goaway" it starts to send terabytes of data to my recycle bin. i CANNOT delete this folder! when i try, it will delete all that stuff and wipe most of the stuff from my C drive (which is.. uh.. important).

i went to cmd and cd'd to ~/goaway, and pressed Dir thinking its some sort of weird linking problem. heres a ss of the results:

http://i25.tinypic.com/2mcg1t1.jpg

(don't know why the image is all weird, thats just what tinypic did)

can anyone help me delete this forsaken folder? please help!
 

A:C drive located inside folder INSIDE C drive - can't delete

Read other 10 answers
RELEVANCY SCORE 87.2

I want to add parameters to the script, such that only a new folder is targeted, instead of every folder in the drive.

The script is at post #4 here.

strFirstDrive = "E"
strLastDrive = "N"
strSavePath = "C:\Test\Index.docx"
Const ShowDoc = True
Const CloseDoc = True

Only 1 drive will be read, so I can change first + last drive accordingly:

strFirstDrive = "J"..................."J:\FolderName" maybe???
strLastDrive = "J"
strSavePath = "C:\Test\Index.docx"
Const ShowDoc = True
Const CloseDoc = True
 

A:Modify a VBS script to target folder within drive, instead of entire drive.

Read other 8 answers
RELEVANCY SCORE 86

Evening all

I recently purchased a Hitachi 250 GB drive. I have all kinds of things on it, including films for my son, photos, music and most importantly files containing assignments for a course I am completing. (Yes I know the latter probably shouldn't be on there, but my son has the knack of deleting things and is a whiz for an 8 year old. He has aspergers and computers is one of his 'special interests' and he has managed to override every type of security I have put on so far and I have tried a few e.g. cracking my password, going into control panel and turning it off and making himself an administrator and setting parental controls up for me, or pulling the battery at the back!! )

I was trying to play a film for my son (Dumbo, which is what I now feel like) and it wouldn't load. I tried a few times and it then came up with scan files and fix errors so I said yes. Since I have done this it doesn't recognise the drive at all and says that it needs formatted. I don't know much, but I'm guessing that if I say yes it will wipe everything, so keep cancelling it. I have tried going into properties on the F drive and setting the sharing to everyone but it wont work as the drive needs to be formatted first.

My brother (who set it all up for me before he left the country) has suggested I try connecting it using a different USB port, but it didn't work.

Just wondering if anyone has any ideas as to how to solve this, bearin... Read more

A:Laptop is telling me I need to format my drive and its already formatted

I take it this is an external drive yeah?

First thing to check, is the drive plugged into another computer. I sometimes have this issue with my SD cards from my digital camera in Windows7. If I boot into Linux it works immediately without any issue whatsoever.

It sounds to me like it was disconnected in the middle of a read/write operation and as such, something has corrupted, and is making the disk act like it needs formatting.

It is most likely a boot sector problem, which is very hard to resolve in most cases. Given that you've made no comment about backups, I'm guessing you have none.

You can try one of two things in my opinion:

1. Click this link, read the information here and use the software to fix your boot record. You accept the risks, and if you lose data its not my fault.
2. You can download a copy of Ubuntu, which is a Linux operating system, and burn the image you download to a CD. You can then use the disc to boot into Ubuntu, and if your lucky you can mount your hard disk that way, and then simply copy all the data over to your laptop hard disk, then boot back into Windows and format the hard disk, and copy the data back over once again.
3. There is a third option, but not really recommended by me... that is to format the hard disk, and then immediately run a deep scan using Recuva to recover the previously lost data. Its pretty effective, but its likely you'll lose something - Its also crucial you do not write anything to the disk once you&... Read more

Read other 1 answers
RELEVANCY SCORE 81.6

Virtual Hard Drive requires to format while creating, will that format the entire disk drive partition also?
 

Read other answers
RELEVANCY SCORE 78.8

Is there a method to link my entire C:/users folder to another drive with out the need to reinstall anything and have things work perfectly as the way they were? What I want is all the read and writes to be done on another drive.

A:Is there a way to link my entire C:/users folder to another drive?

This should help you out,

User Folders - Change Default Location

Read other 7 answers
RELEVANCY SCORE 78

Hello all,

Does anyone have the "How to" on moving an entire folder from your Microsoft Outlook 2000 inbox to your hard drive. I know how to move individual emails, just wondering if anyone had info on how to move entire folders at once...

thanks in advance...
 

A:How to move an entire folder from your inbox to hard drive

Read other 6 answers
RELEVANCY SCORE 74

Hi, I was wondering if anybody had any suggestions on helping me troubleshoot my dvd-drive.
If there is a disc inserted then the drive will open without a problem, but if the drive is empty and closed it won't open, the lights will flash, and it will make a clunking sound but thats all. I've tried reinstalling the device in device manager, no difference.

When a disc is in, it reads without any problems, its just getting it open. We need to use the emergency pop-out on the front of the drive (ejecting the drive in windows doesn't help either)

It is a Samsung TSSTcorp CD/DVDW TS-H552U writer, and i'm running XP home on it.

Please, any ideas?
 

A:Dvd Drive won't open without a Disk inside?

This usually happens because people close the drive by pushing the door, instead of using the "OPEN / CLOSE" button on the front. Eventually, the gears which drive the door to open and close it get damaged or misaligned. You MIGHT be able to repair this by disassembling the drive (usually EASY to disassemble if you know how, DIFFICULT if you don't), but that is probably a waste of time. The gears are plastic (to save cost and weight, and to reduce noise), so even if you got the drive apart, getting everything synchronized and properly aligned would be very difficult, IF the gears were not worn or damaged.

Best bet is simply to replace the drive; I dislike suggesting that people spend money on ANYTHING, but in this case, the deck is stacked against you.
 

Read other 1 answers
RELEVANCY SCORE 72.4

Changing entire ownership of entire hard drive any risks etc ?

I am using method of

Right click entire hdd

Properties
Security
Advanced
Change owner
Advanced
Find now

Name - In Folder
Users - Computername(mine is for example Furkan)
Ok this makes me even able to enter inside of System Volume Information folder

Can this cause any problems in future?

For example if i format windows can i still access these harddisks without any problem ?

Are there any details, detailed information, article about ownership of files / folders on windows 8 ?

ty very much

Windows 8.1 x64
Also changing windows having driver - boot driver ownership from Trustedinstaller to user would cause any problem ?

A:Changing entire ownership of entire hard drive any risks e

When I took ownership of C:\ There were numerous popups saying it was unable to take ownership of various folders & subfolders.

Read other 6 answers
RELEVANCY SCORE 70.4

Hello guys,

I have s flash drive USB with stored files,
today inserted in the PC trying to access some of the folder,
but I noticed something strange, under the name of the USB, i seen (FAT32)
and when tried to click to open the drive, always seen this message:
(You need to format the disk in drive K: before you can use it.)

I tried several times, but useless,
I worry if I accept to format, all files will be erased,
what this request to be? I used to check it many times, but the last time used was a year ago,
what can I do? any advise will be highly appreciated,
thanks.
 

A:How to open the USB drive with out format it?

I would advise trying the drive on another PC, to determine if you can read the files there.
 

Read other 2 answers
RELEVANCY SCORE 69.6

Hi all , been using XP Pro for a while and after some update? whenever I plug in a flash drive I get a notice that says Drive needs to be formated . This is nuts because drive will work fine in several other PC's . USB ports are fine , I have printers and scanners pluged in to them . I have swapped out HD for and older version of XP home and all works fine . This tells me that some software glitch in a update is doing something so I cant read the flash drive . Any Ideas ????????
Thanks , Michael
 

Read other answers
RELEVANCY SCORE 69.6

Ok after figuring out that I had a bad motherboard. I have now went to install my WD 120JB 8meg cache hard drive into the computer and format using windows 2000 (brand new out of the wrapper). When the bios boots it recognizes the entire 120 gig which is what I had expected, when I boot from the cd to format using NTFS filing system it says that there is only 114470 meg on disk, I ran WD's software on it with no luck and have already flashed the mobo's bios.

I figured that I would try to format with windows 2000 to see if it made a difference it didn't! it actually froze at 97 % complete. I reran the WD software but this time downloaded it fresh and ran the utilities on it where it said there were errors on the disk. when I finally gave up on it last night (@ 1000pm) to come home, I left it writing zeros to the full drive.

Any suggestions would be REALLY APPRECIATED at this point.
 

A:120 gig WD drive with 8 meg cache not finding entire drive space

The manufacture is figuring 1000 bytes=1 kilobyte, but your PC is figuring 1024 bytes per kb.

I'm bad at explaining things, this article does a better job:

http://www.anandtech.com/guides/viewfaq.html?i=136
 

Read other 3 answers
RELEVANCY SCORE 68.8

i need the info off of my drive but i cant even open it, it keeps telling me to insert a disk into its drive. i cant even format it, it says "there is no disk in drive y:" i've also tried to change the drive letter (which is why it is Y) still didnt fix it. i know if i finally can format it i can still use my recovery tool to find the document" SOMEONE PLEASE HELP ME!!!!!!
 

A:jump drive is installed yet i cant even format or open it!!!!

Find the drive in "my computer"
Right click it and click eject.
Remove the drive and restart the computer.
Try again.
This can happen when the drive is improperly removed
or left connected when the computer is restarted.
 

Read other 3 answers
RELEVANCY SCORE 68.8

Gday,

i have taken my 120gig western digital hard drive from my Xbox Original and wired it to my pc. i have been able to assign a drive letter to it but before i can open it it wants me to format it. This is bad because i want the stuff i have stored on there. also i am unable to tick the box that says Best run for easy removal and the box Best run for optimun performance is selected.

i have tried numerous things and would appreciate any thing any one can tell me on this issue!

thanks heaps

peace.

A:Why Must i Format a hard drive before windows will let me open it??

Tell me how you have it hooked up. How is it jumpered, what else is on that ribbon cable, and where is it on the ribbon cable (middle or end)? It is important that we know if anything else is on the same ribbon cable if a WD drive.

Read other 7 answers
RELEVANCY SCORE 68.4

I have a z575 with a SSD divided into a c drive and d drive. I just formatted the c drive assuming I could leave the d drive intact with the data. when I try a fresh install on the c drive with a Windows 10 disc, I get     Recovery     Your PC Device needs to be repaired     A required device isn't connected or can't be accessed.     Error Code: 0xc000000f      Press Enter to try again     Press F8 for startup settings Enter does nothing.F8 does nothing.Each time I reboot hoping to snag the dvd drive, I get immeditatly sent to the Blue screen above. Should I be able to install windows 10 to the c drive regardless of the d drive?I have been running Windows 10 with no problems other than a long lag on boot up, I think because of an old Windows 7 installation. Any insight would be appreciated!Thanks!

Read other answers
RELEVANCY SCORE 66.8

I want to prepare a factory fresh drive so that I can use it to save backup images. Soon I will have a second drive that will only be used to store data files. Neither drive will ever be used for the installation of an operating system. From what I've read, I see no advantage to having more than a single partition on either drive. I know I want to use NTFS.

This should be straightforward. I'm finding it is not. I cannot formulate a search that points me to the right tutorial or thread. Either I get hundreds of options to consider or, if I try to narrow the options, no answer is found.

Please point me to the right discussion. Perhaps the answer will help others who come after me, too.

thanks

baumgrenze

A:Format & Partition New Drive to Use as a Backup Drive or Storage Drive

Do you know how to make a partition and format a drive?

You can do it all in Windows Disk Management.

You don't need to do anything special to the drive just because it is going to store images.
Treat it like any other drive.

Format it with a single partition.

Store your image files on it. Use a folder structure if you want to---perhaps naming a folder something like "Macrium image of C partition, 060714" so you know the date of the image.

Nor do you need to use a separate drive just for image storage.

Make your images and store them like ordinary data. Back up the images just like you'd back up any other important data file. That's what they are: important data.

Read other 9 answers
RELEVANCY SCORE 66.4

I cannot open any folder from the the c: drive or anything, my computer or control panel nothing is working if a click them and it frizzes for a long time.

The only thing that i can do is log on internet and i can use word or excel and run other programs like virus scan zone alarm but nothing found (virus).
I restart, cold start, safe mode, try to do a restore, nothing. Also Is not accepting privious restore point.

I have windows xp pro.

Thank you
 

A:I cannot open any folder from the the c: drive

Please do not create multiple threads for the same problem! Read >>Posting help read first<< if you feel you are not getting help.

Continue here: http://forums.techguy.org/malware-removal-hijackthis-logs/738141-please-help-fix-alcxmntr-exe.html
 

Read other 1 answers
RELEVANCY SCORE 65.6

When you try and open up the DVD-CDR drive it won't open, to show me wants on the disc anymore..This started today...It might be because i upgraded to Media player 10.0..That is the only thing that has been put on my computer in the last couple of months..

What i'm saying is when you right click on your disc drive and try to click on open..Nothing happens and it also says that the disc has 702mb free space.

What do i try and do to get the computer back so i can open up my disc folder again

I can play CD's Games, DVD's and mixed disc's that i Burned(Photos mpeg's).

Just can't click on the open , so it shows me the folder on the disc.

I did a system restore and it Drive worked fine after that..But the restore messed up some of games that i play(New files and editing)So i had to restore back.I did notice that I did also update my Musicmatch program too.

So this problem must be in the settings for the drive or something like that.

Thank You for help

I hope someone knows how to fix this problem
 

Read other answers
RELEVANCY SCORE 65.6

Hi All,

I have 4 harddrives and I want to move the entire content of one drive (it use to be the main drive with OS) onto another spare drive. So this is from one spare drive to another. However, if I select all the files 120GB and drag them over to the other drive it only copies 8 GB.

Why is this and what might I do about it?

Thanks
 

A:Move entire drive from one drive to another

Read other 8 answers
RELEVANCY SCORE 65.2

I use the external for backup and I have a critical folder with a couple of years of backups that I can't open.

There is only one user defined for my Windows 7 PC and it has administrator privileges.

I might have directly accessed the drive from a laptop that is part of my Workgroup.

Can someone help, please?
 

A:Solved: Can't open a folder on an external drive

Read other 9 answers
RELEVANCY SCORE 65.2

Hi there good people of TSF...

Recently I was playing with My computer's Folder Tools and properties cause I was trying to choose an Icon for a specific folder, but failed. After that I went to My computer and clicked on C or D drive but when I do that , instead of showing the contents of the folder, the 'Search Results' window pop-ups. I dont know how i changed this and how I can fix it. Would appreciate your help.

A:Problems With My Computer Folder - Can't open C Drive

There should be a button in the folder options to "Restore Defaults" on both the General and View tabs.

Read other 5 answers
RELEVANCY SCORE 65.2

Hi
I'm having a bit of a problem. when I right click on my DVDrw Drive I can't view or explore the drive as a folder. i have tried to use the open , or open in a new window from the drop down right click menu but nothing the my computer folder flashes once and no new folder is opened. when i try to expand the dvd drive in explorer by right clicking it, the expand option is greyed out.
I thought It might be a hardware issue but the drive will still play dvd's cd's etc and run executables through autoplay. it just wont let me explore the drive as a folder
I'm running Windows7. my dvd drive is relativly new panasonic.
Please Help!!

A:Can't explore expand or open dvd drive as a folder

This workaround won't resolve your problem, but you can try it in the interim.
Have you tried typing the letter of the drive in the address bar? For example you'd type C: where you normally see "My Computer", but instead type the letter of your DVD drive (D: E: F: or whatever).

Read other 17 answers
RELEVANCY SCORE 64.4

hello, sir
i want when i open a drive eg. "c" drive

then disable the folder option automatically in windows xp, 7, 8

thanx

A:when i open a drive then disable the folder option automatically

Not an easy task. I don't think possible.

Read other 1 answers
RELEVANCY SCORE 63.6

Hi,

I have win 98 se - legal, and a legal upgrade to win xp. The computer was working fine, until a frined used it for about a week. When It came back it would not load at all. No need to say that I was really angry and that she will never ever in a snow days in you know where, use my laptop again.

It wouldn't even load into safe mode. Nothing.

I reformated the had drive, then I installed win 98 again, it seems to install fine. When the program went to load it told me there wasn't enough memory to load win 98. I could not start it in safe mode.

I reformated the hard drive again and also, went out and purchased a legal copy of XP. Thinking there was something wrong with the win 98 program. Even though, it was on there before and I used the upgrade before.

Now, it does 2 things:

1. When it loads it tell me:

Microsfot(R) Windows 98
(C) Copyright MIcrosfot Corp 1981 -1999

c:\>



when I type in DIR I get:

Volume in drive C has no label
Volume Serial Number is ......not typed..
Directory of C:\

Command Com 93,890 04-23-99 10:22p
1 file(s) 93,890 bytes
0 dir (s) 190,732.63 MB free.



or

2. f I boot from the dvd rom

It looks like it is installing xp to a point, then it tell me there is no hard drive.


----------------



Any advice you could give me would be greatly appreciated.

A:Re-install of xp telling me no hard drive

the initial load goes into ram and it hands over to the hard drive on the first reboot

can you see the h/drive listed in the bios

d/load and run the h/drive makers diagnostic utility on the h/drive

http://www.tacktech.com/display.cfm?ttid=287

if it comes up clear of problems

clear the h/drive with killdisk then format and install with the xp disk

http://www.killdisk.com/downloadfree.htm

Read other 17 answers
RELEVANCY SCORE 63.6

I took out my Windows 7 boot drive and put it inside of a USB enclosure and when I try and go to my profile, I can't open Users folder on other computer. I don't have an administrator account on this other computer. Is there any way to open up the folder? Any tips?

It just says access denied when I try and open it up on a windows xp computer with no ADMIN privileges (I can't get admin on this computer). On a XP computer that has admin it opens fine. I figured since I actually wasn't using the OS that was on the drive I wouldn't have any trouble reading any folders on it (but I guess that because it's NTFS there are more security measures, unlike FAT32 which would let anybody read anything).

Would I just need to open up the folder on a computer with admin and then copy the things over while I still have admin?

Thanks for any / all help.
 

A:Put Windows 7 drive in USB enclosure and can't open Users folder on other computer

Read other 6 answers
RELEVANCY SCORE 63.6

I recently bought a second internal dvd drive, physically installed it, plugged it into the last remaining SATA port on the mother board.

When I inserted a data dvd, autoplay popped up giving me one option - to open folder to view files with Windows Explorer. When I clicked that option nothing happened.
When I insert a blank dvd, Nero opens its burning app as it is set to and I'm able to burn a dvd on that drive. Nero is also set to verify the compilation which it does with no problem.
When i reinsert the same dvd, the same option pops up with the same result - nothing.
When insert an audio cd, Winamp will play the cd but I'm not able to "open" the cd with Windows Explorer.

By trying all combinations of cables and dvd drives to make sure that both the cables and drives were working properly, I determined that whatever drive was plugged into that last SATA port would not function properly.

The only options in my BIOS that I could find referring to SATA drives was to enable or disable the SATA controller.

I'd really like to have both dvd drives fully functional and any help would be greatly appreciated. Thank you.

A:DVD drive will not open folder to view files with Windows Explorer

First of all explain in detail...

1.DVD Drive is visible in My computer?
If not so remove the dvd drive and reconnect to system.

2.Can you eject automatically the DVD from my computer Through eject option?

3.Can you eject manually??

4.Can you View files and folders in drive?

Read other 4 answers
RELEVANCY SCORE 63.6

Truly had a hard time trying to describe a proper title.
Here's what I mean. Since I got this computer 3 years ago and along it Windows 7 I had this problem and questioned if it was a normal Win7 thing or not.
I turn on the PC and, for ex., I go online. This means I am presently working on my C: drive since that is where my OS sits and along it my Browser. But at one point, say 15 minutes later I want to open a file/folder which happens to be on a different drive, D:, E: whatever. Well at this point I hear coming from my computer, sitting below me, the drive begin to spin-and I need to wait from 5 to 10 seconds before I see anything on the screen--Windows Explorer. Is this normal or what? If not, what is going on exactly.
At this point, afterwards the folder siting on the drive takes no time to open, or a new folder or whatever but if I wait a while, say 30 minutes and then decide to open another folder sitting on another drive the same thing happens

A:Folder on unused drive takes 5 to 10 seconds to open, is this normal?

Hello pintree,

Yes, this is normal when you have Windows set to Turn off hard disk after X amount of idle minutes instead of "Never". If you like, the tutorial below can helps how you how to set this to "Never" to no longer have your hard drives turn off.

Hard Drive - Turn Off Hard Disk After Idle or Never

Hope this helps,
Shawn

Read other 3 answers
RELEVANCY SCORE 63.6

It only happens when I open the Downloads folder from Quick Access and This PC.

I've already checked the Folder Option. Launch folder windows in separate process and Open each folder in its own windows both are unchecked

and I also tried everything that I've found, but nothing works

A:Folders inside Downloads folder open in new window

Run sfc /scannow in an elevated command prompt. You may have some bad system files

Read other 0 answers
RELEVANCY SCORE 63.2

I am running Windows XP professional on a hp elitebook 6930p with a 150 gb hard drive. All my music, videos, documents, design files for school, basically the files that take up any signifigant amount of space is in 'my documents' and this folder is at 70 gb. I dont play games and dont have movies stored on my cpu, but I do burn them to dvd and and then delete then. About a month back I became infected with antivirus 2010 and other subsequent malware infections, and this is when I started getting warnings that my disk space was getting low. I have since used these forums to clean the problems, however my hard drive is still completely full. I have deleted all old restore points, cleared the system logs, checked disk for errors and defragged, but it has freed up no space. So, I am just wondering how I can get a breakdown of disk usage. Is there a program for that? I don't have a lot of programs or play games, so it is impossible for my hard drive to be full...Any ideas??

A:CPU telling me hard drive is full...Impossible

Download, and install Disk Space Reporter: http://www.softpedia.com/get/System/System...-Reporter.shtml

Read other 11 answers
RELEVANCY SCORE 62.8

Hello,

I'm working on an Excel project. I need a Macro to find duplicate values in Column D and when a duplicate is found, format the font color and fill color for that row, column A thru E. Any ideas?

What I currently have finds the duplicates, but only contionally formats items in that column. I don't want it to be conditional, but here is what I'm using:

Private Sub btnDuplicates_Click()
Columns("D:.D").Select
Selection.FormatConditions.AddUniqueValues
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
Selection.FormatConditions(1).DupeUnique = xlDuplicate
With Selection.FormatConditions(1).Font
.Color = -16383844
.TintAndShade = 0
End With
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 13551615
.TintAndShade = 0
End With
Selection.FormatConditions(1).StopIfTrue = False
Range("E2").Select
End Sub

Any idea how to do this?
 

A:Non-Conditional Format: Duplicates Values in 1 Column Format Fill and Font Entire Row

I got rid of the conditional formatting you recorded, because I thought the best way was to loop through the cells in the column and try to find them in the range above and below, and it found them, to format the range of cells from A:E associated with the cells. The problem with using conditional formatting is that you can't loop through cells containing a certain format, because the cell object is not actually formatted. I hope this helps...
Code:

Sub Test()
Dim cell As Range, strValue As String
For Each cell In Range("D1:D10")
strValue = cell.Value
Select Case cell.Address
Case Is = "$D$1"
If Not Range(cell.Offset(1, 0), cell.End(xlDown)).Find(strValue) Is Nothing Then GoTo Format
Case Else
If Not Range(cell.Offset(-1, 0), cell.End(xlUp)).Find(strValue) Is Nothing Or _
Not Range(cell.Offset(1, 0), cell.End(xlDown)).Find(strValue) Is Nothing Then GoTo Format
Continue:
End Select
Next

Exit Sub
Format:
' you can obviously change this to suite your needs
With Range(cell.Offset(0, -3), cell.Offset(0, 1)).Font
.Bold = True
.Size = 10
.ColorIndex = 16
End With
GoTo Continue

End Sub
[\CODE]

 

Read other 3 answers
RELEVANCY SCORE 62.8

I have a very straightforward question: I am running WinXP Pro on my computer and I just got an external USB hard-drive to back up my data before I upgrade to VISTA.

My internal hard drive is NTFS file system, and the external drive is FAT32. My data backed-up perfectly.

However, I understand that VISTA is NTFS only (for the drive that it's installed on, which in my case will be the internal drive). I will be installing the VISTA OS on the internal drive, and using the external drive solely for backing up data.

I don't want to back up my data externally, upgrade my PC to VISTA, and then discover that I can't access the data on the external drive.

Here's my only question: will VISTA work with a FAT32 external drive, or do I have to convert that external drive to NTFS *before* I attempt to connect it to VISTA?

awaiting your replies - I'll appreciate all the help I can get!
 

A:will VISTA read a FAT32 external hard drive,or do I have to format the drive to NTFS?

Read other 6 answers
RELEVANCY SCORE 62.4

format my hard drive for clean install of new windows 10 on flash drive

Read other answers
RELEVANCY SCORE 62.4

i go into device manager and i see tsstcorp cd/dvdw ts-h652m .however device is unable to play any cd ,dvd or burn.problem also with usb2.0 drive says unable to format and cannot display any files however it does work on any other pc.I would appreciate if someone can help me resolve this.this forum is great by the way I didnt know barely how to turn on pc and thanks to this forum I AM MORE KNOWLEGIBLE ABOUT PC.THANKS IN advance.

A:my disk drive tsstcorp cd/dvdw ts-h652m also usb drive says unable to format

Uninstall the cd/dvd drive from Device Manager and restart Windows.

After Windows restarts the drive will be reinstalled.

If still having issue try the solution here

Read other 3 answers
RELEVANCY SCORE 62.4

Hey Guys,

I have a netbook which I want to recycle however it has been used for business purposes and I want to properly format the drive. The issue I have is that it does not have a CD drive nor does it have a working screen. I have connected the hard drive to external display and manually deleted all files from the computer but I know this is not really 'deleting' anything.

How can I format the drive from within Windows? Unfortunately I cannot get bios to display on the external display so I can not do anything from DOS or Bios simply because I can't see anything!

My latest attempt has been to use Active KillDisk to create a bootable USB however this is when I ran into the issue of the Bios and DOS not displaying, it will only display once windows has been loaded.

Any ideas?
 

A:Solved: Help needed to securely format hard drive - no screen or CD drive

Read other 7 answers
RELEVANCY SCORE 62.4

Something keeps popping up telling me my hard drive will fail.
"Microsoft windows" your hard drive will fail please replace hard drive"
I have had my computer for years and its been saying that for a long time and it hasnt happend yet. I blocked it from popping up before, but now that I reformatted my computer its happening again. How do I keep this from popping up?
 

A:Microsoft windows telling me my hard drive will fail

Read other 15 answers
RELEVANCY SCORE 62.4

Hey, My computer has been saying that my SMART disk check has detected an iminent failure.  I want to know how to return my laptop back to normal. thank you.

Read other answers
RELEVANCY SCORE 62.4

Hi everyone:

I am new to VB. I have a code that goes from Excel to a specific page in Adobe (which ends up opening it in IE). Problem is that I need it to be able to go on different computers so I am trying to figure out how to tell VB to get the file from the USB flash drive. Every flash drive comes up different on every computer.

Here is my code:
Sub TestPDFlink()
Dim IE As Object, strFile As String, iPageNum As Long
strFile = "F:\folder\nameoffile.pdf"
iPageNum = 125
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate strFile & "#Page=" & iPageNum
IE.Visible = True
End Sub
So, where do I tell it to go to whichever drive the flash drive comes up as (E:, F:, etc)? Any ideas?

Thanks!
 

A:Telling excel to go to a specific page in PDF on a FLASH drive

Read other 6 answers
RELEVANCY SCORE 62.4

Hi everyone,

I recently accidentally formatted a hard drive. So, I quickly install a file recovery software (EaseUS Data Recovery). Then the result shows that most of SWF files are big in size. I think that lots of my files have been converted or combine with other files. So, how do I recover my files?

A:File format changed into other format after format a hard drive

This may not be the best answer, but I would recover the files first. That is you biggest concern right now. Then try to see what you need to do to fix them.

Read other 4 answers
RELEVANCY SCORE 62.4

Other than TestDisk, what are some other free software downloads that
a person might try to recover data from a formatted drive? The drive was
formatted by accident.

This addresses an issue form one of my previous post but I have not
had any luck with TestDisk.

Thank you,
 

A:Free Drive Recovery programs for accidental drive format.

Please don't post duplicate threads. If your thread is in an inappropriate forum, please report it and a moderator will move it.

Continue the problem resolution here: http://forums.techguy.org/business-applications/871411-possable-recover-formatted-drive.html
 

Read other 1 answers
RELEVANCY SCORE 62.4

The other day i went to format a partition(called drive D) of a hard drive in dos mode. Just after i pressed enter for the format to begin i relised that in dos my partitioned drive D was actually called drive G and my other hard drive which was drive E was called D, so I was actually formatting drive E. I quickly pressed restart and once in windows tried accessing drive E but it wouldnt let me because it sais it needs to be formatted because it hasnt got a File System. Ive used getdataback to access it but I want to know if there is a way to give the drive a file system name without actually formatting it?
 

A:Hard drive problem.. Cancelled format now cant access drive

Read other 6 answers
RELEVANCY SCORE 62.4

Hi,I am using a windows xp sp2 and a HL-DT-ST DVDRAM GSA-H42N cd/dvd driveThe problem is my cd drive is sometimes detecting the contents of a cd and sometimes not. I am not even able to find the pattern because the same cd when i insert it into the drive at times it shows the content and at times not.I want to format only my C drive using the windows xp cd. But the problem is when i am trying to boot from the cd, the os is not able read from cd.I checked the bios boot priority configuration and it is set to cd/dvd first.what is the other way of format my c drive other than by booting from cd ?i copied all the contents of the "windows xp installation disk" onto my usb flash drive and wanted to setup windows xp.when i double clicked on "setup.exe", i was able to go to the blue screen which had options of "collecting information, dynamic update, preparing installation, installing windows, finalizing installation". the problem is ..it has not asked me whether to just format c or format c,d,e drives.what will happen if i go ahead and format. will i lose all my data in d, e, f drives also..or by default it just formats c drive even if it does not ask us ?I am actually facing all these problems bcos...my pc is not booting from my cd.Please help me with answers.thank you

A:cd drive not reading contents of disk and does xp installation just format c drive ?

Hi,

When this happens can you eject the cd? When it doesn't read it does it still sound like it is being read in the cd drive?

Read other 6 answers
RELEVANCY SCORE 62.4

Hi,

I have an anternal media drive whith a number of hidden partitions which do not show up in windows. One of these partitions had become corrupted and unuseable and I would like to try re formatting it to fix the error.

In Partition Magic there are a number of drives listed. Some of the drives on the partition have assigned drive letters but the one I want to format has is greyed out and listed with a * infront of it. Partition Magic will let me enter the drive to view details and even gives me the option to format it BUT then wants to assign the drive the letter A:

If I do this then the media drive will be unable to work as it will have lost the file path it needs to record on to. I just wnat to re format this drive (with whatever freeware) and have the drive letter (wich is currently unassigned) untouched so that the media player never knows its been formatted.

File system is FAT32, partition size is 10gb, using Partition Magic, there are 2 partitions with assigned drive letters and 3 without on the 1gb HDD.

Any help or suggestions appreciated thanks.

Read other answers
RELEVANCY SCORE 62.4

Hi. My external hard-drive stopped working yesterday. This is what's happening:

I plug it in as usual, then it says "You need to format the disk in drive F: before you can use it. Do you want to format it?".
I'm thinking it's more than likely an issue of having pulled out the usb cable without clicking 'safely remove'.

Yesterday I actually got it working again briefly by typing "chkdsk F: /R" into command prompt. Now when I do that it doesn't work, it says "The type of the file system is NTFS. Unable to determine volume version and state. CHKDSK aborted." And when I double click on F: drive in my computer it says "F:\ is not accessible. The file or directory is corrupted or unreadable".

Are there any other options besides using some sort of data recovery tool (I'd rather not do this just because it takes a long time)?
 

A:Solved: External hard-drive:...format the disk in drive F: before you can use it.

Read other 11 answers
RELEVANCY SCORE 61.6

I have a HP Pavillion laptop computer. I needed to replace my hard drive, the salesman at the store said I could buy an external hard drive and remove it from the case and use it as an internal. I did that. Now I get NTLDR is missing. I ordered recovery discs from HP but nothing happens when I try to use them. HP said I need to format the new hard drive but I don't know how. Can someone help a beginner?
 

A:Solved: how to format an external drive to be an internal drive

Read other 10 answers
RELEVANCY SCORE 61.6

I need to format my hard drive [D & C drive]

so i wanna know Will format the hard drive [D & C drive], delete the all file
in it? Like the software that i install [ C:\Program Files], will they remain there or
will be deleted?







i already make a back up to all my Document project [ on D drive as i shown above] but to be honest, i dont want the process to delete my " Program Files" folder [ C:\Program Files]& my Document project [ on D:drive]........


** I just reinstall my pc 4/5 days ago [ maybe on 20 or 21/3/2012 ]

A:Will format the hard drive [D & C drive], delete the all file in it?

Formatting a drive or partition will completly wipe it, delete everything.

Take note you will be unable to format a drive with Windows on it if you are using that installation, you need to use a boot disk. If using dual boot you can format one Windows drive from the other.

Read other 2 answers