"If he didn't get money, than I apologize for this post."
If he did get money, you should still apologize. It's really none o' your beeswax where he gets his money.
Personally, I really could care less if he got money from RedHat. The point is, he doesn't charge me for his...
There are 2 reasons behind the monolith that is Bill Gates:
- He takes gambles
- He is utterly ruthless
The big gamble he took was when he contracted with IBM without an operating system to put on the PC's they were going to roll out. He then acquired (not wrote, acquired) DOS and the rest is...
Every year with every new release of the zillions of Linux distributions out there, it has become easier and easier to install with more and more drivers for standard and non-standard hardware. I personally have made the "switch" - I still run XP, but my wife uses it mostly. I built...
Check out http://caffeinedout.com/ui (has some humor related to techies in general and the MS Chairman in particular). I think his evil twin cyborg 2nd cousin twice removed Phil Bates lives there.
Everybody's responses have been enormously helpful and have saved me a ton of time and aggravation.
Thanks.
If you guys want a chuckle, go to http://caffeinedout.com/ui (not an ad - just some not-for-profit techie humor).
So how would I handle this section:
newFileName="C:\test.csv"
xlApp.Workbooks.Open "C:\Book1.xls"
xlApp.ActiveWorkbook.SaveAs newFileName, 6, false
Would newFileName be set equal to objFile concatenated with .csv? (What is the concatenation opertor?)
And when you do the...
Thanks much. Worked like a charm on the test file I had set up.
If I had 20 files in a directory, could I loop it and use variables to have it run through all 20 files, and name the .csv file the same as the .xls file it opened?
If that's possible, how could you read the contents of the...
Does anyone know any vbscript code that will open a bunch of excel spreadsheet (.xls), save them as character-separated value text files (.csv), and then close them?
I'm not very good at this language (I usually program in Perl) and I just need something to perform this seemingly simple task...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.