Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
le_a_perdu_ame
Need help writing macro to save excel file as .CSV?
I am trying to write a macro that will save a workbook as a .csv file. I would also like the user to be able to pick the path in which to save the file.
Currently I have the following code, but I keep getting an error.
Any help is appreciated!
--------------------
Sub SaveAsCsv()
Dim strFileName As String
strFileName = Application.GetSaveAsFilename(filefilter:="Comma Seperated Values (*.csv), *.csv")
If strFileName <> "False" Then
Sheets("Manual_Template").Copy
ActiveWorkbook.SaveAs strFileName, xlCSV
End If
End Sub
1 AnswerSoftware8 years agoHe can't keep a job. Love him, or leave him?
I have recently become engaged to a man who I care very deeply for; however, he has significant money issues.
Two months into dating he got fired. Since that time he has jumped from temp job to temp job for the past eight months (with gaps of unemployment in between). He has lost his apartment, had to cut off his cell phone, and now he lives at home with his mother (whom I assumed is the one that paid for my engagement ring).
In order to fix his job situation, I encouraged him to go back to school, which he did. However, he opted to seek a sterile technician certificate from a for profit organization, racking up $10,000 of student loans. The only issue is my research says these positions only pay around $11 an hour.
To make matters worse, his mother is pressuring him to stay on unemployment until it runs out in November, and just focus on school. While focusing on school would be a good idea, I suggested he capitalize on his current rent-free situation, and go get a job that will help him use the extra funds to pay down his debt. It's been a month since he moved home, and while he continues to go on job interviews, he has yet to obtain even the most mundane of minimum wage employment.
Outside of the $10,000 of student loans, he owes about $6,000 in credit card debt (accumulated before we got together, and which he has been very vigilant about not accumulating anymore) and $2,000 associated with lease breaking fees.
I know this debt is not an insurmountable amount of debt, especially since I, myself, paid off $25,000 of student loans within one year of graduating with my Masters.
However, I am very worried. I am 25 years old, and have been working for just over two years. I live debt free (I rent for $750 a month), and make about $63,000 a year. I manage my finances so I don't have to live paycheck to paycheck and I currently have $35,000 in liquid savings.
I love this man, but I am not willing to support him. He has only asked me for money once, when he was getting evicted from his apartment, and as hard as it was to say "NO", I did. He keeps promising me that in December when he graduates everything will change, but I just don't know. For almost the entirety of our relationship I have dealt him being unemployed/severely under-employed. I want to believe him that in December everything will change, but I also don't want to waste even more of my time on someone who will never be able to support himself.
My family tells me to leave him, but I don't want to be the type of girl who dumps a guy just because he doesn't have enough money. I don't need a man to support me; I just need one who can support himself.
I just don't know what to do. I love his companionship, but I don't know how much longer I can stand his financial situation! What should I do??
8 AnswersMarriage & Divorce9 years agoSamsung Galaxy S III - what color is the water sensor?
I just bought my phone 3 days ago, and was about to return it(phone is really glitchy) when I accidentally dropped it in the toilet.
How can I tell if there has been water damage?
What color is the moisture sensor suppose to be?
Right now I have it sitting in rice, and I immediately pulled the battery out. Any suggestions on how to save my phone?
Thanks!!
3 AnswersCell Phones & Plans9 years agoJust watched "200 Pound Beauty" and LOVED IT!! Any other good similar movies out there?
http://www.youtube.com/watch?v=3d1QkzZufR0&sns=fb
Watched the movie after a friend recommended it, would love to watch some similar movies.
Suggestions appreciated, thanks!
1 AnswerMovies9 years agoNeed a movie suggestions! Difficulty - Limited to Netflix Watch Instantly?
Movies I have watched and like:
Prince of Persia
Star Trek
300
Troy
Braveheart
.... if you can't tell I am on an action movie bender - lol
Suggestions very much appreciated!
3 AnswersMovies1 decade agoI am 22 years old and have only had my period once in the past year ....?
First of off to answer the obvious question - I am NOT pregnant, I am not sexually active and I have taken multiple pregnancy tests.
I have been rather stressed out, and have gained about 10-20 lbs over the past two years ... would this explain the lack of a menstrual cycle?
Also, in the last couple of months I have been getting increasingly more depressed, could this be related?
I know I should go see a doctor, but i dont have health insurance and I dont really think a lack of a period is anything serious to waste money over, but its been really bothering me. Anyways what could a doctor do to fix it? are there pills for this sort of thing?
Has this ever happened to anyone else? Thanks in advance
3 AnswersWomen's Health1 decade agoLooking for some summer travel ideas?
A couple of years ago I went to Hong Kong over the summer and had a blast, now I need some ideas for my next great adventure - please help!
I am looking to spend a week or two, and ideally somewhere an "english-only speaker" can easily get around.
Thanks in advance!
7 AnswersOther - Destinations1 decade agoInternet Help! If I dont type in "www" in the navigation bar it takes me to a ask.com search engine!?
Its really annoying and I dont know how to change this. If I dont specifically type in "www" I am immediately redirected to an ask.com search engine. I unistalled the ask.com toolbar from my browser and reinstalled the google toolbar, but it still does it.
Any clues on how to fix it??
Btw the browser I am using is Internet Explorer.
8 AnswersOther - Internet1 decade agoIs this copyright protectable?
Can you claim copyright protection of an overall organizational scheme?
For example, is the way I organize a numbering system copyrightable?
1 AnswerLaw & Ethics1 decade agoHow can I find a lost relative using the internet?
I have an uncle who cut off all contact with the family about 20 years ago, my grandmother is sick and she really wants to know if he is okay.
What would be the best way to find him? I know he probably doesn't want to talk with us, but I just want to figure out if he is still alive and where he is living.
I have all his information ( I am not sure if I have his correct SSN - but I have everything else) - is there any legitimate website I can use to find him?
Thanks!
1 AnswerFamily1 decade agoWhat is the next number in the pattern 1,5,14,30...?
What is the next number in the pattern 1,5,14,30...?
help please!
10 AnswersHomework Help1 decade agoU.S. Post offices role in the deficit ?
My professor told me to look up a report released recently that discussed the U.S. post offices role in the current deficit, but I cant find it.
Does anyone know what he could have been talking about? Links are helpful or just a 2-3 sentence summary of what the issue is works as well.
Thanks!
1 AnswerOther - Politics & Government1 decade agoLooking for decent laptop under $450... help?
I need a laptop to use a couple days a week when I am traveling and away from my main computer. It doesn't need to be fancy, just needs to get the job done. I am looking for:
- decent battery life
- needs to have a media card reader (like for a SD memory card)
- preferably under 7 lbs
- around $450
anyone know of any good deals out there right now? I not really tech savy, so thanks in advance!
6 AnswersLaptops & Notebooks1 decade agoIn a joint venture, can one company eventual acquire the other?
For example, if Company A has a joint venture with company B and the venture is very successful. In a few years will company A be able to acquire company B and then the joint venture will be more of a wholly owned subsidiary??
I think I have the concepts confused - so thanks in advance for the help!
1 AnswerOther - Business & Finance1 decade agoWeird symptom - leg weakness?
When I got out of bed this morning I suddenly lost all strength in my left leg and collapsed to the floor. I couldn't support any weight.
Now all day I've been feeling sluggish, and I cant seem to move very fast (just walking is really tiring).
Any ideas? I am young (22) so I dont think its anything to serious, but I don't have insurance so I don't want to go to a doctor.
Has this ever happened to anyone else before?
Thanks!
1 AnswerOther - Health1 decade agoMy computer mouse is acting funny - how do I fix?
Its acting hyper sensitive. For example when I try to click on a box online (like check something off), it checks and unchecks with one click.
Plus if I have to windows up on top of each other, if I close one it clicks through and closes that window and the one behind it - even though I am only clicking one time.
Anyone have any idea how to fix this? It super annoying.
Thanks!
2 AnswersAdd-ons1 decade agoNeed help with haircut!?
I have very long, dark brown hair, and a slightly large forehead and long oval face.
Can anyone suggest a hairstyle with bangs that would look good? I am looking for bangs that I can maybe wear parted in the middle - pictures are appreciated!
Thanks!
6 AnswersHair1 decade agoWhen filing a tax return how many years do you have to say FKA when a company changes it's name?
thanks! quick 10 points if you know :)
1 AnswerUnited States1 decade agoHow long do you have to state "formerly known as" on legal documents?
I am filling out paper work, how many years have to pass before I can drop out the "FKA" (formerly known as) part?
1 AnswerLaw & Ethics1 decade agoAnalog vs. Digital - Benefits/drawbacks?
I have to write a paper for my business ethics class about the benefits and drawbacks of switching from analog to digital. However, I am totally tech retarded, so if some could explain some of them in laymen terms I would appreciate it.
Thanks!
2 AnswersTVs1 decade ago