Computer Support Forum

Create A List Of Contents

Question: Create A List Of Contents

I recently created a data c.d. with over 100 files on it .Would anyone know how I could create a List of Contents? I have tried copy function in "detail view" and this works, but I can't paste contents into Excel, "new letter", Microsoft Word , Notepad, Word pad. I was successful in doing a print screen ,this would require several prints.
The CD is a 700MB CD-RW and I used Adaptec software , the "add contents" to cover did not work. (I doubt you could read 100+ lines) . Ideally 1 full sheet of paper that I could fold and place inside, would be o.k .

OS windows 200 pro

Relevance 100%
Preferred Solution: Create A List Of Contents

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.)

Answer: Create A List Of Contents

9 more replies
Relevance 56.58%

Is it possible to get a list of the contents of a folder that can be saved and edited say in notepad or word or IE?If its not possible thru windows, is there a proggy available that can do it.ThanksMike

Answer:Getting a list of folder contents

yep, there is a very good freeware program out there - - -think its dirlist or dirprt or something, I have it at home and if you get no more responses to this, will sort it out for you.

4 more replies
Relevance 56.58%

Is there any convenient way to get a list of a directory's contents, the file and subdirectory names? Dir doesn't return sub-directory names and mis-reports file-names that have non-ansi characters in them. The only way I've been able to do this is with a very slow keyboard macro

Answer:list directory contents

Not sure what is going on with your computer but dir shows subfolder by name

dir shows files and subfolders by name
dir *. /s shows just subfolders by name
dir /s show subfolders and files by name

You are right dir does not like special characters which is when I use explorer to list contents.

7 more replies
Relevance 56.58%

Is there an easy way to get a text list of all the files in a particular directory? How about a non-easy way?
 

Answer:Getting a txt list of directory contents?

at a command prompt, navigate your way to the exact folder, and type the following:

dir >> list.txt
 

4 more replies
Relevance 56.58%

When printing list for index purposes, the wording is smaller than on the screen.Appreciate asvice as to how to alter thisAs ever in hope - DES.NL

More replies
Relevance 56.58%

I was wondering what would be the best way to store the contents of a list box, so that I can reopen it at runtime and have the data imported back into the list box?
 

Answer:vb - storing contents of a list box

what im trying to do is to make a program that is like a shortcut for other programs.

you point the program to the directory for an exe file, then, stores a brief description of the program in the list. Then click on the item in the list then click on "run selected program"

i want it to be able to restore a list of the programs that have already been entered.

should I do this through registry? or through files? need help on how to with both
thanks
 

2 more replies
Relevance 56.17%

I have a folder named "January" that has Word 2000 docs in it that are sequential by date (i.e., Jan 1st...,Jan. 31st.)

I want them to show in that folder from the 1st to the 31st....right now they are inverse order (Jan 31st > January 1st)

How can I make them list correctly? IT looks like this now:
 

Answer:Word/Folder/Contents/List

14 more replies
Relevance 56.17%

'lo all, Is there a way to print out the list of files within a given folder (say My Documents) on Windows XP?Cheers

Answer:Printing list of folder contents

The Ghost of Inept Pigclick here and look on the page for Directory Printer. I've got it and it fits the requirements you have stipulated.Type Karens Print Directory in Google if you have a problem.Brambles

5 more replies
Relevance 56.17%

Does anyone have a neat and clean way to print a list of a directorys contents.A simple screen capture of windows explorer with all folders open shows only the folders and the screen capture pasted into my favorite digital imaging program comes out a bit fuzzy.I'm trying to make covers for my PC back-ups which are on CD and to actually see all contents of my PC (sorting for clean up). I've also used freemind (a free mindmapping utility - which allows saving as JPG PDF or whatever) to make a heirarcical list but it doesn't seem to line up the way I want it to.

Answer:How to print a list of a directorys contents?

Karen's Directory PrintShe has written some fine utilities over the years...

2 more replies
Relevance 56.17%

I have forgotten how to alphabetize the favorites in Internet Explorer. Anyone know how to do this?

Thank you,
Robert
 

Answer:How do you alphabetize the contents of the Favorites list?

right click & choose "sort by name"
 

2 more replies
Relevance 56.17%

Is there any like all purpose, or default way to set ALL folders to be viewed as a list instead of defaulted thumbnails? I like the list option better , but it sucks having to do it to EACH INDIVIDUAL folder. Any help is greatly appreciated!
 

Answer:Viewing all folders/contents as LIST?

In folder options there is a button to set all folder views like the current. Just set a folder the way you like it and click on that button.
 

4 more replies
Relevance 56.17%

My pin stopped working after Windows 10 did an update. I followed instructions read elsewhere to delete contents of my Ngc folder. I went to my account setting to create a pin. It asked me for my password to log in. I entered it and then nothing happened.

Now when I go back to sign-in options for my account and I click create pin the system works for a second and then stops and nothing happens. This is after a fresh reboot. If I try to enter the sign-in options a second time without rebooting the page does not load at all.

Thank you in advance for your help

More replies
Relevance 56.17%

Hi Guys long time no see, hope you are all well

I want to create an index of movies on a NAS drive.
I have a folder G:\Shared Videos on a NAS which has 23 sub folders inside (Film Genres) and a total of 1100 .Mp4 movies spread across these folders. I need a .bat file I can run from inside G:\Shared Videos that will list the 1100 movies, name only (not the Genre Folders or location) in alphabetical order to a text file I can then import to excel to create an Index. Is this possible. I've tried a few I have found searching but there not quite doing what I want.

Danny

Answer:Create txt file of folder contents

Have you tried clipname:

http://www.mainsoft.fr/en/downloads.htm

Source: http://ask.metafilter.com/75257/How-...-in-Windows-XP

9 more replies
Relevance 56.17%

My pin stopped working after Windows 10 did an update. I followed instructions read elsewhere to delete contents of my Ngc folder. I went to my account setting to create a pin. It asked me for my password to log in. I entered it and then nothing happened.

Now when I go back to sign-in options for my account and I click create pin the system works for a second and then stops and nothing happens. This is after a fresh reboot. If I try to enter the sign-in options a second time without rebooting the page does not load at all.

Thank you in advance for your help

More replies
Relevance 55.35%

Here is specifically what I want to do-I have ripped my entire CD collection to my hard drive and would like to share the list of bands in my collection on some other forums.  I have Win XP and know of no way to do this.  It isn't even anything I have encountered before, but it makes me miss Windows versions with DOS compatibility.  *sigh*At any rate, my cd collection is at E:/albums.  I want to make an editable text listing of the contents of that directory WITHOUT listing all of the subfolders.  For example, the band folders in my E:albums directory are 3 Doors Down, 10 Years, 12 Stones, AC/DC, etc.  THAT is the list I want to create as a text file and be able to edit.Any tips?

Answer:How to make an editable list of folder contents?

Code: [Select]cd e:\albums
dir > blah.txt
That should save everythin in blah.txt (type it into the command prompt).I forget if that's how you output to text files in windows but if it doesn't work you can always try:Code: [Select]cd e:\albums
dir
And then copy/paste everything it gives you.

2 more replies
Relevance 55.35%

Is there a program that anyone knows of or an easy way of making a list that displays the contents of files and it's subfolders?

I found a view, but all they do is literally print the contents on paper instead of being able to save the list in a notepad.

If anyone has any software or ideas please post them.

Thanks,
-Ryan
 

Answer:Creating File Contents to an HTML List

Here you are. It gives you several options when you right click a folder.

rjhExtensions
 

3 more replies
Relevance 55.35%

I have a folder containing about 450 sub-folders with random titles (Poems), what I want to be able to do; as the content and titles change fairly often (Poems acquire new titles so the sub-folder names change); is to print them out. OK you say, dive into DOS and do all the > and \ stuff, find the folder and then dir > Mylist.txt Two things A) Breaking a butterfly on a wheel springs to mind, and B) It will only give me an alphabetical list and loads of redundant info which has to be deleted line by line.

