Hi Macros,,,,,,,,,,,,,,,,,
How could we fix the date format to "DD/MM/YY". So, If we enter other
format it should convert to "DD/MM/YY"
Ex: I want like DD MM YY only
24/11/1985 --- This is correct format
11/24/1985 ---- this should convert into 24/11/1985 automatical how it is
possible.... pls help me.......
Thanks
Sai
+91 96669 31919
On 23 September 2011 05:26, <excel-macros@googlegroups.com> wrote:
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
> - [No Subject] <#132939250e1a5959_group_thread_0> [2 Updates]
> - Convert txt file to xls <#132939250e1a5959_group_thread_1> [4
> Updates]
> - Export Data <#132939250e1a5959_group_thread_2> [1 Update]
> - Increasing rows in Excel 2010 <#132939250e1a5959_group_thread_3> [2
> Updates]
> - I need your help - Urgent <#132939250e1a5959_group_thread_4> [2
> Updates]
> - Required Latest No. of Drawing -
> Help<#132939250e1a5959_group_thread_5>[1 Update]
>
> Topic: [No
> Subject]<http://groups.google.com/group/excel-macros/t/6026fe9fd49d7639>
>
> naanu v <naanu2...@gmail.com> Sep 22 09:20PM +0530
> ^<#132939250e1a5959_digest_top>
>
> kindly provide macro for Index formula
>
>
>
>
> XLS S <xlst...@gmail.com> Sep 23 05:01AM +0530
> ^<#132939250e1a5959_digest_top>
>
> please specify requirement and condition
>
>
> --
> .........................
>
>
>
> Topic: Convert txt file to
> xls<http://groups.google.com/group/excel-macros/t/ed925791abadc651>
>
> Sandeep Pathak <sandeeppathak...@gmail.com> Sep 22 03:50AM -0700
> ^<#132939250e1a5959_digest_top>
>
> Dear Team,
>
> Is there any way to convert text file to excel, except change of
> extension name...
>
> Please advise...
>
> Regards,
> Sandeep
>
>
>
>
> Ram Naresh Verma <rnverma2...@gmail.com> Sep 22 11:05PM +0530
> ^<#132939250e1a5959_digest_top>
>
> sandeep,
>
> go to command prompt
> go to the directry where the txt file exist
> use command ren abc.txt cld.xls
> it will definately work....
> i had tried the same...
>
> On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak
>
> --
> Regards,
> Ram Naresh
>
>
>
>
> Paul Schreiner <schreiner_p...@att.net> Sep 22 10:56AM -0700
> ^<#132939250e1a5959_digest_top>
>
> Keep in mind that an Excel file is more than a file extension!
>
> What you're asking is best answered if we know your INTENT.
>
> The only way (that I know of) to make a text file into an Excel file is
> to open
> it in Excel and allow Excel to load the data into an Excel format and
> then save
> the file.
>
> changing the file extension doesn't change the FILE, what it does is
> tells Windows to use Excel when opening the file.
> You could do the same thing by changing the Windows File associations
> to use
> Excel.exe
> to open any file with a .txt extension.
> But when Excel opens the file, it will STILL need to use some mechanism
> to
> "import" the data and display it in an Excel format.
>
>
> So your question:
> Is there any way to convert text file to excel, except change of
> extension
> name...
>
> does not make sense from the standpoint that changing the extension
> does NOT
> convert the text file to Excel.
>
> So, either I'm misunderstanding what you mean by "convert text file",
> or at the
> least, we need
> to understand what it is you're trying to accomplish...
>
>
>
> Paul
> -----------------------------------------
> “Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -----------------------------------------
>
>
>
>
> ________________________________
> From: Ram Naresh Verma <rnverma2...@gmail.com>
> To: excel-macros@googlegroups.com
> Sent: Thu, September 22, 2011 1:35:36 PM
> Subject: Re: $$Excel-Macros$$ Convert txt file to xls
>
>
> sandeep,
>
> go to command prompt
> go to the directry where the txt file exist
> use command ren abc.txt cld.xls
> it will definately work....
> i had tried the same...
>
>
> On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak <
> sandeeppathak...@gmail.com>
> wrote:
>
> Dear Team,
>
> ><><><><><><><><><><><><><><><><><><><><><><>
> >Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> Regards,
> Ram Naresh
> --
>
>
> ----------------------------------------------------------------------------------
>
> 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/discussexcel
>
>
>
>
> XLS S <xlst...@gmail.com> Sep 23 04:56AM +0530
> ^<#132939250e1a5959_digest_top>
>
> Use export and import function or right click on ur txt file and open
> with
> excel
>
> On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak
>
> --
> .........................
>
>
>
> Topic: Export
> Data<http://groups.google.com/group/excel-macros/t/aa8372b8fa1d73b5>
>
> "dguillett1" <dguille...@gmail.com> Sep 22 08:55AM -0500
> ^<#132939250e1a5959_digest_top>
>
> I would copy the sheet to the desktop and save as and close
>
> Sub CopyDetailsToDesktopSAS()
> mydesktop = Environ("userprofile") & _
> Application.PathSeparator & "Desktop" & _
> Application.PathSeparator
>
> mypath = ActiveWorkbook.Path
>
> With Sheets("Details")
> .Copy
> newname = .Name & " - " & Format(Date, "mm-dd-yy")
>
> With ActiveWorkbook
> .SaveAs Filename:=mydesktop & newname & ".xls"
> .Close
> End With
>
> End With
> ChDir mypath
> End Sub
> From: Mr Excellent
> Sent: Thursday, September 22, 2011 12:29 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Export Data
>
> Hi Group
>
> I have a spread sheet which has 3 TABS and the last tab is saved with
> the required information and i need a VBA code for exporting only the TAB
> named as "Details" to be exported on my desktop with xls format and file
> which has to be saved should be named as "Details - Present Date(
> DD-MM-YYYY).xls"
>
> Could anyone help me on this.
>
> Thanks
> Prasad
> --
>
>
> ----------------------------------------------------------------------------------
> 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/discussexcel
>
>
>
> Topic: Increasing rows in Excel
> 2010<http://groups.google.com/group/excel-macros/t/6a05e09f6cbf5b02>
>
> NOORAIN ANSARI <noorain.ans...@gmail.com> Sep 22 04:49PM +0530
> ^<#132939250e1a5959_digest_top>
>
> Thanks Kanwaljit..
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<
> http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/* <
> http://noorain-ansari.blogspot.com/>
>
>
>
>
> Chandra Shekar <chandrashekarb....@gmail.com> Sep 22 03:20PM +0200
> ^<#132939250e1a5959_digest_top>
>
> Thank a lot Noorain :-)
>
>
>
>
> Topic: I need your help -
> Urgent<http://groups.google.com/group/excel-macros/t/ff961dc3b60676c9>
>
> Amresh Maurya <amreshkushw...@gmail.com> Sep 22 04:05AM -0700
> ^<#132939250e1a5959_digest_top>
>
> Thank you so much..
>
> perfect..
>
> Regards
> Amresh
>
>
>
>
>
> Amresh Maurya <amreshkushw...@gmail.com> Sep 22 04:12AM -0700
> ^<#132939250e1a5959_digest_top>
>
> Hi Noorain,
>
>
> I Read your Excel poem on your blog : *
> http://noorain-ansari.blogspot.com/.*
>
> Awesome... Keep on..
>
>
> Regards
> Amresh
>
>
>
>
> Topic: Required Latest No. of Drawing -
> Help<http://groups.google.com/group/excel-macros/t/22fe3f2f44e253bb>
>
> "dguillett1" <dguille...@gmail.com> Sep 22 07:34AM -0500
> ^<#132939250e1a5959_digest_top>
>
> Can you provide an AFTER example
>
> -----Original Message-----
> From: Rohan Young
> Sent: Thursday, September 22, 2011 2:30 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>
> ---------- Forwarded message ----------
> From: Rohan Young <rohan.j...@gmail.com>
> Date: Tue, Jul 26, 2011 at 2:22 PM
> Subject: Required Latest No. of Drawing - Help
> To: excel-macros@googlegroups.com
>
>
> Dear Experts
>
> I want to make a list drawing in which i required only latest revision
> of drawings it can be R3, R5, i need only latest version rest of
> previous i do not required in that list please help me out with any
> formula or vba code (see attachment)
>
> Thanks & Regds,
>
> --
>
>
> ----------------------------------------------------------------------------------
> 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/discussexcel
>
>
>
> --
>
> ----------------------------------------------------------------------------------
> 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/discussexcel
>
--
ThanX,
Chudheer Kumar
--
----------------------------------------------------------------------------------
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/discussexcel
