Oh yeah!  I saw that no subject and just the email addy (a clue) so I didn't open it. Lots of people getting "infected" and the deadly programs look so "legitimate". Beware Vista users too, as a program comes up; Win 7 too.  One way to "stop" the popup boxes is to hit ALT+F4 and don't click on anything, not even to close the boxes telling you a scan or an infection was detected! (only makes things worse!)!  Or shut down and get out using CTRL+ALT+DEL to run Task Manager, close all programs and shut down safely.  Then SCAN and SCAN again.  (Comprehensive Scan)  My son had unwittingly allowed what looked like legit anti-virus to run which disabled his computer completely. We had to take it back to factory!  (He's not on my network, but next door.  Norton helped us get everything back to be useable, but all data was infected and lost.)  My mother had something come in & called me immediately w/o closing or clicking anything.  (also next door and we were able to catch it (Norton did catch it as well) an "intrusion was blocked"... I did the above, shut down, scanned, scanned again,  and she's fine.     Another friend suggests a malware removal tool in addition to Anti-virus but I misplaced the link. I'm sure it can be found on-line and is free, but be careful what you downlaod!   Also, Back up your files before these things hit, change passwords where you can too.  My son found a "Fix" for a Vista intrusion that scared me to death, saved it to my desktop via phone as I rapidly typed the "fix" into a Notepad and then opened it.  Not everyone is as lucky to have good, fast help.    These are just suggestions that worked for me to remain (so far) pretty free of these buggers!   (Delete your history too and allow critical automatic updates as the fixes come thru that as well) Hope this helps some who may be new to all "this".  But do your own searches on what I've said here too.  Don't just take my word for it.  Different systems respond in different ways...) Happy computing!   Kathie B. --- On Tue, 10/19/10, Freeps List Admin <freepages-help-admin@rootsweb.com> wrote: From: Freeps List Admin <freepages-help-admin@rootsweb.com> Subject: [FreeHelp] ADMIN NOTE: Trojans and loggers, oh my! To: "Freepages-Help" <Freepages-Help@rootsweb.com> Date: Tuesday, October 19, 2010, 3:31 PM A recent sp*m post to the list was not intentionally sent by the list member.  His/her computer has been compromised by malware that plants a trojan or key stroke logger on a computer and can then take over that computer to do many things, including sending sp*m emails to any and all email addresses located in files on the compromised computer.  That member, and any other member whose computer is compromised will be placed on moderation until they verify to me that the problem has been corrected. However, before you become a victim and have a compromised computer, remember that the consequences for the owner of the computer may be even more serious that sending unwanted emails.  The trojan may also be copying personal information stored on your computer, e.g. your social security number, medical records, the name of your bank, the password you use for online banking, -- the list is as long as the list of things for which you use your computer. Please folks -- protect yourselves. Use a firewall. Install an anti-virus program and keep it updated. Run a malware detection program regularly if your AV program does not include one.  You can also run one of the freebies such as AdAware in addition to your AV program. Do not click on links in emails sent to you by people you do not know Even if you do know the person who supposedly sent you the link, check it out before clicking on the link.  Links do not necessarily go to the site they say they do. Do not allow programs to make changes to your computer unless you verify the source of those changes. If you visit a web site and are asked to download something or update a program on your computer, and your AV program pops up a warning, READ and HEED that warning.  Many  malware authors are adept at making malware appear to be an authentic update to a popular program. Pat Asher Freepages List Admin ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Pat said: > I thought they used to have a FREE version They still do. :-) It is free to download the program and install it on your computer. http://legacyfamilytree.com/DownloadLegacy.asp What you have when you've installed that is the Standard Edition. A perfectly fine genealogy program with loads of tools and features. However, if you choose to pay their fee for the Deluxe Edition you'll be sent a "key", a code to unlock the additional features. You can see at that link above what you get in each Edition. I have the Deluxe, have had for several years now. It's the only genealogy program I've used for my records, though I've looked at one or two others out of curiosity. Looking at the lists on that page above, the Deluxe features I make the most use of are mapping, the relationship calculator, pdf production, and the ability to add a variety of documents. That's just my preferences. Deluxe and Standard users can swap data files between themselves without problem. The Standard user simply won't be able to access the fields that are Deluxe-only, but they're still there in the file. There's also excellent peer-to-peer support at their free mailing list, Legacy User Group - http://legacyfamilytree.com/LegacyLists.asp Hope this helps. :-) Kind Regards, Wendy Howard *** Please reply to the list *** -- Kaiwaka, Northland, New Zealand http://freepages.rootsweb.ancestry.com/~wendyh65/ <http://freepages.genealogy.rootsweb.com/%7Ewendyh65/>

Thanks everyone!  I also saw the free video tutorials and watched them first. I did get the 7.0 Deluxe verision and the cd to upgarde to 7.4 and a huge book!   Scared to death to overwrite all my paf files in .zip by 'importing' PAF; I need to backup everything before I install this program.  I'm not sure how to "import" a PAF .zip file?  I would think I would have to unzip it first.  Don't wnat to create conflicts or lose my hard work.  Anyone here deal with this issue?   The free version was recommended by one Charles Bourland Rice, Jr. who has a neat genealogy "how-to" site (and is published)and also some ancestors possibly in common with me, or knows his neighbors may.   Sorry somewhat OT but perhaps the .zip file question is applicable to rootsweb as well?  I thank you all for your emails and private replies.  A great group as per usual!   Kathie B.   --- On Mon, 10/18/10, Wendy Howard <wendy.howard@gmail.com> wrote:   Pat said: > I thought they used to have a FREE version They still do.  :-) It is free to download the program and install it on your computer.  http://legacyfamilytree.com/DownloadLegacy.asp