I need 1) A simple alphabetical list, and 2) A "Last modified" list as even a poem written 10 years ago will not be regarded as finished until I pop my clogs, so I frequently review poems and amend them. This would be easier if I could remember the titles of the darned things and sometimes the title of the poem inside the sub-folder is not the same as the sub-folder title, so a list in WORD to which I could then add the "Interior" title would be a boon!

Or to put it more succinctly, is there a program I can use for this?

Answer:[SOLVED] Printing a list of a folder's contents

You could do something like this:
How to add the Print Directory feature for folders in Windows XP, in Windows Vista, in Windows 7

Or use a tool like Karen's Directory Printer
Directory Printer - CNET Download.com

2 more replies
Relevance 55.35%

I need a batch code to list the contents of a folder. Except I need it to exclude the files file1.bat, file3.bat, and file6.bat. I'm using the code "dir C:\ /B/S/A:-D>list.txt" and I getfile1.batfile2.batfile3.batfile4.batfile5.batfile6.batbut I want it to readfile2.batfile4.batfile5.batcan I have some help.

Answer:batch code to list the contents of a folder

There's no exclude-list option in the dir command, nevertheless I think you can do an after batch trimming using search and replace in your .txt file for each occurences of your exclude-words.By the way, I have a blog post about free virus protection, in case you are looking for one.

3 more replies
Relevance 55.35%

Hello everyone!

I am here because I am wondering if Windows has such thing as the capability of listing a menu of the contents of a folder. For example, I am an ex-MacOS user and in the old days (pre-OSX) there was a program called FreePPP that had a menu item to which you could add applications to. It would simulate what the taskbar does in Windows. Also, the extension gave the ability to the system to "right-click" or "control-click" to list contents of a folder as a menu. There were other programs that would do the same job.

As the MacOS evolved, then OSX brought the dock. With it, any folder that you insert in it becomes a menu, listing the contents. Any folder in it, becomes a submenu, and consecutively, and shortcuts/applications in it; can be launched.

I tried to do the same thing in the Taskbar and no go

I have it in the start menu "All programs" and I click it and opens a list of the contents where I can choose what I want to open. Requires four clicks at least and a hell of a lot of navigation. The above mentioned task, should require no more than two clicks.

This is one of the few features I miss about certain great things the MacOSX has. Can I have a Windows 7 Christmas wish to have it granted? I have looked in the internet extensively for it and there doesn't seem to be an application to do the job. And it doesn't look like the taskbar has those properties currently. Anyone familiar with this, and therefore can reco... Read more

Answer:How to make a directory list contents as a menu

You can add a folder to the taskbar as a menu.
1. Right click on the taskbar and select the Toolbars -> New Folder
2. Select the folder you want to display as a menu
3. Done.

6 more replies
Relevance 55.35%

Hi,

I am using Word 2010.

I have a really long Word document with different topics.

I would like to create a Table of content at the top of that document so that I can click on that topic & it will take me directly to that topic without me trying to scroll down the whole document to find that topic. ( Just like a book in Word Format with table of content & clicking the topic to go directly to that topic without going thru the whole book page by page )

I tried to create a hyperlink for each topic but Word created the hyperlink at the same place where the topic was listed, so that doesn't help.

I also tried to copy & paste that hyperlink at the top of the document but that didn't work either.

Any help would be highly appreciated.

Thanks
 

Answer:How do I create a table of contents in a Word Document

The built in help has great info but this article covers it too:
http://office.microsoft.com/en-us/word-help/create-a-table-of-contents-HP010368778.aspx?CTT=1
 

2 more replies
Relevance 55.35%

I have a large PowerPoint 2010 presentation. Is there a way to create a table of contents without having to manually copy the title of each slide? Perhaps someone has an add-on that will work?

Thank you.

More replies
Relevance 54.94%

Hi, i have seen a word document that has a contents sheet, that is layed out in such a way that every time you complete a section within the document, if you go back to the contents sheet right click and update field, it updates what you have done in the sheet, how would i greate one of these for myselfHope i have explained well !!!!!Many Thanks Mark

Answer:word 2003/2007 how to create contents sheet

Just insert the cursor where you want the Table of Contents. Then go to Insert/Reference/Index and Tables, and choose ToC, with whatever parameters you want.

2 more replies
Relevance 54.94%

Hi I am Rupesh from India and I have downloaded huge mp3 files from internet and I want to create a database of these files.

Recently I have seen a website which contains some important lectures and decided to download the site. Actually the website consists of up to 60000 mp3 files and in that I need 13000 files and all the files I need are contained in a separate directory I mean with in a web page and it's sub web pages. I have downloaded what I need ie., 11000 mp3 files of size 185 gb using offline browser called extreme picture finder and remaining 2000 files are not downloaded. The extreme picture finder downloaded these files fastly and accurately but for remaining 2000 files it is taking lot of time and so I have stopped the program. I want to download remaining 2000 files manually I mean not through any offline browser.

The website from which I have downloaded mp3 file's is very nicely organized. The website administrators arranged webpages nicely I mean suppose if we examine a webpage they have specified that all the sub pages under that webpage consists of say 50 directories and 1000 files etc.,. I want to create a database file similar to the above.

The extreme picture finder application in Windows downloaded the files to the folder e:/downloads/ with exact file system structure as source website. Is there any possibility to create a database of all the folders and files which are under this folder. I think that we can create a ms access database so t... Read more

More replies
Relevance 54.94%

using Word XP,
how do u create a table of contents.
i have a bunch of paragraphs that have a title on top, like this:

YYYYYY

xxxxxx
xxxxxx

YYYYYY

yyyyy
yyyyy

i want to be able to have at the top of all that, a page that has this:

XXXXXX
YYYYYYY

and the above would be links, so that when u clicked on either of the above, you would be sent directly to the corresponding page.

could u please guide me through this process? thank you!
 

Answer:Solved: Create table of contents links in Word XP

15 more replies
Relevance 54.94%

I have a drive at work that is shared by many people. Within it are many folders to organize all the files. At times it is difficult to locate certain files; even using Explorer search becuase the file name may not be known.

What I would like to do is have a "table of contents" document or program to open that displays all the files, showing their folder location, and a link to that file.

I was able to do this somewhat in Excel but with 3,000+ files, doing so manually would be painstakingly difficult and time consuming.

It would be perfect if it was updated automatically, as these files change on a daily basis; adding new files and deleting old ones.

Is this possible? What would be the best program for it? Access?

-Tony

More replies
Relevance 54.94%

I have a number of technical documents that are currently unwieldy to find things in. One solution is to have the network drive indexed, but getting that working for a host of people in different locations could be difficult.

I was instead going to create a master index that pulls just the contents from each of the separate documents into one; obviously less functional than searching the entire documents but it should still do the job of allowing people to find important releases.

I can do this manually, and have done, but then the formatting is rubbish and there is no way to alter every line across all 80 pages at once.

Is there a better way of combining the contents pages, and if not then is there a good way of formatting quickly?

I'm thinking of making a python script to do it but if there's another way to do it I'd like to know. Master documents don't seem to do what I want?

Answer:Create a master index from the contents pages of several documents

Have you considered a Help Authoring Tool such as RoboHelp or MadCap?

Create a project with each document as a chapter, then index the entire project.

Just a thought.

Regards,
GEWB

1 more replies
Relevance 54.12%

Hi all

I am trying to create a spreadsheet with a function that displays a cell's contents based on the selection of two criteria. Basically, I have a big table on one worksheet which holds data relevant to consultants at my company and their sales performance per month. It's a big old table and needs to remain in this format for various reasons. What I'd like to be able to do is have an area on a separate worksheet (within the same Excel file/spreadsheet) whereby I can select a consultant's name from a prepopulated drop down list, and also a month from a prepopulated drop down list, and have it display the sales figure which has been entered for that consultant for that month on the big data table that already exists. Is there a way to do this?
I feel sure I've seen this happen at some point quite easily but I can't remember how to do it.

If it is possible but has to use VBA then it's probably not worth your time telling me how as I have no experience with VBA unfortunately and wouldn't know where to begin! If it uses pivot tables, unfortunately I am almost as green here so a step by step method would be greatly appreciated!

thanks
 

Answer:Excel: How to display a cell's contents by selecting two list items

8 more replies
Relevance 54.12%

