This looks to be either "Off Topic",
or a hijacked thread (meaning that someone responded to a discussion topic with
a topic of their own, thus "taking over" the discussion)
However, since Hanamant was the original Topic author,
He's hijacking his own thread.. so I guess I'll answer...
Next time, it would be a good idea to start a new topic!
---------------------------------------------------
Check out the Help topic for Filesystemobject:
As the description indicates, it:
"Provides access to a computer's file system."
The following code illustrates how the FileSystemObject is used to return a
TextStream object that can be read from or written to:
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("c:\testfile.txt", True)
a.WriteLine("This is a test.")
a.Close
In the code shown above, the CreateObject function returns the FileSystemObject:
(fs)
The CreateTextFile method then creates the file as a TextStream object
(a)
and the WriteLine method writes a line of text to the created text file.
The Close method flushes the buffer and closes the file.
Paul
________________________________
From: hanumant shinde <hanumant_5...@yahoo.co.in>
To: excel-macros@googlegroups.com; koul.ash...@gmail.com
Cc: excel-macros@googlegroups.com
Sent: Mon, December 20, 2010 3:27:52 PM
Subject: Re: $$Excel-Macros$$ Need ans for 3 que
hey ashish you have any idea about below 1 line code. can you or somebody else
explain what it does?
Dim FSO As Object
Set FSO = CreateObject("scripting.filesystemobject")
________________________________
From: hanumant shinde <arsfan2...@yahoo.co.in>
To: koul.ash...@gmail.com
Cc: excel-macros@googlegroups.com
Sent: Sun, 19 December, 2010 2:06:46 AM
Subject: Re: $$Excel-Macros$$ Need ans for 3 que
hey Ashish,
this link is too good man. THANKS A LOT DUDEEEEE. u made my day. awesome stuffs
but can u or somebody help me with below 1 line
Dim FSO As Object
Set FSO = CreateObject("scripting.filesystemobject")
what does this line do.
>
>From: ashish koul <koul.ash...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Sat, 18 December, 2010 11:26:12 AM
>Subject: Re: $$Excel-Macros$$ Need ans for 3 que
>
>unzip using vba check out this link
>
>http://www.rondebruin.nl/windowsxpunzip.htm
>
>
>On Sat, Dec 18, 2010 at 2:00 AM, Deepak Rai <daksh1...@gmail.com> wrote:
>
>Hi Rohan,
>>
>>This is really nice.
>>
>>Regards,
>>Deepak Rai
>>
>>
>>On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young <rohan.j...@gmail.com> wrote:
>>
>>Hi Hanumant,
>>>
>>>
>>>Just hit Ctrl+F go to option and in look in set the criteria on Values u
>>>will
>>>get that
>>>
>>>
>>>bye for now
>>>
>>>
>>>Deepak (ROHAN)
>>>9818247278
>>>
>>>
>>>
>>>On Thu, Dec 16, 2010 at 3:45 PM, hanumant shinde <arsfan2...@yahoo.co.in>
>>wrote:
>>>
>>>hey guys,
>>>>
>>>>need some help here.
>>>>
>>>>1. how can i get to know if a specific cell has formula or normal value?
>>>>
>>>>2. can we unzip folder or file using excel maco?
>>>>
>>>>3. if a specific cell has formula whose value is lets say "shinde" how can i
>>>>find it.
>>>>
>>>>i.e lets say A1 has value as "shinde"(its not fomula its normal string)
>>>>B1=A1 (its a formula)
>>>>now i want to find shinde in col B but its formula so i cant find it even by
>>>>Ctrl + F
>>>>so what shud b the code to find "shinde" in col B.
>>>>
>>>>thanks
>>>>hanumant
>>>>
>>>>
>>>>
>>>>--
>>>>----------------------------------------------------------------------------------
>>>>
>>>>Some important links for excel users:
>>>>1. Follow us on TWITTER for tips tricks and links :
>>>>http://twitter.com/exceldailytip
>>>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>>>>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>>>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>>>>
>>>>To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>><><><><><><><><><><><><><><><><><><><><><><>
>>>>Like our page on facebook , Just follow below link
>>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>>
>>>
>>>--
>>>----------------------------------------------------------------------------------
>>>
>>>Some important links for excel users:
>>>1. Follow us on TWITTER for tips tricks and links :
>>>http://twitter.com/exceldailytip
>>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>To post to this group, send email to excel-macros@googlegroups.com
>>>
>>><><><><><><><><><><><><><><><><><><><><><><>
>>>Like our page on facebook , Just follow below link
>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>--
>>
>>Regards,
>>Deepak Rai
>>--
>>
>>----------------------------------------------------------------------------------
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links :
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>--
>
>Regards
>
>Ashish Koul
>akoul.blogspot.com
>akoul.wordpress.com
>My Linkedin Profile
>
>PBefore printing, think about the environment.
>--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