I have used Legacy for several years. Just the free version. I understand it fairly well. BUT my web pages are my research tool. As I argue/discuss my reasons etc on them. When new cousins find me I use Legacy to produce Ancestor reports Ron Lankshear -Sydney NSW (from London-Shepherds Bush/Chiswick) try my links http://freepages.rootsweb.ancestry.com/~lankshear/ On 2010-10-19 8:04 AM, Ralph Taylor wrote: > .. I'd like some opinions on the product ('Legacy' > genealogy software) before I open it!?" >

At 05:04 PM 10/18/2010, Ralph Taylor wrote: >Kathie B. asked: ".. I'd like some opinions on the product ('Legacy' >genealogy software) before I open it!?" > >Legacy is a good genealogical database for recording your research results. >It has been around for many years, now in its 7th(?) version. It's among the >best, and best-known, of such programs; it's the favorite of many. ============== I thought they used to have a FREE version that I had used because I like some of the things you could do that you could not in PAF which I have used since it first came out. Pat

Kathie B. asked: ".. I'd like some opinions on the product ('Legacy' genealogy software) before I open it!?" Legacy is a good genealogical database for recording your research results. It has been around for many years, now in its 7th(?) version. It's among the best, and best-known, of such programs; it's the favorite of many. -rt_/)

At 11:33 AM 10/17/2010, Kabe wrote: >Can you all let me know if you are receiving my posts of late? I >haven't seen them coming thru, and some of yours including this one >are going into my Junk/Spam Folder. Kathie, You can see if your posts have been sent to the list by checking the archives, http://archiver.rootsweb.ancestry.com/th/index/freepages-help/ What is done with mail sent to you from the list is determined by the settings you have in place for filtering incoming mail. Pat Asher

I received this message via the list. Ron Yates Can you all let me know if you are receiving my posts of late? I haven't seen them coming thru, and some of yours including this one are going into my Junk/Spam Folder. Thanks! Kathie B.

