Over 1 million tech questions and answers.

Excel macro to open a file in a folder with a specific keyword in the file names

Q: Excel macro to open a file in a folder with a specific keyword in the file names


Ive been searching the net for help with this and i just cant find what im looking for.

Im still new at excel macro's so still learning everyday.

I need help to wright a macro that will search in a folder for a file with a specific keyword that can be in the file name.

example: lets say i want to open a file that is in a folder that has "leadership" in the files name.
Because i send the file to people called "leadership.xls" and i recieve files back called "copyofleadership.xls" and different other names but there will always be leadership in the file name.

Can anyone please help me with this.


Preferred Solution: Excel macro to open a file in a folder with a specific keyword in the file names

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: Excel macro to open a file in a folder with a specific keyword in the file names

Read other 6 answers

Hello all. Not a regular user of Excel; but do need help in creating something that would be useful to me and a few others at work. I suppose the best way of explaining what I'm after is by giving an example.

I have a directory C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson
In Cape Nelson are a number of folders named alpha beta charlie delta echo and foxtrot and so on.

I would like to have an excel template in "Cape Nelson" with a macro that when activated names the file as whatever folder name might be in say cell A1 and whatever ever date might be in cell B1. Eg charlie_15-mar-2013.xls
This then is saved in the relevant folder. So in the end I would end up with
C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson\charlie\charlie_15-mar-2013.xls

Also the macro script would ensure that the macro was disabled in the saved file.

Hoping this is achievable and look forward to replies.

A:Solved: Excel 2010 - Macro to name and save file to a specific folder

Read other 16 answers

Hello, I have had this problem for a couple of years now, even in a few different computers. I have a folder with files I am keeping, copying it from computer to computer when I change computers. In this folder I am unable to see folder/file names unless I mark them. This has irritated me to some extent since there are around 12-13000 files in this folder by now. I have asked around at computer-tech stores, and some of my more or less nerdy friends. One of wich is mostly always able to help me... but not with this.

EDIT: I should probably add that the same thing happens to every file or folder I add to this folder.

A:Unable to see file/folder names in specific folders

Read other 9 answers

Hi Gurus,

I have many excel files containing similar data.

1. I want to copy specific columns (columns A to U) from all files and paste the consolidated data into another excel file.

2. I also want to copy specific columns (columns C,D,E,G,H,K,L,T,V,W,X,Y) and paste the consolidated data in a different excel.

Please help.

A:Excel macro - copy specific columns from different files to one file

Are all of these source Excel files stored in the same directory? Do they need to be opened and consolidated in any particular order? More details please. If possible please try to provide a sample file with any sensitive data removed.


Read other 1 answers

Accessing a folder system that starts with with:
"W:\01. Shared folder\01. Projects\etc etc"

over a network seems to fail using the FileSearch

Set fs = Application.FileSearch: countit = 0
With fs ' this is a lookfor #1
If left(could, 1) = "\" Then .LookIn = "W:\01. Shared folder\01. Projects" Else .LookIn = "W:\01. Shared folder\01. Projects\Archive"
.SearchSubFolders = True
.Filename = "-000"
If .Execute() > 0 Then
For i = 1 To .FoundFiles.Count
t = InStr(.FoundFiles(i), "\Drawings")
If t > 0 Then countfirst = Mid(.FoundFiles(i), t + 1): possibles.AddItem countfirst: countit = countit + 1:
Next i
MsgBox "There were no files found."
End If
End With

basically with ". " in the folder name it fails. I can do nothing with the folder system - it is set by people who can't program and think it is stupid to.

I have tried a trailing "\" and %20 for space and similar for the dot.

Any ideas round this.

I have succeeded with ChDir & ChDrive & Dir but to find all instances of files with the specific file identifier ("-000" say) would require a lot more programming and I may just have to do this.

Win XP, Excel 2002/3 (network or USB stick makes no difference).

A:Excel file VBA search with odd folder names???

Here's a kludge... a cumbersome, inelegant workaround.