for example-if I right click on an image in firefox, select 'save image as' and then hit the enter key at my preferred location (or simply click on 'save'), the download history folder will then appear on screen automatically, but the image that I have downloaded will automatically disappear from this list in less than half a second. I think firefox has been set to an automatically clear this download history list, or not to show history. Does anyone know where the setting is, so it does not automatically clear? Thanks

Answer:firefox download history list doesnt show any contents?

You probably have the 'Private Browsing' enabled denoted by a purple box in upper left hand corner

4 more replies
Relevance 54.12%

Seems there must be some program out there that will create a searchable Explorer-like document (such as html) of the contents of an external USB drive. Anyone know? I can already create lists but I am looking for something as described above.

Answer:Create a searchable Explorer-like document of external drive contents?

This might work ... just be sure to un-check any bundled garbage that may come with the download
SearchMyFiles - CNET Download.com

7 more replies
Relevance 53.71%

I would like to print the contents of specific file folders included in the listings on the C- drive under "My documents". Is this possible? If so, can you send step-by-step instructions?

Many thanks
 

Answer:Solved: Windows XP WORD -- Printing File Folder List of Contents

Try this program
http://www.karenware.com/powertools/ptdirprn.asp
I think it will do all you want.
 

3 more replies
Relevance 53.71%

Hello, I'm using Windows Internet Explorer 8 and I have a strange problem. I'm using a web page that has a drop down box.
When I access this web page with Google Chrome it expands to show the content of the drop down list. On Internet Explorer the box is a fixed size so I can't see the full length of the contents. When I access this page from another computer it works fine. I don't know the difference. The one that works is a Windows 7 Machine running IE 8.0 The other computer is XP running IE 8.0. I tried it on another computer running Windows 7 and it doesn't work so it isn't the operating system. Are there any settings, plug-ins, etc that would make this work on one computer but not on another?
Thanks.

More replies
Relevance 53.71%

Becoming overwhelmed by folders and files and duplicates and "lost" files &etc as a result of copying and back-up from superseded computers to newer computers.  Want to be able to create list of content of all, or of selected sets of folders/files, and save to desktop or print list of files from selected folders, as required in massive clean-up ahead of me.  In the process, great if can also identify duplicated (backed-up) files.  Thank you.

More replies
Relevance 49.61%

For my Archos 70 Internet Tablet 250GB:

How do I create an MP3 play list ... ???

I can only play one song at a time, which is annoying. I'd like to be able to play all the songs in a folder, or create a play list ....
 

More replies
Relevance 49.61%

Hi can anyone help I have to create six dropdown lists each to have different data in

Answer:how to create several drop down list

In what program? Excel?

1 more replies
Relevance 49.2%

I know there's a command prompt to do this, but it only works on the current folder. I have folders within folders and I need a program to easily list all those files.

Answer:Want a program to create a list of my files

dir /s
lists current and all child folder contents

0 more replies
Relevance 49.2%

I need to make a list of directories (only) of my hdd, even without files in them. TotalCommander can do it only for a specified number of folders and subfolders. The last folder (files), I don't need. Can do it another utility or os command?
Thanks for any advice
Peter
 

Answer:How To Create A List Of Folders, But Without Files

http://www.majorgeeks.com/files/details/karens_directory_printer.html
look at the screenshot at the bottom; there are lots of options.

Though the program is old and no longer being updated because of the death of its creator, Karen Kenworthy, I still use her programs. I purchased a CD with them on quite a few years ago because her programs are very good.

Try it and if you don't like it, it will uninstall cleanly.
 

2 more replies
Relevance 49.2%

i would like to create links between workbooks so that the destination workbook places the data in a list from different source workbooks. i.e. I will start with a generic template "Template Approval Form". I will fill out all information, save it as "Smith Approval Form". I will open up "Template" again, save it as "John Approval Form". I would like information from "Smith" and John" Approval Forms to be linked into "Tracking Database" destination workbook and placed in a list. Is this possible?

Answer:linking workbooks to create a list

re: "Is this possible?"The easy answer is "probably".However, we are going to need some more details.For example, what exactly do you mean by "the destination workbook places the data in a list from different source workbooks"?Since your source workbooks appear to some kind of "form template", I assuming you don't want an exact replica of each form in the "Tracking Database" destination workbook. (Actually, that would probably be the easiest to do...just create a copy of the template and add it as a new sheet to the Tracking Database workbook.)So if you want a "list", you'll need to tell us where the data is coming from (layout wise) and where it's going to (layout wise).Do you see what I'm getting at?

8 more replies
Relevance 49.2%

Just read this article on how to create a drop down list in Excel. Wondering if anyone know how to make one drop down list feed into another?http://desktopschool.com/excel-drop...message edited by tbird104

Answer:How to create drop down list in Excel?

They are commonly referred to as Dependent Data Validation Lists.Edit: The contextures site listed below used to be my go-to site for questions related to Dependent Data Validation Lists. Unfortunately, it appears that they have rewritten the site and made it harder to understand. The video is confusing, especially at the very beginning. You may want to refer to the text explanation at that site, but I suggest you watch the video here, which is much easier to understand:https://www.youtube.com/watch?v=gwF...http://www.contextures.com/xlDataVa...Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

2 more replies
Relevance 49.2%

I have a list of names and want to create a spereadsheet for each in a single workbook. the first spreadsheet will contain the full list of names, second spreadsheet will have a template of how I want all each spreadsheet to be created for each name on the list. Each name contained in the list in spreadsheet 1 should hyperlink to its corresponding spreadsheet (tab) contained in the workbook. Do you know is there VBA job for this?

Answer:Create worksheets from a list using excel VBA

I don't know what the list in your first sheet looks like, so I'll assume your list of names begins in A1.All I did was take the macro that you asked for when you wanted to create the TOC and added some code to copy the second sheet over and over, naming each copy based on the list in Sheet 1.Once all the sheets have been created, the TOC code creates a TOC based on those sheets. There are some subtle changes to the original code, but it more or less does the same thing it did before.BTW...if this is what you wanted in the first place, you should have asked for it. When you ask for code in "pieces" we end up having to do more work than if all the requirements are set forth right up front. Please keep that in mind the next time you need some help.As always, test this code in a backup copy of your workbook.Option Explicit
Sub AddSheetsAndTOC()
Dim ws As Worksheet, shtName As String, cShade As Long
Dim nRow As Long, i As Long, N As Long, x As Long
Dim lastRw As Long, nxtName As Long, lastSht As Long

'--------------------------------------------------------
cShade = 37 '<<== SET BACKGROUND COLOR DESIRED HERE
'--------------------------------------------------------
'Turn off events and screen flickering.
Application.ScreenUpdating = False
Application.DisplayAlerts = False
With Sheets(1)
lastRw = .Range("A" & Rows.Count).End(xlUp).Row
For nxtName = 1 To lastRw
lastSht = Sheets.... Read more

4 more replies
Relevance 49.2%

Hi, I'm using Outlook 2007 on Windows 7. Let's say I have 1000 general contacts in my Contacts list. I would like to create a new group or contacts category out of 250 of those contacts, and call it "Art Galleries." I've been researching for hours on how to do this, and can't find any useful directions. I can right click contacts in "Contacts" and "categorize" them. But when I create this "search folder," nothing shows up. In the "Contacts" view of Outlook, I can "Add New Group." It's easy! You just click "Add New Group" and name it. But then what? You get a new group, but how do you add contacts to this group? What I essentially need to do is this:

1 -- Create a specific group of contacts: eg. Art Galleries
2 -- I want to be able to open this group so that I can see all members
3 -- I want to be able to do (2) things with this group: a) email members of the group individually, and b) "Mail Merge" entire group to Word as mailing labels.