Thanks, Pat.  I did find my posts using the search engine with my email addy.  For the ones not sent to the group, perhaps I didn't  hit "reply all" and just replied to an individual (Whipple).  Not really important. I love the archives!  Thanks for the reminder, so I don't ask questions that have been asked a gazillion times before. I am learning HTML finally.   I'll check my settings as my own email is also coming into Junk at times. It's odd that so many from the list come thru in my Inbox, and others, randomly are selected for Junk.  I do mark them as safe and put them into my Inbox. Time for some 'housecleaning' and password changes (as well as adding everyone on the list to my addy book?  That's alot of people!)   Thanks again, everyone!     Kathie B. --- On Sun, 10/17/10, Pat Asher <pjroots@att.net> wrote: From: Pat Asher <pjroots@att.net> Subject: Re: [FreeHelp] Test to group (was Excel auto numbering,etc.) To: "Freepages-Help" <Freepages-Help@rootsweb.com> Date: Sunday, October 17, 2010, 12:39 PM At 11:33 AM 10/17/2010, Kabe wrote: >Can you all let me know if you are receiving my posts of late?  I >haven't seen them coming thru, and some of yours including this one >are going into my Junk/Spam Folder. Kathie, You can see if your posts have been sent to the list by checking the archives, http://archiver.rootsweb.ancestry.com/th/index/freepages-help/ What is done with mail sent to you from the list is determined by the settings you have in place for filtering incoming mail. Pat Asher  ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Thank you all for your quick replies and a few personal replies also!  I won't take up space and time of all of you with replies to all who responded. Yahoo has been giving me a few problems lately.  I've heard others also are having problems.  A lot of emails are getting 'highjacked' and spam is pouring into many groups. I didn't find any of my recent posts to the group in my 'Sent' folder either, so I thought I'd ask.  May be time to change passwords on email accts. That seems to stop most email problems.  Thanks again, Kathie B. --- On Sun, 10/17/10, Ron Yates <ron@yatesville.net> wrote: From: Ron Yates <ron@yatesville.net> Subject: [FreeHelp] Can you all let me know if you are receiving my posts of late? To: "com FREEPAGES-HELP@rootsweb." <FREEPAGES-HELP@rootsweb.com> Date: Sunday, October 17, 2010, 11:40 AM I  received this message via the list.  Ron Yates Can you all let me know if you are receiving my posts of late?  I haven't seen them coming thru, and some of yours including this one are going into my Junk/Spam Folder.   Thanks!  Kathie B. ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Can you all let me know if you are receiving my posts of late?  I haven't seen them coming thru, and some of yours including this one are going into my Junk/Spam Folder.   Thanks!   Kathie B.  (Also, somewhat unrelated: my son bought me some "Legacy" genealogy software for my birthday and I'd like some opinions on the product before I open it!  Thanks again!)   -- On Sat, 10/16/10, Barry Carlson <barrycarls@gmail.com> wrote: From: Barry Carlson <barrycarls@gmail.com> Subject: Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering To: freepages-help@rootsweb.com, "Nick Reddan" <nickred@webone.com.au> Date: Saturday, October 16, 2010, 5:05 AM Nick Reddan's example of creating an HTML table format within the spreadsheet is a good one. I've had a look at it and found that one stage can be eliminated, and when the spreadsheet example found at:- http://countjustonce.com/test/simple-table.html - is opened, the formula found in cell G11 is all that is needed to copy the table to its left. Just copy and "fill down" the desired number of rows and the table will be copied over complete with the HTML formatting. The additional HTML formating above and below the table contents is also entered in column "G" using the standard format in the formula field, e.g ="<!doctype html>'" etc.. To copy the result into your text editor, just highlight, copy and paste the contents in column "G" into your editor and save. Thanks Nick for sharing the simplified HTML table generation method. Barry ------------------------------- To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Nick Reddan's example of creating an HTML table format within the spreadsheet is a good one. I've had a look at it and found that one stage can be eliminated, and when the spreadsheet example found at:- http://countjustonce.com/test/simple-table.html - is opened, the formula found in cell G11 is all that is needed to copy the table to its left. Just copy and "fill down" the desired number of rows and the table will be copied over complete with the HTML formatting. The additional HTML formating above and below the table contents is also entered in column "G" using the standard format in the formula field, e.g ="<!doctype html>'" etc.. To copy the result into your text editor, just highlight, copy and paste the contents in column "G" into your editor and save. Thanks Nick for sharing the simplified HTML table generation method. Barry

I have added a version of the file for earlier versions of Excel. http://members.iinet.net.au/~nickred/temp/little_table.htm Open Office will open these files also. Regards /Nick/ Home http://members.iinet.net.au/~nickred/ <http://members.iinet.net.au/%7Enickred/> Sites managed http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/index.html <http://freepages.genealogy.rootsweb.ancestry.com/%7Eregistryofdeeds/index.html> http://www.igrsoc.org/index.htm http://members.iinet.net.au/~nickred/majuratennis/ <http://members.iinet.net.au/%7Enickred/majuratennis/>

There is an easy way to convert Excel tables without formatting to HTML tables using formulae. in say cell "K3" put the following formula ="<td>&A3&"</td>" Copy this formula down and across to get the rows and columns you want. Then in a cell further to the right put the following formula ="<tr>"&K3&L3&M3&"</tr>" for a three column table concatenate more cells between the "<tr>" and "</tr>" for wider tables Put a <table> above and </table> below then copy into your text editor and the code will produce the table data without any extraneous formatting. See: http://members.iinet.net.au/~nickred/temp/little_table.htm Regards /Nick/ Home http://members.iinet.net.au/~nickred/ <http://members.iinet.net.au/%7Enickred/> Sites managed http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/index.html <http://freepages.genealogy.rootsweb.ancestry.com/%7Eregistryofdeeds/index.html> http://www.igrsoc.org/index.htm http://members.iinet.net.au/~nickred/majuratennis/ <http://members.iinet.net.au/%7Enickred/majuratennis/>

Just a further comment that I've said before but I failed to state in the "tip" email I sent earlier... I can't open the Excel sheets because my Excel is older than the submitter's program and I've not had extra time to learn a different program (like Open Office). When I saw that gmail could open files in a browser, it means I don't have to worry about using a program. My method of opening the sheet in a browser and then switching Excel code to what I want in HTML may not be the best for everyone, but it is working for me. I've identified "effects" I hate (like valign=top or valign=bottom for cell data) and I remove the "ickky" code along with fonts, etc. My biggest problems have been those Excel headers, the number column, and trying to adjust really wide columns to smaller columns. The header and numbers have been the worst issues for me, so I was tickled to find a solution. Some other method may be better for other people, but using Find/Replace gives me control over what I'm changing or taking out. Plus, it helps me learn more about what the codes are doing (especially the Excel code effects I don't like--LOL). Judy On Fri, Oct 15, 2010 at 7:54 AM, J.A. Florian <cageycat@gmail.com> wrote: > In Excel, if you have a simple table, 7 columns across, however long with > the the A - B - C column headers and auto numbering "on", although it is > easy to remove the A-B-C Row, it can be a big pain to get the numbes to go > to "Normal" and not be bold and huge. > > People often send me Excel sheets as submissions. When I get cemetery > databases on Excel, there's a lot to do to change it to HTML code. I open > it in Google, go to View Source, then start stripping out all the code I > don't want with Find>Replace. I took out all instances of "bold" and > "font". I'm left with the table row and column and widths, and of course > the data. > > I then copy it to Frontpage. In Frontpage2000, the settings on the stripped > file showed Normal formatting, Normal Font, Normal Size. But I still had > Excel A-B-C and numbers in the first column-- big and bold. I highlighted > the column and tried to use the Bold command to make sure it wasn't really > bold-- it wasn't, so no effect. The numbers were also centered, even though > it wasn't found in the code. I could not see in the coding what code > controls the numbering in the stripped Excel to HTML code. > > Well, I finally found how to make the row numbering go back to Normal > looking. I highlighted the column and went to Cell Properties. There, I > saw a check mark next to "Header Cell". When I unchecked it, the numbers > look like the rest of the page. I then "cut" the A-B-C header row too. > > Interestingly, the code in the table looks exactly the same as before I > found that check-box. So I thought I'd pass along this tip in case other > people come across the same problem. It can save hours of trying to > manually re-enter the numbers in HTML. I'm not sure how you'd find or > fix the "problem" if not using a WYSIWYG Editor. > > Only thing I haven't found a way to fix is that the numbering in Excel > starts on the A - B - C column header, not on line 1 of data. So if Excel > says there are 816 burial names, it's actually 815 minus the A-B-C header > row (which is removed). To save time, I end up putting a "Note" that the > numbering is one-off rather than re-typing numbers. > > Judy > -- -- WASHINGTON COUNTY PA WEBSITES::: http://freepages.misc.rootsweb.com/~florian/ Coordinator of the Washington County PAGenWeb: http://www.rootsweb.com/~pawashin/