Rather than asking the system to search for a name (that it doesn't like), you tell it to tell you all of the names it has and then you stop when you find the one that matches what you want.
In other words, rather than searching for a specific file/folder name start at W: and iterate through all the child folders. When you find one that matches the name you want, then iterate through all of it's children again until you find the one with the name matching etc down to the actual file you're looking for.

I know... awfull, time consuming terrible practice, etc but might be the only way to get what you need until you can convince them to change the folder names.

Read other 3 answers

Can someone tell me what I need to do to have a macro in excel, open another file?
For example, I need the following file opened:
How do I do this, and also, at the end of the macro, I want that file closed. Please help!

A:VBA Code to open file in Excel Macro

Give one of these lines of code a shot...




What are you going to do with the spreadsheet once opened?

Read other 2 answers

Is it possible to sort a folder's contents with both File names and Sub-Folder names intermixed?
I have projects in sub-folders, and 'support' files like this:

projabc (sub-folder)
projabc.txt (file)
projabc.bat (file)

amongst other projects.
I would like all the 'projabc...' items to appear together.


A:File Explorer Sort File names With Sub-Folder names

I don't know of a way to get Windows Explorer to do it. But XPlorer2 is supposed to have that sorting mode.
Edit: scroll down to "Folders sorted" in the table.

Edit2: Here's a Tutorial how to disable auto-arrange in W8:
Windows Explorer Auto Arrange - Disable in Windows 8

Read other 1 answers

Good Evening,

I am trying to save a workbook using a macro, but I can not get it to save in a folder called Sugar_cookies. It just saves in the specified drive. Any idea what I do wrong?

ActiveWorkbook.SaveAs Filename:= "N:\Sugar_cookies" & DateDay & addinfo

Thank you,

A:How to save excel in a specific folder using a macro

Read other 6 answers

I am trying to write a batch program the list the current directory files that end in *.dwg
into a file on my C drive.
I have used the following code:
dir *.dwg /b >C:FileListing.txt
start notepad C:FileListing.txt

This code only gives file names in the current directory.
I need to have a list of path and file names in the file FileListing.txt
Is there a way to do that without including subdirectories??

Thank you,

A:Solved: Batch file to list file names in current Folder.

Read other 9 answers

Hi All,

I've got a problem creating long named folders or files on a Linux network share.

I can see and log in to the share without any problems, but if I try to create a folder that is longer than 8 characters, I get the following error message:
The drive that this file or folder is stored on does not allow long file names, or names containing blanks or any of the following characters: \ / : , ; * ? < > |

Also, I can not see files on the share that have long names...

I only have this problem when I use my Windows 7 machine. XP and Ubuntu work just fine.

I am using Windows 7 Professional.


A:The drive that this file or folder is stored on does not allow long file names...


Read other 1 answers

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.


A:Does Windows save logs somewhere that shows folder names / file names?

Windows does not maintain such a log.

Read other 2 answers

Dear All,

I need to create a batch file which can read the size of file(e.g. 1kb, 2kb...etc) from specific folder and detect 0kb file and convert it to text file (showing 0kb file size) with alarm.

I am not really sure how to write command for this batch file. Please help :-(

A:How to create a batch file to read size of file on specific folder path

Read other 10 answers

Is it possible to create a hyperlink in an excel spreadsheet that goes to a SPECIFIC FILE within a zipped file? If so, how do you do it?



A:Solved: hyperlink in excel to a specific file in a zip file

Read other 14 answers

Simple question...
I dumped an excel file (.xlsx) into my startup folder (W7-64Bit SP1) so it would open everytime I turn the computer on. However, while Excel (Office 10) successfully opens, the file itself does not load. Anyone have a clue to make this seemingly simple task happen? BTW, it is the actual file, not a shortcut.


A:Solved: Excel file won't open from Startup folder

Read other 9 answers

Ok I'm totally at a loss on how to word this so I'm just going to write it out the best that I can...

First I have a batch file that I'm writing that will convert mp4 files to mp3 files (I have a lot) for a buddies band using ffmpeg.

Here's the code that I'm using:

ffmpeg -i folder\video.mp4 -f mp3 -ab 160000 -vn "\different folder\music.mp3"

what I would like to do is add to this so that I don't have to write out this code for every file I have... :/

I have the mp4 files in one folder and than the mp3 files are saving to another folder.

So here's an example of what the code will do if it isn't clear yet.

Folder 1:


what it should do is grab video1.mp4 and convert it.

ffmpeg -i folder\video1.mp4 -f mp3 -ab 160000 -vn "\different folder\music1.mp3"

and than move onto the next one

ffmpeg -i folder\video2.mp4 -f mp3 -ab 160000 -vn "\different folder\music2.mp3"

and than the next one

ffmpeg -i folder\video3.mp4 -f mp3 -ab 160000 -vn "\different folder\music3.mp3"

It's going to have to grab the name from the mp4 file and insert it for the mp3 file.

I can get around pretty good in cmd if it's basic commands but when it comes to something like this I'm a little confused...

Thanks for the help in advance!
I'll see what i can do about searching some more on what I would have to do and if I find the solution I'll post it here if it isn't already answered.

A:Batch File that grabs file names from folder to insert into batch file

A DOS "for /f" loop should do the trick, although changing the filename extension for the output to do everything in one line escapes me at the moment.

Perhaps you could do a dir .\folder\*.mp4/s/b > mp4s.txt, then make a copy of that and edit each line to rename the file to the destination name, and save it as mp3s.txt. Then you just feed both the source (mp4s.txt) and destination (mp3s.txt) filesnames into the for /f loop which handles the ffmpeg conversion.

Quite a crude solution and you'd have to handpatch the destination filenames, but i can't think of how to get a source mp4 filename and then just change the extension.

Read other 3 answers

Hello all!
So I work tech support at my company and recently had one of our secretaries run into a virus. It was an email containing a fake resume in .doc format that once opened, attempted to direct the computer to download a trojan. AVG detected it right off the bat and quarantined it. I then ran a full system scan with AVG, Malwarebytes, and Spybot and everything came back clean.  I had assumed AVG along with Word being macro-disabled by default kept anything from actually happening.
However, at the time of the download she was running our company bookkeeping software (eClub for those interested) and it crashed once she tried to use it again. I check it out and see that the .exe to run eClub had been removed from the eClub folder (let's call it eclub.exe). Weird! So I go ahead and completely uninstall the program and reinstall, only to find eclub.exe was not reinstalled with it. I copy eclub.exe from another computer and try to paste it into the folder, and I'm told I don't have permission to do so. Then things get weird:
1. I uninstalled eClub completely again, removed the eClub folder and every possible saved setting for it.
2. I created a blank eClub folder (ex. C:\Program Files\eClub)
3. I can put anything I want into this folder, including .exes, EXCEPT for eclub.exe, getting the insufficient permission error.
4. I can put eclub.exe in subfolders of C:\Program Files\eClub without a problem
I checked all my permission levels and have fu... Read more

A:Virus Preventing Specific File from Being Created in Specific Folder

Please post the Malwarebytes Antimalware log in your topic.
To find your Malwarebytes log,download mbam-check.exe from here and save it to your desktop.
To open the log double click on mbam-check.exe on your desktop.  Copy and paste the log in your topic.
 Please run TDSSKiller.
Please download TDSSKiller from here and save it to your Desktop.
The log for the TDSSKiller can be very long.  If you go to the bottom of the log to where you find Scan finished you will see the results of the scan.  If it shows Detected object count: 0 and Actual detected object count: 0, this means that nothing malicious was found and you will not need to post the log.
1.  Doubleclick on TDSSKiller.exe to run the application, then click on Change parameters.
2.  Check Loaded Modules, Verify Driver Digital Signature, and Detect TDLFS file system.
If you are asked to reboot because an "Extended Monitoring Driver is required" please click Reboot now.
3.  Click Start Scan and allow the scan process to run.
4.  If threats are detected select Cure (if available) for all of them unless otherwise instructed.
 ***Do NOT select Delete!
Click on Continue.
 Emsisoft Emergency Kit
Please download Emsisoft Emergency Kit and save it to your desktop. Double click on the EmsisoftEmergencyKit file you downloaded to extract ... Read more

Read other 1 answers

Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

A:Excel cannot open the file 'file.xlsx' because the file format

Older versions of Microsoft Office can't open the newer office formats,try updating and installing Microsofts file format converters. http://www.microsoft.com/en-gb/download/details.aspx?id=3

Read other 2 answers

Hi everyone. I have no idea what I did but for some reason, the folder and file names in my My Music folder are not showing up. I tried reseting folder settings to default but to no avail. Please help!

Read other answers


I need help to create an Excel macro that would

1. ask users to select x number of rows to be copied from one worksheet of one Excel file
2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

the target Excel files are all based on the same template
there is one worksheet in each of the target Excel files

in the target files, the rows should be copied from the first available empty row, going down

Looking forward to your help!

Thanks a lot.

A:Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Hi, welcome to the board.
Not much info there to get the correct picture.
Sample? Of source and template please
And not to forget, what version of Excel are you and the users using?

Read other 1 answers

The all of sudden change of color print of file folders, from black to blue is suspicious enough to think there's a possible virus or spyware, causing the transformation of normal black printed to blue print. 
Is there a way to correct the change of printed file color to blue? The changing started after updating a free word processor, at its website. After installing & using the program, my name files started turning blue.
Do Microsoft know the cause of this type of transformation?, It would help to cure it.

Sincerely: Lee V Payne-4/27/2018 - 1:52 PM EST.

Lee Payne

Read other answers

Hi all, today I received a zip file that had been created on a Mac. When I extracted the file on my Windows 7 machine, it resulted in a folder with a number of files.

Oddly, when I browse it in Windows Explorer, the folder name appears in green type, rather than black type like the rest of the folders/files in that directory. If I open the folder, all of the filenames inside are in green.

I've never run across this before. What would cause the folder/file names to appear in a different color? How do I undo it?

A:Folder and file names appear in color?

Hello Frank,

Usually when the text is green, it indicates that the files in the folder are encrypted. You would need to decrypt them using the same method/program that was used to encrypt them to return the text back to the normal black color.

Hope this helps some,

Read other 5 answers

In one particular partition of my hard drive, files and folders names are not visible. Other partition of the hard drives are all right. I formatted the system drive and re-installed the xp, but problem still exists.

A:File and folder names are not visible

Do you see "unallocated space" in the Disk Management Utility ? Right-click My Computer and select "Manage..."

Read other 2 answers


Does anyone know how to create colored Folder/File names in XP. I have always wanted to do this and thought it was impossible until I accidentally did it by creating the Heidi folder - that now shows up blue - see pic.

Thanks for any help you can provide.



A:(ttt) Colored Folder/File Names in XP

picking up on the by accident
is it blue because it has been compressed - right click - properties at the bottom there may be a tick for compression

Read other 2 answers

This may not be the right place for this question but I couldn't find a better one. I have a lot of files with very long names such as e61888d55aa19d8a3cbe9dfd7898c1. Some are folders and sone are files. They may or may not have any data in them. Anyone know why these are generated and if they don't have any data can I safely delete them. Thanks for tha help.

A:What Are These Really Really Long Folder & File Names

Looks like HEX to me.
Where are they located? 

Read other 4 answers

See this screenshot? How can I make my Windows Explorer display the text names? Normally in Thumbnail view it shows the names too ...

A:How to show file/folder names

Click on the down arrow on the circled icon and select details view:

Read other 1 answers

Whenever I do a "save" or a "save as" in Excel 97 the file is saved as the first letter only. For example, if I call up an existing file named "Sample.xls" and do a "save", the file will be saved as "S.xls" only. If I create a new file and do a "save as" and want to call it "New.xls" it will be saved as "N.xls" only. Anybody have any ideas? I am running Windows XP.

A:Excel 97 problem with file names when saving

I mistakenly stated that this problem occurred when I re-saved an EXISTING file. The problem only occurs when saving a NEW file. It's a bit of a pain to have to save a new file as a single character and then go into the folder and rename it in order to get the full file name desired. I would like to uninstall and then re-install Excel, but I have somehow misplaced my installation CD.

Read other 1 answers

Hi Folks,

I have a Dell Vostro running Windows Vista Ultimate. Recently the file and folder names disappeared . The only thing left in any folder is the icons. I also noticed that the 'search' facility now states that' it failed to initialize' and the system icon under control panel is not working. Apart from that the PC runs fine. I first suspected a virus or malware so i have ran Malwarebytes, Avast antivirus and Superantispyware.. Only the later picked up a few items which i removed to no avail. I have also ran a 'repair' from the Vista Disk. I have tried all combinations of holding shift, alt ..etc while toggling through the view settings and selecting different folders. I have tried customising folders and changing templates. I have tried removing the 'Hide filenames' option where I could find it. I have ran combofix just in case the registry was corrupted.

None of the above has made the slightest difference. Actually when I toggle the 'hide Filenames' option on and off I can see the icons move as if to make space for the folder/file names. This lead me to believe that perhaps the file names where there but perhaps in a colour like 'transparent' crazy as this seems . Needless to say that lead me no where. Couldn't find any option for text colour on files/folders

If anyone has experience this then please help as i have no other option than to now reformat the system and re-install Windows. This is really a last resor... Read more

A:Vista Missing File and Folder names

<<I have ran combofix just in case the registry was corrupted.>>

ComboFix...is malware tool, it is not designed to be used to attempt modification of the Windows registry.

For your information: ComboFix usage, Questions, Help - Look here - http://www.bleepingcomputer.com/forums/topic273628.html

I'll move this to the BC Am I Infected forum, where the more knowledgeable will try to assist you .


Read other 1 answers

Just this morning the My Documents folder on employees computer will only show the file names of documents in the folder up to documents starting with the ltter "D" all documents after that are not listed in teh folder, however the documents are on the drive becase I can access them with a "recent documents" or through the programs such as Excel in the recently used docs area. If I save a document that starts with say and "O" or "M" it does not show in the folder but the file is there as I can reopen as above.

Show Hidden files is checked and I have done a chkdsk /f as I figure is is some kind of corrupt index or file that is stopping things to be show after it, but I cannot figure out how to find the culprit.

A:My Documents Folder Only Showing Some File Names

Are you logging on as an Admin?
Try CHKDSK again.

Start | Run | CMD

cd "C:\Documents and Settings\Administrator\My Documents"
md C:\Backup
xcopy *.* C:\Backup /s /h

Hope this works. I really suspect its a corrupt filesystem though.

Read other 2 answers

I hope this is the right spot for this question. If it is not please feel free to move it to the appropriate section. I have two questions for you first of all. When I first bought my computer when I went into my C: drive all by file folder names were black. Now when I go in there some of them are black some of them are blue. I was just wondering if that was normal or if there was something wrong. If there's something wrong what can I do to fix it. My computer is a Pentium 4 and I am running windows XP.

My next question is when I am doing a virus scans and ad ware scans. I keep seeing a file folder called C: uploads. I don't have a file folder with that name I go to try and find it and there is no file folder with that name. There is a whole bunch of teams in that folder and none of which I have on my computer. I'm guessing that file folder is hidden is there a way that I can make it on it so I can delete it. Any help would be greatly appreciated.

A:Question About Blue File Folder Names

I do not have an answer . But i have SOME file names that are like that, they are in blue colored font. I think it means like it is Compressed or someting.

Read other 2 answers

I don't know how I managed to make the names of my folders and files in My Documents disapper but they did. I've tried things like holding shift and switching to medium icons but it doesnt work. Any help?

A:Solved: Folder and File names hidden

Read other 14 answers

Hello all ... does anyone know of an easy way of changing the name of a number of different files or folders at the same time? For example, I have a CD Rip (legally obtained of course!!) and the MP3 file names all are in this format: (band_name)_(album_Title)_(TrackNumber)_(Name_of_the_Track).mp3. Can I change the MP3 File names to this format: (TrackNumber) - (Name of The Track).mp3 without going in to change each file name individually? I.E., I would like to eliminate the Band & Album name from the file names, and change the underlines (_) to spaces ( ). I'd like to do the same to a number fo folder titles at once.

Is that kind of "batch" utility available?

As always, Thanks!!

A:Changing Multiple File/Folder Names

Get Mp3/Tag Studio a freeware Mp3 tag editor (although it does have a nag screen). Use the direct rename files option.

Read other 2 answers

Awhile back I was organizing my picture files and accidentally pressed a few keys, which seems to have caused my file and folder names to disappear in that one folder. I can see them fine in list, icon, tile, or detail view, but in filmstrip or thumbnail view they have disappeared! I use WindowsXP. How can I unhide the file names? Thanks in advance for your help.

A:Solved: File and folder names disappeared

Hold SHIFT and switch into "Thumbnail" view.

Read other 2 answers

Anyone else have this problem with long file names?
When using the folder view of list, it cuts off the file name past a certain point. I've looked around and can't find a setting that allows me to modify this setting.

In Vista and previous versions of Windows after switching to list view you could just hit refresh and the cut off file names would appear and the invisible list columns would maximize accordingly.

Just wanted to see if there was any way to resolve this before submitting it to MS.

A:Folder view - list (file names cut off)

Quote: Originally Posted by Cyphon

Anyone else have this problem with long file names?
When using the folder view of list, it cuts off the file name past a certain point. I've looked around and can't find a setting that allows me to modify this setting.

In Vista and previous versions of Windows after switching to list view you could just hit refresh and the cut off file names would appear and the invisible list columns would maximize accordingly.

Just wanted to see if there was any way to resolve this before submitting it to MS.

Maybe its because your viewing it in libraries? See if it acts the way you want it to in a normal folder.

Read other 9 answers

I want a batch to select and open a random link file in a folder i have. All the links are music videos I like to listen to, and I kind of want to just have an option for 'surprise me!'.
I can change the file names if I have to, and I have a basic batch file ability. I know the simple commands, but nothing of the variables, signs-involving commands (&%!?), etc.

Also, I want to learn a whole lot more about programming/java/batch file, so it'd be awesome if any code could be explained. Thank you, in advance

A:I need a batch file to open a random file within a certain folder/path

There's a free Windows scripting language called Autoit3 that would do this task easily using these functons:


AutoIt - AutoItScript
It has a Basic like syntax and is easy to learn.

Another popular scripting for Windows is AutoHotkey
AutoHotkey: macro and automation Windows scripting language

The syntax can be confusing but it has object support and is more powerful.

Of course there are tons of others for Windows:

Here's a list. The details for each tell which OS are supported:
Free Programming Languages - Freebyte's Guide to

Read other 5 answers

I have a computer that is a drone specifically for an outside LED sign. This computer is designed to never shut off and doesn't have any other program on it besides Operating System and the sign software. I need to create a batch file that I can place in the "start-up" folder that will open the program (LEDStudio10) and open the file that I want to play. I have already tried multiple attempts and I was hoping someone out there in sevenforums world would be able to point me in the right direction.

A:batch file open file for program in the startup folder

Task Scheduler. Create a new/basic task. You can invoke your batch script there. This can occur after boot completes, after user logon, etc. You can set it to run daily weekly hourly, etc. You can even have it delay X (preseleted time amounts) minutes/hours after boot/logon if you want.

Task Scheduler - Create New Task

Read other 1 answers

Hello I have about 1400 images.

I have a 2 prong issue here.

I am trying to create a catalog hyperlink catalog then ad comment with the file image.

1st Prong
I want to use an if change formula or conditional formatting or something to that effect so that the main images in Column A will reference Column B then transpose that data that falls in-between the changes across a row.

2nd Prong

I will like to automate this a process that allows me to take all the images in bulk and massively

Hyperlink Images to the file names
Insert Images into a cell that would at an adjusted size
Insert Images into a comment
I am not sure how to install a VBA so if you could help me with that it would be great

ANY HELP would be great i really need to get this project done ASAP!! I am drowning in this project.

I have enclosed an excel file that shows what i have done so far
to what i would like the end result to be.

Here is a link to the file

http://dl.dropbox.com/u/92093534/Need help with this worksheet.xlsx

Read other answers

Hi everyone.

I'm having this issue on Windows XP SP3.

I've run a few searches but not turned up any useful results (though it can be hard to judge what keywords are popular to search for...)

Here is the issue.

I'm attempting to view the correct names of some Chinese files and folders on my harddrive. I have gone into Regional/Language properties, checked the box to install East Asian support, and rebooted. I have also set "Chinese (PRC)" as the language to use for non-unicode programs in the third tab of the properties dialog, and rebooted again.

Unfortunately I'm still only seeing files and foldernames with nothing but underscores, like "______.txt" and I'm not sure what else to try.

This is a fresh Windows XP custom installation. I'm NOT sure whether IME has been installed properly - the only steps I've taken are detailed above. Perhaps I need to manually download something in addition to this - and if so, could somebody point me in the correct direction?

Thanks for your help!
(By the way, I do know that the files are not infact just named _______ My previous Windows XP installation showed them with proper Chinese characters.)

Read other answers


I need to paste a lot of Outlook messages into folders for the sake of archiving. When I try to do this, however, the file name tends to get contracted.

For example, yesterday when I tried to paste a message called "SD06012-01 - Power Pack for Lightweight Laptop_RRIT-10-31312 - new", its name got contracted to "SD06012 -.MSG".

The information in the name that gets missing is of such nature that I cannot afford to lose.

This only seems to happen, however, when I am using my Vista Ultimate x64 based laptop. When I use an XP-based one, no such thing occurs.

Do you have any idea why this might be happening?

Thank you for your time!!! Your help will be deeply appreciated.

A:Vista contracts the file names when I paste them into a different folder

Could you go to regedit (windows key and R, type regedit)
Go to HKEY_LOCAL_MACHINE\System,current control set,control,file system.
Take a snapshot of that page or tell me what the value of these two keys are.
NTFS Allow Extended Character 8Dot3Rename
NTFS Disable 8dot3 Name Creation


Read other 16 answers

I am running Windows 7 and have been using Asian fonts in the titles of files for over a year with no problems. Something in the latest service pack update (which automatically updated this week) turned these all to boxes. (The Asian fonts still worked just fine in documents and on the internet, but not on file/folder names on my computer desktop and libraries.) I backed out of the entire update and everything is fine again. How do I identify which of the multitude of updates is causing the problem so that I can ditch just that portion?

A:File and Folder Names in Boxes for Asian Fonts

Latest automatic update this week had no problems and file names in Asian fonts work just fine. Please close thread as solved.

Read other 1 answers

My dad is organizing our family photos, a few thousand, on the PC and earlier he goes into one of his folders with pics in it and there are no names under the files... but the files still have their original name (if i go to properties i could see it). i tryed renaming it but nothing changed. if i move all the files to a different or new folder then the names are there. Does anyone know what could be the problem? Heres a screenshot of what im talking about:

click here to see the screen shot

P.S. When i came to my dad to "fix" the problem, i couldnt open the photos in the folder and when i tryed to deselect multiple items that were selected (and in that blue frame) by just clicking on an empty spot, they wouldnt deselect. I fixed this by toggling off single click to open an icon and toggling back on. i dunno if this additional info helps.
thanks in advance

A:All of a sudden the names on my file disappear in one folder...a virus?

If you can move the files to a new folder and all is resolved -- what's the problem? Just delete the old, damaged folder.

It's not symptomatic of a virus -- just some kind of file system damage. You should probably run chkdsk /f on the drive.

Your image doesn't display for me by the way...

Read other 1 answers

I am unable to view Folder or File names in one of the drives, tried changing views and resetting defaults, no Luck
i can see the name when i click on the folder, attaching screen shot.
Any help appreciated
Kind Regards


A:Unable to View Folder or File names in one of the Drive

Read other 7 answers


When I turned my computer on today it seems that all of my filenames have 'disappeared' - the files are still called the same that I named them, but instead of them showing the titles, they either show the date modified or only certain details. I mainly have music on my hard drive, and now the folder looks like this:

As you can see, on the left in the folder tree, the path is showing up, the files are still there etc, but instead of the track titles, there is now only the artist and album? I have tried shift and view, tried different views, tried changing the folder view to pictures and videos etc, I have also completely scanned the drives and there doesn't seem to be any problems? Under 'folder options' I have tried showing all extensions etc, showing hidden files, different customizing of views:

Seems strange, but 'title' isn't an option for the folder view anymore? As here:

The folders now look like this:

Furthermore, the desktop now looks like this:

All the icons work, nothing has moved, but now they are all called the dates modified rather than the names, however, if i go to rename any of them i can, it shows the original name briefly, then reverts back to the dates modified names instead???

What has happened? Can anybody shed any light as to how I can fix this?


A:File Names Disappeared / Folder view changed?

Hello Jow, and welcome to Vista Forums.

You might try applying METHOD THREE in the tutorial below to reset all the folder view settings to see if that can help fix this for you.

Windows Explorer Folder View settings

Hope this helps,

Read other 15 answers

Directories and file symbols are just shown without any text name beneath them. It is only in the DVD drive, drive E, and only in the root directory at that, not in subdirectories.

The only posts I could find were people who claimed it could be fixed by going to properties and telling me to set the directory type to pictures and videos under properties, customize, and then when I right click and then go to view, that there would be a "hide file names" option which I could uncheck and get it to therefore SHOW file names. But they are all wrong. No such option appears. As you can see in these screen shots:

I found another post that said I should go to Organize / Folder and Search Options / View Tab and click the Reset Folders Button. Apply/OK and close and restart the explorer window, or possibly kill windows explorer with the task manager, and then try again to see if the hide file names option is there. Either way, it doesn't.

So, how do I REALLY get it to show file and directory names?

A:Windows Vista Won't Show File and Folder Names


At some point you appear to have customised this folder?

Click on the Sort by option (First picture & see if the options are the same as mine?

Read other 10 answers

Hi again

I don't know if this is possible or not but I'll lay it out there anyway. I have about 2000 Excel files in drive C:/Documents and Settings etc/. I have a workbook called WW Numbers.xls. I need to copy the file names only from C:\ drive into a workbook called WW Numbers.xls starting in Cell A2. For example, I have in drive C:\ the following files:


In a workbook called WW Numbers I want only the file names WW1.xls, WW2.xls .....WW2000xls staring on Cell A2.

I don't want to type in all the 2000 file names so I'm wondering if there is a macro that can do that for me

A:Solved: Copy Excel file names from drive C to a workbook

You don't need a macro, you can use something like "FileList" http://www.jam-software.com/filelist/
You can generate a CSV with the file names in which can be opened in Excel, you might only need to insert a column to extract the file name from the full name and path

Read other 2 answers

I have two excel files.

File A and File B

File A contains the column DRS Id.
File B contains the column TC ID and DRS Id.

I have to write a macro to pick the DRS Id from File A and search in File B for the DRS Id and pick out the corresponding TC Id. If there are more TC Id's for one DRS Id then I have to put that with a comma separator.
How to write a XL macro for this?

Please help on this regard.

A:Excel Macro to search for a value in another file

Hi, Welcome to the forum.
First thing I advice is to Always mention which version of Excel you're using. For VBA that isn't that much of an issue but it does help if we know what type of file we would have to attach for you.
Your question is not that difficult and yes that can be done relatively simple.
Could you attach two sample files, one for the 'A' file and one for the 'B' file with some dummy data in them?
You name the column's headers but it's easier to see than trying to imagine it.
You mention comma separated for what? Output?

Read other 1 answers

Evening everyone sorry for having to ask a silly question but is it possible to defrag a specific file or folder? the reason i ask is i am having some stuttering in certain games i play so i thought if i could defrag the specific game folder it might help improve performance. I have 4 partitions and all my games are on 1 of them so i know it would not take long to defrag the whole partition as its 100GB but 95GB free lol just curious to know if what i am asking for is possible for future reference

Thanks a mill


A:Can you defrag a specific file or folder?

I think that you can with defraggler.


Read other 3 answers