Can someone please provide specific instructions (or a link to instructions) on how to create this specific group, or contact list, or category (whatever it's called)? I can do the mail merge by selecting contacts one by one, it's creating the separate list that is being problematic. Thanks so much!

More replies
Relevance 49.2%

I need to create first- and second-level bulleted lists that are completely independent of one another. I'd like to use a macro to create them. Any directions appreciated. BTW, I'm using MS Office 13.Thanks.howagoodhowagood

Answer:How to create a list bullet using a macro?

I don't understand what you are trying to do. I don't even know what application you are using."MS Office 13" could mean Word, Excel, PowerPoint, Outlook, etc. They all allow for bullet lists and they all allow for the use of macros.We need a lot more detail before we could help. Not just the specific application, but also some details about the "independent" bullet lists also.Examples are always a good thing.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 49.2%

Hi Team,I created Drop down list in Excel 2007.CountryStateDistrictAreaIf I select country in drop down list after in Area list it should display only the areas blongs to that particular country without selecting state and if I select Country and State in Area list it should appear the areas which belong to that particular state.Please Help to resolve this issue.Thank you.K. Murugesan

Answer:create drop down list in macro

There shouldn't be a need for a macro to accomplish your goal.Review the information given at this site related to Dependent Data Validation Lists:http://www.contextures.com/xldatava...Note: The following will make more sense once you are familiar with the instructions found at that site.You'll need to be creative with your Named Ranges.For example, a Named Range of France would contain all of the areas in France.A Named Range of FranceParis would contain the subset of the France areas located in Paris, France.With your Country drop down in A1 and your State drop down in B1, the List source for the Area drop down would be =INDIRECT(A1&B1).When B1 is blank, you'll get all the areas in the Named Range found in A1, e.g. FranceWhen B1 contains a state, you'll get just those areas in the Named Range formed by A1&B1 e.g. FranceParis Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 49.2%

I know there's a command prompt to do this, but it only works on the current folder. I have folders within folders and I need a program to easily list all those files.

Answer:Want a program to create a list of my files

dir /s
lists current and all child folder contents

5 more replies
Relevance 49.2%

I have a spreadsheet that tracks students. On sheet 1 is the complete of students.On sheet 2 is a report.I need a formula for a dropdown that will look at a named range and return a list of names to the dropdown.Example: IF(StudentClass="Nursery) a list of resulting names are displayed in the validation dropdown.

Answer:How to create an if statement for a validation list?

Here is a short video on Dependent Data Validationwhich will show you how to accomplish what you want:http://www.contextures.com/xlDataVa...MIKEhttp://www.skeptic.com/

13 more replies
Relevance 49.2%

Just moved to Windows 7 from XP and struggling with Windows Live Mail (amongst other things!). Very basic question but I can't find how to add a new Contact list.

Answer:WLM 2011 -how do I create a new Contact list

Did you save (export) your old contact list as a CSV or WAB file? Or do you want to add the contacts individually?

Click on the "book" down in the left bottom corner. This will take you to the contact list. You can add them there individually or click on Import in the header ribbon and import your saved file from XP.

5 more replies
Relevance 49.2%

Iím having trouble creating a distribution list with Outlook 2003 on XP Pro SP3. I know how to do it, have done it before, and just did it with the same rev Office on our laptop under Win7. When I try to create one, I get the attached error msg. My outlook.pst file is not on the C partition (on purpose), but this is nothing new and Outlook knows where it is. Email works fine and the contacts list works fine. I donít use the address book. Any ideas?

Thanks in advance.
 

More replies
Relevance 49.2%

DerbyDad03 - I loved the vba code that you provided another user, and I've been trying to get it to work for my application as well. I am an amatuer with excel and trying my darndest to learn more and more about it. The code you provided is here :http://www.computing.net/answers/office/create-worksheets-from-a-list-using-excel-vba/13026.html I couple of questions I have is how do I accomplish the same thing without the TOC?Also, I am using dates to name the tabs. With the code you provided, it returns an error. What needs to be changed in the code to rename the tabs using dates?

Answer:Create worksheets from a list using excel VBA

If your Dates have / (slashes) they will not work because Sheet names cannot contain slashes.You have to use something like MONTH(A1) & "-" & DAY(A1) & "-" & YEAR(A1) to create a date like 5-17-2012.re: "how do I accomplish the same thing without the TOC?"Well, since the code in that thread creates a TOC, you obviously don't want the "same thing". What do you want?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 49.2%

Hi, I don't even know if what I want to do is possible.

I'm creating an html slideshow with over 600 entries, so I need to list all of the file names in the code, separated by a comma. The file names are all the same except for the numbers being sequential. Example: slide001,slide002,slide003,... Is there any program that can generate a text file like this? Typing this out would be incredibly tedious.

Thanks in advance.
 

Answer:Solved: Create a sequential list

16 more replies
Relevance 49.2%

Just built a new system and upon viewing my Mp3 folder all the files and folders within are viewed as Tiles. Right now i just go to view then click list for each folder and its contents manually.

Having quite alot of Mp3's i'd be here for a while doing it this way... is there any quick way to have a folder's contents all viewed as "List"?
TIA
 

Answer:Viewing entire contents of folder as "List"

The assumption is you're running XP here sooo...

Just set a folder the way you want it to look (Details, List, etc) then change the Folder Options so all folders will reflect that change. If it doesn't stick, and for folders that have Folder Tasks enabled (Music, Pictures, Videos, etc), it most likely won't so your only real solution becomes disabling Folder Tasks all together and going back to the Classic look.

ps
After posting this I see another assumption is in order: you may not know how to do what I just suggested.

Run Explorer, browse to a folder with content where you just want the List view - just one folder, regardless of content, and change the View to List right then and there. Click Tools - Folder Options - change the Tasks selection to "Use Windows classic folders" if you want to disable that aspect (recommended). If not, click Apply to all folders and then click Apply, then click OK and that should be that.

If you encounter a "stubborn" folder that simply refuses to change, do the same procedure again above but starting off in that troublesome folder to begin with.

Hope this helps...
 

4 more replies
Relevance 48.79%

Hello allIs it possible to make a drop down list appear if I would to enter @@ in a cell.An example: If I am writing a text in a cell and I needed to insert a special value, then I could type:Hello Mr. @@And then a drop down menu would be created where the two @'s are placed. Then I could select my value from that drop down menu, and then keep typing until I needed a new value and so on.Is this possible to make?/Jacob

Answer:Add/create drop down list if text is entered (on the fly)?

In general, any given cell can only contain the drop down or the text, not both. Consider where they place the Drop Down feature: it's contained within the Data Validation section of Excel. In other words, a Drop Down is supposed to be used to ensure that only the text that the author of the sheet wants in the cell can be placed there.So, to answer your exact question, No...what you are asking for can not be done.That said, we often get "generic" questions in this forum that don't really detail exactly what the requirements are. Fairly often, once the real requirements are laid out, a different solution becomes available.So tell us, what exactly are you trying to accomplish?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

10 more replies
Relevance 48.79%

hi,

I'm hoping someone can help me perfect a script/batch file etc that will list my folders that do NOT have a particular file extension in it, currently I've been using something similar to the below which would create a list of all directories on the X drive containing jpg files but what I really want is a list of all the folders where I forgot to add the jpg for instance, having to go through the list and comparing to the full folder list to look for differences is too time consuming and often leads to some being missed:

X:\>dir x:\*.jpg /w/o/s > \jpglist.txt
For example, using the above .jpg extension as an example imagine I had:

X:\2009pictures\holiday.jpg
X:\2010stuff\work.jpg
X:\2011work\reminder.txt
X:\2012pictures\holidaysnap.jpg
X:\2013\todo.doc

I'd like an output text file that says:

X:\2011work
X:\2013

Since these are the folders that do not contain any jpg files.
Really hope someone could help with this, would save me loads of time. I saw an old thread where someone was asking about a similarish type of subject ages ago and got some helpful replies so really hopeful a kind person on here can come to my rescue!

DOS - list files in folders without path

Answer:DOS - how to create list of directories without a particular file extn

Code:

dir /b /s x:\|find /v /i ".jpg"
Replace x: with actual drive letter

7 more replies
Relevance 48.79%

I have spreadsheet long list column of data with dates back to year 2005. I want to insert name of days beside the dates automatically. Doing it manually will takes a lot of time. Please help.

Answer:How to create days in a list of dates in exce

If your data is in A1, in B1 enter the formula: =DAY(A1)Then Custom format cell B1,Select Format,Select Cells,Select Number Tab,Select Custom In the Type box enter: ddd or dddd.Three gives you the short day SatFour gives you the long day SaturdayYou could also use the =TEXT() function to do the same thing.With your data in cell A1in cell B1 enter the formula: =TEXT(A1,"dddd")as with the Custom Formatting, Three d's gives you the short day SatFour d's gives you the long day SaturdayIn both cases, drag the cell down as many rows as needed.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 48.79%

I have Outlook 2003, with SP2.I use the Outlook address book when I write my e-mails. I wish to print out this list, but I see the only way is to print from the contacts list. This appears to be an old one, (backed up from previous versions of Outlook, with old and duplicated entries. It does not contain the new entries added recently.I would like to create a new contact list based on my current Outlook address book. Can this be done, and if so, how?.

Answer:Create a new Contacts list in Outlook 2003

Look in Outlook help. Search for; "Convert your Personal Address Book to a Contacts folder". Basically, you import it into the Contacts folder.You could create a new Contacts folder (Ctrl+Shift+E and select "Contact Items" from the "Folder Contains.." box) or empty the old one and use that.

10 more replies
Relevance 48.79%

Hi all,

What would be the best way to create and print roughly 1500 barcodes?

i am wanting to create a barcode which is either a number or text (predefined) and then print the labels on the A4 sheets you can get.
how would people suggest doing this? i haven't found any software up to now that can do this out of the box. there looks to be a lot of free options out there so ideally i would like to use one, has anybody done anything similar?

any pointers are appreciated

JPL
 

Answer:Solved: Create Barcode labels from list

Hi, I haven't done what you are planning, I did hoever try it once (out of curiosity) and all I did was download some barcode font and make sure that my text was conform the barcode requirements and that worked.
I remember using Google to find it.
 

3 more replies
Relevance 48.79%

Dear All

I am hoping to get helped with a macro or a formula which can select best students for limited seats

for example for a course of "ch" i have 4 seats, i want to select best students who can have "ch" based on their score. then i will go for other course "el" and same for all

i have included a dummy data for information, and wanted result on another sheet. if possible different sheets for different courses can be made
For the students who are assigned to specific course, should not be included in other courses.
Its kind of a merit list for different courses.

Please help
 

Answer:want a code or formula to create merit list

11 more replies
Relevance 48.79%

Can I create a favourites list on Google in Windows 8 - if so, how?

More replies
Relevance 48.79%

Hi,

I cannot find clear concise info on creating a distribution list for my client. He has Windows 8 and Hotmail.

Please advise,
Thanks,
John
Microsoft Certified Systems Engineer

More replies
Relevance 48.79%

I have many folders with names of clients and would occasionally like to print a list but without retyping them I can't seem to do that. I also have photos that I would like a physical list of but again without retyping them all.
Any ideas?

Answer:How can I create a list of folders in WORD without retyping them all?

Hello, this is a little bit of a crude way of doing it but it will work.

Click Start>Run. Type 'cmd'. In the command prompt change the directory to the folder you want by typing 'cd /D FOLDERLOCATION' and click enter. An example: 'cd /D C:\Folders'.

Then type 'dir' and press enter.

This will list the folder names as well as a few other bits of information. Right click within the command prompt and select mark. Highlight the text and click enter to copy. Then paste into word.

Another command is 'dir > C:\Folders.txt'. This will save the information on your C: Drive in a text file called folders.txt.

Simply open the txt file with notepad and copy the contents into word. You will probably have to remove some of the other information like folder size.

I hope this helps.
Dave

9 more replies
Relevance 48.79%

I am wanting to create a distribution list in Outlook 2007. But I don't want to add each email address in my contact lists. Is that possible?
Thanks!
 

More replies
Relevance 48.79%

I needs some info on dependent list in excel to create validation. Please find below my example.

one work sheet has the employee detais in two differnt columns(A and b) master data.
Eg;
sat - Manager
sai - DBA
sss- Manager
xx - Team leader
AA- Seniour programmer.

i want to implment the validation in another worksheet based on the above master data. Eg: This sheet has 3 columns.
Designation, Employee name and Salary,

Once i type the designation in that column then Employee list needs to filter based on the inputted designation. Example if i enter Manger then employee list needs to display sat and sss only. it sould not allow other names.

Please Note : Macro is not allowed.

Regards
Raghul
 

Answer:Dependent list in excel to create validation

7 more replies
Relevance 48.79%

Hello, I am hoping that you can help me with an excel problem. I have a large list of clients who completed tests of various days and each client?s name appears several times on the list based on them completing a test on a given day. For example, (in Sheet1) John Doe appears in column A, 25 times based on the dates he completes a tests. The date that he completed the test is in column B and, the amount he is charged in Column C, the date he paid for the test in column D and the amount he paid on that date in column E. I have included an example below. What I would like to do is to automatically create a record for each client in Sheet2, where the name of each client would appear only one time. So, each time a new client who completes a test is entered into Sheet1, their name would appear is column A (only one time), of Sheet2 and then I could do some formulas to keep a running balance for each client. Any help you can provide would be greatly appreciated. Name DateTested Charge DatePaid AmountPaid
Tina Doe 4/24/2017 $10.00 4/24/2017 $5.00
Tina Doe 4/25/2017 $10.00 4/25/2017 $5.00
James Does 3/1/2017 $10.00
James Does 3/3/2017 $10.00
John Doe 4/15/2017 $10.00 4/15/2017 $10.00
John Doe 4/17/2017 $10.00 4/17/2017 $5.00
Jane Doe 3/15/2017 $10.00
Jane Doe 3/20/2017 $10.00
Tina Doe 4/26/2017 $10.00 4/26/2017 $2.00
John Doe 3/22/2017 $10.00 3/22/2017 $3.00
Tina Doe 4/27/2017 $10.00

Answer:Excel Help: How to create an individual record from a list?

1 - Follow Mike's suggestion with your existing list to create a list with no duplicates in Sheet2 Column A.2 - Enter the formulas you plan to use on Sheet 23 - Right-click on the sheet tab for Sheet1 and choose View Code.4 - Paste the following code into the pane that opens.5 - Enter a name anywhere in Sheet1 Column AThe code will search Sheet2 Column A for the name that was just entered. If it doesn't find it, it will copy the last row on Sheet 2 to the next row and place the new name in Column A.
Private Sub Worksheet_Change(ByVal Target As Range)
'Determine if change was made to Column A
If Target.Cells.Count = 1 And Target.Column = 1 Then
With Sheets(2).Columns(1)
'Search for new name in Sheet(2)Column A
Set n = .Find(Target, lookat:=xlWhole)
'If not found, add new row for new name
If n Is Nothing Then
lastRw = Sheets(2).Cells(Rows.Count, 1).End(xlUp).Row
Sheets(2).Rows(lastRw).EntireRow.Copy _
Sheets(2).Cells(lastRw + 1, 1)
Sheets(2).Cells(lastRw + 1, 1) = Target
End If
End With
End If
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

6 more replies
Relevance 48.79%

Hello,

I have Outlook 2003 and have been added as a delegate to someone's mailbox with full rights. I would like to create a distirbution list with the other users contacts, but I'm unable to.
I go into create new dist list, click on "select members" and it doesn't show the other users contacts. Only the global address list along with my own contacts.
How do I set it up so the other users contacts do show up in that list.

I did do a search on the internet and can't seem to find the answer. I found a lot mentioned going into their contacts properties, click on Outlook Address Book tab and selected "show this folder as an e-mail Address Book" and then give it a name, which I have done.

Your input is appreciated. Thanks.
 

Answer:Unable to create a distribution list as a delegate

Anyone?
 

2 more replies
Relevance 48.38%

I will be performing a clean install of Win 7 Home Premium edition on a new hard drive at the end of the week.  I am currently compliling all the drivers I anticipate I may need (although Win 7 will probably load most of them automatically).  I have read a few threads about performing a clean install on a W500.  Has anyone created a step procedure and the drivers that will be necessary?  Thanks in advance.

Answer:Anyone create a step list for a Win 7clean install for a W500?

I think this link will help: http://www-307.ibm.com/pc/support/site.wss/document.do?lndocid=MIGR-74108





W540 20GBCTO, Ultra Dock, W520, 4270CTO, W510, 4318CTO; (2)T500, 2081CTO; Y560, 064657U, Y530, 405166U; T61p, 6465CTO, A31p, and L2461x Multi-touch Monitor, Mini Dock Plus Series 3

1 more replies
Relevance 48.38%

I'd like to start keeping a tally on these, if anyone else has ideas please share! Often hidden devices and services block malwarebytes and other .exe tools like hijackthis.example:Please begin by clicking Start > Control Panel > System > Hardware > Device Manager > View > Show Hidden Devices? Scroll down to Non-plug and Play Drivers and click the plus icon to open those drivers.? Then search for TDSSserv.sys? Others: legacy_gaopdxserv.sys, legacy_msqpdxserv.sys? Let us know if you find this or not.? If you do find it, right click on it, and select Disable. Do not try to uninstall it.? Also if TDSSserv.sys is found and you disable it, then you must reboot immediately.? After reboot continue on with other cleaning instructions you may have been having problems running.my list so far from various posts and experiences:Then search for TDSSserv.sys? Others: legacy_gaopdxserv.sys, legacy_msqpdxserv.systdss(other random characters) - variant of tdssserv.sysuac(other random characters) - I have seen this on winxp machines which is a red flag. SKYNET(other random characters)ab56sy26 (or similar 8 character random name)dda7731akbiwkmqowtskqwUACrgwrubqholgoodlist?1394 ARP Client Protocol, AFD, ASCTRM, ASPI32, Bepp, dmboot, dmload, EABFiltr, Fips, Generic Packet Classifier, HTTP, IP Netowrk Address Translator, IPSEC driver, ksecdd, MBAMSwissArmy, mdmxsdk, mnmdd, mountmgr, NDIS Sytem Driver, NDIS Usermode I/O Protocol, NDProxy, NetBios over TCIP, Null, Parport, P... Read more

Answer:Help create a list of common fake hidden devices

is it common for the fake ones to have a yellow flag near/issue flag?

also is it a good idea to create a whitelist/goodlist or will that lead to more issues (viruses using legit names)
added:
"serial" to the bad list

4 more replies
Relevance 48.38%

HiI am using this code below to create Excel sheets based off of a range of cells from a main sheet.I would like to do everything below but in addition when it creates the sheet and copies the row info, I would like it to make each row or cell on the main sheet link to each indivual sheet. Also within each individual sheet (that contains the one record info from the main sheet) to contain the link back to the main sheet. In other words, would like the hyperlinks to navigate back and forth when I have 75 sheets to work with. Any thoughts? thanks! BrahioSub AddMonthlySheets()Dim mMonth As Range For Each mMonth In Sheets(1).Range("A1:A12") ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count) ActiveSheet.Name = mMonth Sheets(1).Range(mMonth.Address).EntireRow.Copy Destination:=ActiveSheet.Range("A1") NextEnd Sub

Answer:Excel Macro to create worksheets from list with hyperlinks

First, a posting tip: Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum. Thanks!As for your question, something seems a bit strange. You said:"...would like the hyperlinks to navigate back and forth when I have 75 sheets to work with."Yet your code only creates 12 sheets:For Each mMonth In Sheets(1).Range("A1:A12")Assuming that's just an example, I'll assume you can modify the code below to create as many sheets as you need.You didn't provide the Name of the main sheet, so I am going to be creative and use the name Main in my code below. Again, I assume that you can modify the code to meet your needs.This code will create a new sheet for each value in Main!A1:A12. It will also create links in Main!A1:A12 to the respective sheets. Finally, it will create a link in A1 of each new sheet back to Main!A1.Sub AddMonthlySheets()
Dim srcMonth, dstMonth As Range
'Loop Through A1:A12
For rw = 1 To 12
'Create Worksheets and Copy Row
Set srcMonth = Sheets("Main").Range("A" & rw)
ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = srcMonth
srcMonth.EntireRow.Copy Destination:=ActiveSheet.Range("A1")
'Create Hyperlink to new sheet
srcMonth.Hyperlinks.Add Anchor:=srcMonth, _
Address:="", SubAddress:=srcMonth & "!A1", _
TextToDisplay:=srcMonth.Value
'Create HyperLink back to Main sheet
Set dstMonth = ActiveSheet.Range("A1")
dstMon... Read more

4 more replies
Relevance 48.38%

I found this VBA code for excel marco but it is creating new sheets from a list based on the date. However, I was curious if this can be changed to loop through the data list and create a new sheet for each unique customer.Sub CreateMonthlySheets()Dim lastRow, mMonth, tstDate1, tstDate2, shtName, nxtRowOn Error Resume Next'Make a copy of the data sheet and sort by name Sheets("Sheet1").Copy After:=Sheets(1) Sheets(2).Name = "SortTemp" With Sheets("SortTemp") lastRow = .Cells(Rows.Count, 1).End(xlUp).Row Rows("2:" & lastRow).Sort Key1:=Range("A2"), Order1:=xlAscending 'Using SortTemp Sheet, create monthly sheets by'testing Month and Year values in Column A'Loop through dates For Each mMonth In .Range("A2:A" & lastRow) tstDate1 = Month(mMonth) & Year(mMonth) tstDate2 = Month(mMonth.Offset(-1, 0)) & Year(mMonth.Offset(-1, 0)) 'If Month and Year are different than cell above, create new sheet If tstDate1 <> tstDate2 Then ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count) 'Name the sheet based on the Month and Year ActiveSheet.Name = MonthName(Month(mMonth)) & " " & Year(mMonth) End If Next On Error GoTo 0 'Loop through dates, copying row to the correct sheet For Each mMonth In .Range("A2:A" & lastRow)'Create sheetname variable shtName = MonthName(Month(mMonth)) & " " & Year(mMonth)'Determine next empty row in sheet nxtRow = Sheets(sht... Read more

Answer:Excel marco: Create new sheet from list of data

Where is the customer information located in the worksheet? Do you have any Named Ranges? How do you want the new sheet populated?

2 more replies
Relevance 48.38%

I would like to open Windows Explorer, click on a CD-ROM and, from the list shown, create a document that can be inserted into Word. I would like to avoid using jpeg or gif files since I would like to be able to edit whatever is entered into the document. Is there a program out there that does this that I can download without subscribing to PC World or other mags? Shareware, pay for or freeware, I am not concerned about the program costing something, I just don't want to subscribe to a magazine just to download one item.

Thanks for any help.
 

Answer:How do I create a Word document from a Windows Explorer list?

try this as it outputs directory listings to a txt file so you can copy and paste into word etc

JR Directory Printer (Free) 173kbs
http://www.spadixbd.com/freetools/jdirprint.htm

page above also has instructions as to options.
 

2 more replies
Relevance 48.38%

I want to create a list of all files in a child folder.
There are about 300 files of various file types in the folder
- would it be possible to create such a list in cmd.exe window

If so how would I do that ?
- in the past I have dabbled with commands to release stubborn drives but that is the extent of my experience.

I think I need to CHDIR to the target folder but I dont know how to then create a complete list of files in the cmd window
- I am a little out of practice writing script to create a new TXT file with the list of files.
- Wiki - List of DOS commands looks promising so I thought cmd.exe might be easier and quicker than script

Thank you

Answer:How can I create a list of files contained in a child folder

Hello Russell,

You might see if the context menu below may work for you for this.

Context Menu - Add View and Print File Directory

3 more replies
Relevance 48.38%

Hi all, I am starting to have a lot of pinned items on my taskbar. Is there a way to add some into a list I can expand from the taskbar. Here is what I have at work on my XP. Something similiar would be useful!



Thanks Hornet

Answer:Create Taskbar Pinned Items Into an Expandable List

Maybe set the taskbar setting to never combine might work you can try it:

Taskbar Button Grouping - Enable or Disable

6 more replies
Relevance 48.38%

I am trying to find a way of creating a drop down list that will include more that one column of information.
My cell that I wish to select from the drop down is A1.

I have a list of items on a separate worksheet or further down to select from the drop down list is; column A includes a description of a product, column B is the price and D is the type.

I would like that when I select the product in the drop down list (for example from A11), that the price (from B11) and that the type (from C11) also will stay with the product and appear in all 3 cells; A1= product, B1= price C1= type. so the price and type would remain with the product regardless if they were not chosen.

A B C
Product Price Type
Shoes $2 Sports
Sandles $3 casual

So If i was to select shoes in the drop down, it would appear in cell A and $2 would appear in cell B and Sports would appear in cell C
 

Answer:How to create a drop down list that includes more than one column of data?

Kisongo,

Hi, and welcome to the forum. You could use a userform for what you want. If you want to go that route I could or some one else may be able to do it. I'm not sure how what you want can be done with a formula. May be some one with more knowledge may be able to do it that way.

Take a look at the attachment. This is something I put together for another user. It can be modified for your purpose.
 

2 more replies
Relevance 48.38%

I know that the outlook and microsoft word have the mail merge to create labels. However, I could not find a way to create a LIST (not label) only, so i can send someone else my mailing list. Basically, I want to create mailing list by using my outlook contacts without retyping the contact information in a table form or whatnot.

Please help me
 

Answer:Not create labels but LIST to send to others to use for mail merge

You can use File/Export to create a csv file which can be imported into most email programs or used as an Excel spreadsheet.
 

1 more replies
Relevance 47.56%

Hello again!
I am having trouble with a macro that is supposed to perform the following tasks:

Prompt the user to input a cell where the drop down list is to be located
Prompt the user for a range of data to use in the drop down list values
Create drop down list
Hide the rows in which the drop down list values are located

I originally recorded a macro to do this, and then I am tweaking the code accordingly. What is troubling me is getting the macro to select a range from an input box, the using that input to create a list. It's the partcular language included in the .Add command that I do not understand I defined the input box as a range variable celRng, and I am trying to get Formula1: = celRng. But it is not working.

I have attached the code below, and marked in which lines the errors are located:


Code:
Sub CreatDropDownList()
'
' CreatDropDownList Macro
'
' Keyboard Shortcut: Ctrl+Shift+D
'
Dim celNm, celRng As Range
On Error Resume Next
Application.DisplayAlerts = False
Set celNm = Application.InputBox(Prompt:= _
"Please select a cell to create a list.", _
Title:="SPECIFY Cell", Type:=8)
On Error GoTo 0
Application.DisplayAlerts = True

If celNm Is Nothing Then
Exit Sub

Else
With Selection.Validation
.Delete
On Error Resume Next
Application.DisplayAlerts = False
... Read more

Answer:Excel Macro to Create a Drop Down List and Hide Cells

DJL,

It looks to me like you open the 'With Selection Validation' statement without closing it before the If statement.
Try adding End With before the If statement above your error, then add another 'With' Selection Validation' after the Else statement.

You can also put msgbox = celRng after the else statement to check the variable value before the error.

Stoneboysteve
 

5 more replies
Relevance 47.15%

i want to retieve 30 days old files list and location from my computer and then after i want to move that files older tahn 30 days.. so pleaze help me create batch file

More replies
Relevance 47.15%

It's difficult to describe my situation in words, so I'll just show you what I'm trying to do.

I have a table that looks like this:

A, B, C
Name, Hours, OT hours
Jane, 166, 0
Jack, 163, 17
Mike, 168, 0
Dot, 167, 24
Erin, 164, 8
Carmen 158,0

and I want to create a list that will have 2 rows if there are OT hours, and 1 if there are not.

A, B
Jane, 166
Jack, 163
Jack,17
Mike,168
Dot, 167
Dot, 24
Erin, 164
Erin,8
Carmen, 158

I can't use macros or VBA. It has to be formula driven. I can use a helper column or two. The starting table will change depending on who charged hours where. I've been trying to use IF and OFFSET and ROWS to do it, and it works until there's 2 consecutive rows that have OT hours.

Just to clarify, I just need to know how to get column A listed properly elsewhere in the spreadsheet - I can derive Column B using vlookup.

Thanks so much!
 

Answer:Solved: MS Excel: create list based on data in a simple table

2 Formulas - 1 for finding the name, the other for finding the appropriate value.
Note - must start on row 3 or greater.

Names (mine start in cell G3): =IF(G2<>"",IF(G1=G2,INDEX($A$2:$C$7,MATCH(G2,$A$2:$A$7,FALSE)+1,1),IF(VLOOKUP(G2,$A$2:$C$7,3,FALSE)>0,G2,INDEX($A$2:$C$7,MATCH(G2,$A$2:$A$7,FALSE)+1,1))),$A$2)

Hours (mine start in cell H3): =IF(G3=G2,VLOOKUP(G3,$A$2:$C$7,3,FALSE),VLOOKUP(G3,$A$2:$C$7,2,FALSE))
 

3 more replies
Relevance 47.15%

Hi 
I'm new to developing excel add-on.
I'm trying to add a drop down list to a cell, this is what i have done so far
  Range ddlRng = worksheetname.Range[
                    worksheetname.Cells[firstRow, Column],
                    worksheetname.Cells[lastRow, Column]];
                ddlRng.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, XlFormatConditionOperator.xlBetween, "Opt1,Opt2,Opt3", Missing.Value);
at validation.add() line it throws an exception saying "Exception from HRESULT: 0x800A03EC"
and this is the StackTrace 
"   at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)\r\n   at Microsoft.Office.Interop.Excel.Validation.Add(XlDVType Type, Object AlertStyle,
Object Operator, Object Formula1, Object Formula2)\r\n   at MS.ProductionPlanningTool.Excel.CommonPack.ControllerServiceClass.AddMaterialVersionList() in D:\\MidasCloud\\CloudTFS\\ProductionPlanning\\MSP2\\MS.ProductionPlanningTool.Excel\\CommonPack\\ControllerServiceClass.cs:line
1892"