I shall not be available before 20-10-2010. I am away until Wednesday morning, when I will answer your mail. Note: This is an automated reply to your message "FREEPAGES-HELP Digest, Vol 5, Issue 219 "posted on 15-10-2010 09:00:32. This is the only advice you will receive while this person is unavailable. **************** A rough translation of the previous mail. Barry

I was transcribing the 1930 Hot Springs County Wyoming census and used Open Office spreadsheet to enter the data. When I got done I saved as HTML and added the top of the page and end. The code generated by the spreadsheet program was very minimal. On 10/15/2010 02:58 PM, Ralph Taylor wrote: > To convert an Excel (or other spreadsheet) table to HTML, I prefer the > method introduced here by Barry Carlson a few years ago. It involves saving > the file as plain text before converting it to HTML. > > One advantage is that it requires knowing only those few HTML codes used in > tables. It is the most efficient procedure I've found for producing a HTML > table from spreadsheet data without "code bloat" and I've used it many > times. > > Step-by-step: > 1. Insert a new, blank column before the first column of data and columns > between each data column. This avoids over-writing the data with HTML codes. > > > 2. On a blank row before the data, enter the table-opening tag,<table>; on > a blank row after the data, enter the closing table tag,</table>. > > 3. In the first column (the one you inserted), enter the codes to open a > table row and a table cell,<tr><td>. For the header row, substitute > <tr><th>. Copy the<tr><td> codes all the way down the column to the end of > the table. > > 4. Between data columns, enter the codes to close one cell& open another, > </td><td>. (Header row:</th><th>.) Copy the codes all the way down the > table. > CSS: If you want CSS styling of some cells, step 4 is the time to > specify the class. > > 5. In the column after the data, enter the codes to close a cell and a row, > </td></tr>. Copy the codes all the way down the table. > > 6. IMPORTANT! "Save as" the file as a plain text file, with a .txt file name > extension. DO NOT SAVE AS WEB PAGE! This strips out any formatting that > hasn't been given a HTML code. (You'll notice that the text file has tab > spaces between each former Excel cell, you can use Control-H to strip these > out if desired.) > > 7. Open the file in Notepad or other plain-text editor; alternatively, open > it in your Web editor. Add in the other stuff (doctype, document header, > body tags, includes, etc.); if you've created a template, you'll mostly copy > and paste. > > 8. "Save as" the file with a .htm extension. > > You now have an HTML file with only the formatting that you specifically > choose. There is no bloated code to strip out. You can continue to work with > it in your Web editor. > > Two tips: > 1. It's helpful to use a second version of the file, so that the original is > available in case of mistakes. Save the second version frequently during the > processing. > 2. For multi-column tables, I like to start with the last column and work > from right to left. > > -rt_/) > > > > ------------------------------- > To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > > -- "A good moral character is the first essential in a man." George Washington

