Re: $$Excel-Macros$$ Need help to locate data on same row each time i click OK

Thanks noorain, It solved my prb... -- -- 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.c

Re: $$Excel-Macros$$ Convert txt file to xls

Dear all I agree with paul & XLS S. Ram Naresh varma's way is quite opposite to the question, as the questioner don't want to rename or change the extension and he wants to convert the file. Noorain had the code for opening .txt in excel application, which we can simply drag and drop the text fi

Re: $$Excel-Macros$$ Convert txt file to xls

Thanks Nikhil.. On Fri, Sep 23, 2011 at 8:49 AM, Nikhil Shah wrote: > Hi Noorain > > This is another excellent tools you send our group.. > > Thanks & Regards > Nikhil Shah > > On Fri, Sep 23, 2011 at 8:32 AM, NOORAIN ANSARI < > noorain.ans...@gmail.com> wrote: > >> Dear Sandeep,

Re: $$Excel-Macros$$ Convert txt file to xls

Hi Noorain This is another excellent tools you send our group.. Thanks & Regards Nikhil Shah On Fri, Sep 23, 2011 at 8:32 AM, NOORAIN ANSARI wrote: > Dear Sandeep, > > Please try it, > > Sub convert_txtfile() > On Error GoTo abc > Dim txtifile > txtifile = Application.GetOpenFilename("TXT (*.TX

Re: $$Excel-Macros$$ Convert txt file to xls

Dear Sandeep, Please try it, Sub convert_txtfile() On Error GoTo abc Dim txtifile txtifile = Application.GetOpenFilename("TXT (*.TXT),*.TXT", , "Please select Text file...") Workbooks.OpenText Filename:=txtifile, Origin:=xlWindows, StartRow:=1 With ActiveWorkbook ActiveSheet.Move After:=.Workshee

Re: $$Excel-Macros$$

please specify requirement and condition On Thu, Sep 22, 2011 at 9:20 PM, naanu v wrote: > kindly provide macro for Index formula > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for ti

Re: $$Excel-Macros$$ Convert txt file to xls

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 wrote: > Dear Team, > > Is there any way to convert text file to excel, except change of > extension name... > > Please advise... > > Regards, > Sandeep > > -- > >

Re: $$Excel-Macros$$ Convert txt file to xls

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. c

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 wrote: > Dear Team, > > Is there any way to convert text file to excel, except change of >

$$Excel-Macros$$

kindly provide macro for Index formula -- -- 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

Re: $$Excel-Macros$$ Export Data

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,

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

Thank a lot Noorain :-) On Thu, Sep 22, 2011 at 1:19 PM, NOORAIN ANSARI wrote: > Thanks Kanwaljit.. > > > On Thu, Sep 22, 2011 at 4:42 PM, kanwaljit Singh wrote: > >> Dear Sir, >> >> Power Pivot Add-in is available at MS site to all legal owners of Excel >> 2010 at www.*powerpivot*.com/*download*

Re: $$Excel-Macros$$ I need your help - Urgent

Hi Noorain, I Read your Excel poem on your blog : *http://noorain-ansari.blogspot.com/.* Awesome... Keep on.. Regards Amresh On Thu, Sep 22, 2011 at 4:05 AM, Amresh Maurya wrote: > Thank you so much.. > > perfect.. > > Regards > Amresh > > > On Thu, Sep 22, 2011 at 4:00 AM, NOORAIN ANSARI >

Re: $$Excel-Macros$$ I need your help - Urgent

Thank you so much.. perfect.. Regards Amresh On Thu, Sep 22, 2011 at 4:00 AM, NOORAIN ANSARI wrote: > Dear Amresh, > > I have sent you a simple report on ur email ID, pls check.. > > > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ Convert txt file to xls

Dear Team, Is there any way to convert text file to excel, except change of extension name... Please advise... Regards, Sandeep -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

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 Date: Tue,

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

Thanks Kanwaljit.. On Thu, Sep 22, 2011 at 4:42 PM, kanwaljit Singh wrote: > Dear Sir, > > Power Pivot Add-in is available at MS site to all legal owners of Excel > 2010 at www.*powerpivot*.com/*download*.aspx > > > On Thu, Sep 22, 2011 at 4:25 PM, NOORAIN ANSARI > wrote: > >> Dear Kanwaljit, >>

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

Dear Sir, Power Pivot Add-in is available at MS site to all legal owners of Excel 2010 at www.*powerpivot*.com/*download*.aspx On Thu, Sep 22, 2011 at 4:25 PM, NOORAIN ANSARI wrote: > Dear Kanwaljit, > > Can u share with us power Pivot Add-In, I am very exited to know.this > information... > It

Re: $$Excel-Macros$$ I need your help - Urgent

Dear Amresh, I have sent you a simple report on ur email ID, pls check.. Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Sep 22, 2011 at 3:12 PM, Amr

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

Dear Kanwaljit, Can u share with us power Pivot Add-In, I am very exited to know.this information... It will be really imagine.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

Dear, I think if you have installed Power Pivot Add-in it might be possible to analyse more than 1048576 rows. On Thu, Sep 22, 2011 at 1:50 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Is there any way to increase maximum rows in excel 2010? > > Thanks, > > Chandra Shek

Re: $$Excel-Macros$$ I need your help - Urgent

Hi Noorain Ansari, Thanks for you response, It will really help me for creating my report but i need sample reports who made for PPC (Pay Per Click), Google Adwords,Display,Digital marketing,Google Search Engine. Regards Amresh On Thu, Sep 22, 2011 at 2:23 AM, NOORAIN ANSARI wrote: > Dear Amre

Re: $$Excel-Macros$$ Export Data

Dear Surya, Please try below code and See attached sheet.. Sub export_report() Sheet3.UsedRange.Copy Workbooks.Add Set wkb = ActiveWorkbook wkb.Sheets(1).Select ActiveSheet.Paste wkb.SaveAs "C:\Documents and Settings\Administrator\Desktop\" & "Details-" & VBA.Format(Now(), "dd-mm-") & ".xls"

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

Dear Chandra Shekhar, There is no any way to increase rows in Excel 2010 from more than (1,048,576). -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On