More replies
Relevance 46.74%

If I can describe my problem.

I have a table containing 2 columns one has the contents a-f and the second has a text content relevant to that letter i.e. A=large flange over centre line. tblVariant

A second table lists the products along with their variant letter. tblProduct.

I have created a form based on tblProduct and I want the text box to have a popup window that displays the relevant text for the contents of that box when the mouse hovers over it?

Is it possible?
 

More replies
Relevance 46.33%

I am not a 100% on how I managed this but here were my last steps:
- changed the host file in c\windows\system32\drivers\etc
- rebooted computer
- received system errors, so I ran a HDD defragmenter
- I then tried to access a file in c\program files but could not find it, but it mysteriously felt like I was in the c\windows directory. So I looked in c\windows and found the file I was previously looking for in c\program files.

The other problem is that any file or program that is rooted in those folders gives me an error message reading "location is unavailable" whenever I try to access it.

Needless to say, My computer is JACKED and I would appreciate and help on this.

If this is at all confusing just ask and i will try to explain it better

Thanks

Shawn

Answer:contents of C\windows switched with contents of c\program files

Try doing a System Restore predating the issue.

James

9 more replies
Relevance 45.92%

Hi My friends,

I use excel 2003 and want to create a drop-down list right after selecting a choice from another drop down list.
For example: from a first drop down list of different brand of cars, the second drop down list is created listing different models of the brand of the car that i just picked up in the first list. Lets say we have three list and we want to select and make a drop down list according to a choice from another drop down list.
Is that possible doind this without using macro and instead using only the validation data / List and source?