To convert an Excel (or other spreadsheet) table to HTML, I prefer the method introduced here by Barry Carlson a few years ago. It involves saving the file as plain text before converting it to HTML. One advantage is that it requires knowing only those few HTML codes used in tables. It is the most efficient procedure I've found for producing a HTML table from spreadsheet data without "code bloat" and I've used it many times. Step-by-step: 1. Insert a new, blank column before the first column of data and columns between each data column. This avoids over-writing the data with HTML codes. 2. On a blank row before the data, enter the table-opening tag, <table>; on a blank row after the data, enter the closing table tag, </table>. 3. In the first column (the one you inserted), enter the codes to open a table row and a table cell, <tr><td>. For the header row, substitute <tr><th>. Copy the <tr><td> codes all the way down the column to the end of the table. 4. Between data columns, enter the codes to close one cell & open another, </td><td>. (Header row: </th><th>.) Copy the codes all the way down the table. CSS: If you want CSS styling of some cells, step 4 is the time to specify the class. 5. In the column after the data, enter the codes to close a cell and a row, </td></tr>. Copy the codes all the way down the table. 6. IMPORTANT! "Save as" the file as a plain text file, with a .txt file name extension. DO NOT SAVE AS WEB PAGE! This strips out any formatting that hasn't been given a HTML code. (You'll notice that the text file has tab spaces between each former Excel cell, you can use Control-H to strip these out if desired.) 7. Open the file in Notepad or other plain-text editor; alternatively, open it in your Web editor. Add in the other stuff (doctype, document header, body tags, includes, etc.); if you've created a template, you'll mostly copy and paste. 8. "Save as" the file with a .htm extension. You now have an HTML file with only the formatting that you specifically choose. There is no bloated code to strip out. You can continue to work with it in your Web editor. Two tips: 1. It's helpful to use a second version of the file, so that the original is available in case of mistakes. Save the second version frequently during the processing. 2. For multi-column tables, I like to start with the last column and work from right to left. -rt_/)

Thanks to everyone for your help. Nice to know that everyone that has Microsoft Powerpoint or Open Office Presentation can create transparent (or water marks) and then safe and use the image. Again THANKS to everyone, Dave Sloan Grandkids Ancestors LLC Specializing in East central IN, West central Ohio, Quaker Records, and Brethren Records. "The world is my country and my religion is to do right" David Hoover 1781-1866

Not quite on topic but I often finds when copying HTML to Excel I pick up a graphic that is impossible to delete. Delete the cell or row and it moves up one. I found a macro to delete graphics and that does the trick. Ian Singer -- ========================================================================= See my homepage at http://www.iansinger.com hosted on http://www.1and1.com/?k_id=10623894 All genealogy is stored in TMG from http://www.whollygenes.com Charts and searching using TNG from http://www.tngsitebuilding.com I am near Toronto Canada, can I tell where you are from your reply? =========================================================================