Other question: from a choice from a drop down list, a pain brush picture will be displayed on another excel cel. is that possible?
Can someone please help? Many Thanks.
 

Answer:How do I create a drop down list from another drop down list?

9 more replies
Relevance 45.51%

I use XP Pro....
I keep my audio files in folders. And I don't know why every now and then when I open these folders all the files show in "Tile mode". I hate that and always convert them all to "List mode". But in a few days they go back to all showing in "Tile mode" again.

Is there a way to make all the contents of folders Always show in "List mode"?
 

Answer:Make folder contents always show as "List" not "Tiles"?

6 more replies
Relevance 43.05%

Hi,

i was trying yesterday to find out for several hours how to create in Outlook 2000 distribution list with names chosen upon one, specific outlook "category"... I know how to create distribution list itself... I know how to make outlook to show me all names in my address book with this specific category... BUT, how mix it together and in the end receive distribution list with all names of this category included, I cant do it, i am too big idiot comparing to MS coders.... ((

Yours, but very sad and disappointed about my mental possibilities

Jazzek
 

Answer:Outlook 2K: How to create distribution list based upon certain outlook category???

Hi Jazzek -- I just did this, with the help of Russ Valentine at the MS Outlook newsgroups. Here are the instructions he sent me (and I used successfully):

"Change the Contacts Folder View to Categories. Right click and drag the
desired Category to
a newly created sub folder then choose Copy. Make sure the new sub folder
has been enabled as an email address book by right clicking on it and
choosing Properties and Outlook Address Book Tab and checking the box to
enable
as email address book. Create your Distribution List but make sure the Show
Names drop down field points to the new sub folder then shift select all the
contacts and voila."

I hate cruising the MS Newsgroups, as the interface is so weird and searching the archives is a total pain on their site (and incomplete in my newsreader), but I DO occasionally get help there.

Hope this helps. If I've misunderstood your problem, post me back.
Carol
 

1 more replies
Relevance 42.64%

I would like to somehow copy the "Now Playing" list from Windows Media Player and get it into a word processor to edit as I like. Unless I'm missing something obvious there does not seem to be any "Print" or "Save List" or similar option. I've tried highlighting the list and using Copy and Paste but that doesn't work. Any ideas?
 

Answer:How can I create an editable "Now Playing" list in WMP?

Save the now playing list as a playlist first by clicking the drop down arrow and 'save playlist as', choose 'M3u' in the save as type drop down box.
Then go to the saved playlist file and open directly with word. (right click it, open with, word) You'll have your editable info ready to go.
 

2 more replies
Relevance 42.64%

Is it possible to create a list of file descriptions (Properties => Details => Description) via batch file.  I'm using Windows 7 Professional.  See link below for clearer picture:http://i10.photobucket.com/albums/a133/vivamarxista/CollectingFileDetailDescriptions_2.jpg

Answer:Create List of File Descriptions via Batch File?

I do not believe it is possible to offer a generic solution; is there a particular kind of file that you are interested in?

3 more replies
Relevance 41.82%

What's the comparable way in Win8 to make all items in all folders as "list" pls.
This is what I do in Win7.
1.open any folder
2.on the right with arrow down, pull down menu list,Details,Titles,Content. Choose list
3.on the left under Organize, pull down menu to Folder and search option
4.click on View tab
5.Apply to Folders
6.OK.

Please show me a comparable way to make all items in a folder appear as List. Thanks.

Answer:How to create "list" in all folders please?

The choices are in the ribbon above. Cick the View tab and you will see. If you have no ribbon yet, right click on the top of the page and enable it.

4 more replies
Relevance 39.77%

What do I need to click on to get contact list ? Tried clicking on To,CC.and BCC. doesn't do anything.Haven't seem then since I downloaded Windows 10.

More replies
Relevance 36.9%

I have a laptop where the cursor runs in circles through lists or drops to the bottom of the list so far I have tried the following to fix it: 1) bought a complete set of backup disks from Lenovo to restore laptop...Did not fix problem2) reloaded XP on the laptop..Did not fix3) ran antivirus and anti spyware ...Did not fix4) put entirely new disk in laptop....Added memory installed Windows 7..Ran fine for 2-3 days then started acting up again.... I have tried disabling touch pad, tried all sorts of system changes, installed new driver..Still does not work I am pretty disgusted with this laptop...So far have sunk about $300 into trying to fix it...help 

More replies
Relevance 36.9%

I'm running Win10 Pro 64bit and Revo Uninstaller Pro v3.1.5. There is a huge discrepancy in the installed programs lists provided by Revo Uninstaller and the Win10 Programs and Features control panel. They both say there are 83 installs (that's good). But Revo Uninstaller claims that 15 programs were installed a few days ago on 2/29/2016. The correct number is 3 which is what Win10 says. Today I uninstalled Revo Uninstaller (using Revo Uninstaller to do it) and then reinstalled it. No help.

I guess it might be OK to ignore this discrepancy but I find it surprising.

Suggestions?

-- Larry

Answer:Revo Uninstaller List Differs from Win10 Progs and Features List

Originally Posted by larrymcg


I'm running Win10 Pro 64bit and Revo Uninstaller Pro v3.1.5. There is a huge discrepancy in the installed programs lists provided by Revo Uninstaller and the Win10 Programs and Features control panel. They both say there are 83 installs (that's good). But Revo Uninstaller claims that 15 programs were installed a few days ago on 2/29/2016. The correct number is 3 which is what Win10 says. Today I uninstalled Revo Uninstaller (using Revo Uninstaller to do it) and then reinstalled it. No help.

I guess it might be OK to ignore this discrepancy but I find it surprising.

Suggestions?

-- Larry



I show same thing. You may have discovered a "leap day" bug in the Revo app. I wouldn't worry about it, honestly. It's how it calculates the term "Recently". If you use CCleaner and look at tools/uninstall it list progs. Sort descending date...you get a another answer.

1 more replies
Relevance 36.9%

I am trying to add a Microsoft Outlook 2003 Outlook Address Book | Contacts vcard to a Signature. However, when I test an email with the signature, the attached vcard contacts the data in the Global Address List, not the personal contact address list. I have tried saving the personal contact vcard to my local drive, but that did not correct the problem. How do I keep Outlook from pulling the vcard data from the Global Address List and use the personal contact data? Denzil
 

More replies
Relevance 36.9%

it's really getting annoying that i can't see any of the recent used files list as i have too many pinned list,
can i have a separate list for task bar pinned list and quick access list in explorer?

More replies
Relevance 36.9%

I have an EXTERNAL USB Drive 1gb that I use to IMAGE machines all the time.  An employee got a new laptop Dell E5470 with an M.2 Sata SSD, and when I boot this machine to the external drive to apply a new image, diskpart does not show the External HDD under List Volume or List Disk.  I have played around in the BIOS thinking because of the new M.2 Sata SSD there was a setting that was causing this but I am unable to find anything that allows this to work.  It will boot from the External Drive but when running diskpart, it will not sow the drive so I can't apply and image or take an image since I have no were to place the image or copy it from.

More replies
Relevance 36.9%

I had a distribution list for a mass email for some of our customers. But when we got Microsoft Exchange everything copied over but this one (the most important list!) did not copy over. But I checked through the sent messages and was able to copy the list from the BCC Field to a text file.

Now, I need to get this list of people back in a distribution list. If anyone knows how I can achieve this, please help me out! I've been google-ing this and cant seem to find something to work for me!
 

Answer:Solved: Import list of emails to Outlook Contacts or Distribution list

11 more replies
Relevance 36.9%

I'm running Win10 Pro 64bit and Revo Uninstaller Pro v3.1.5. There is a huge discrepancy in the installed programs lists provided by Revo Uninstaller and the Win10 Programs and Features control panel. They both say there are 83 installs (that's good). But Revo Uninstaller claims that 15 programs were installed a few days ago on 2/29/2016. The correct number is 3 which is what Win10 says. Today I uninstalled Revo Uninstaller (using Revo Uninstaller to do it) and then reinstalled it. No help.

I guess it might be OK to ignore this discrepancy but I find it surprising.

Suggestions?

-- Larry

Answer:Revo Uninstaller List Differs from Win10 Progs and Features List

larrymcg said:

I'm running Win10 Pro 64bit and Revo Uninstaller Pro v3.1.5. There is a huge discrepancy in the installed programs lists provided by Revo Uninstaller and the Win10 Programs and Features control panel. They both say there are 83 installs (that's good). But Revo Uninstaller claims that 15 programs were installed a few days ago on 2/29/2016. The correct number is 3 which is what Win10 says. Today I uninstalled Revo Uninstaller (using Revo Uninstaller to do it) and then reinstalled it. No help.

I guess it might be OK to ignore this discrepancy but I find it surprising.

Suggestions?

-- Larry



I show same thing. You may have discovered a "leap day" bug in the Revo app. I wouldn't worry about it, honestly. It's how it calculates the term "Recently". If you use CCleaner and look at tools/uninstall it list progs. Sort descending date...you get a another answer.

2 more replies