$$Excel-Macros$$ Re: Anyone like to take a project and challenge in excel

2011-09-20 Thread anandydr
Hi Mayank, I tried to see what you are planing. As already stated by dguillett1 now many people might be anxious to help telemarketers still as a project it would be challenging for sure. I can't find the attachment that you have mentioned in your post. I would try to create a flowchart for the pr

$$Excel-Macros$$ Fwd: Macro to open file from a location and consolidate data (Please dont consider this as a Duplicate post)

2011-09-20 Thread Ragavan
Hi All, I would like to bring to your kind attention that this is a very urgent work and is pending from my side for a long time. Also there are thousands of workbooks to be consolidated and hence manual consolidation cannot be considered as a proper option. Hence kindly request you to provide s

$$Excel-Macros$$ Re: List of text files with data to Excel.

2011-09-20 Thread johnofeasttex
I also wanted to add that when I scan the contents of the directory that has been updated, I see that the ".txt" has been added to the file name. This is not a problem initialy, but as files are added to the directory and the macro is run again, it adds another ".txt" to the end of the files it

Re: $$Excel-Macros$$ vlookup , index - Reg

2011-09-20 Thread Dilip Pandey
Hi Mothilal, Nesting limit for function(s) is 6+1 but this is not applicable in your case here. Not sure why this is happening, try attaching a sample file for better understanding of the Group. Thanks Regards, DILIPandey On 9/20/11, jmothilal wrote: > Dear Friends, > > Any limit is there vloo

Re: $$Excel-Macros$$ vlookup , index - Reg

2011-09-20 Thread rajan verma
Hi, May be there was some logical Error..because there is not limitation of this type.. On Tue, Sep 20, 2011 at 7:02 PM, jmothilal wrote: > Dear Friends, > > Any limit is there vlookup and index. because i fix the array a1: a300 > =index(b1:b300,match(a1,a1:a300,0)) some time its not work.

$$Excel-Macros$$ Re: *Macro Code Request*

2011-09-20 Thread Prabhu
Hi Friends, Thanks for update it is solved my query! Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Lin

Re: $$Excel-Macros$$ *Macro Code Request*

2011-09-20 Thread dguillett1
If you want a macro just use this Sub FillDownSAS() With Range("c2") .Formula = "=a2+b2" .AutoFill Destination:=Range("C2:c" & Cells(Rows.Count, "a").End(xlUp).Row) End With End Sub if you already have the formula in c2 Sub FillDownSAS() range(“c2”).AutoFill Destination:=Range("C2:

Re: $$Excel-Macros$$ *Macro Code Request*

2011-09-20 Thread dguillett1
A very easy way is to put your formula in cell c2 and then DOUBLE click the fill handle (lower right corner) From: Prabhu Sent: Tuesday, September 20, 2011 12:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ *Macro Code Request* Hi Friends, Column A & B contains some values

Re: $$Excel-Macros$$ *Macro Code Request*

2011-09-20 Thread NOORAIN ANSARI
Dear Prabhu, Please see attached sheet if it help to u.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep 20, 2011 Dat 10:56 PM, Prabhu wrote:

$$Excel-Macros$$ vlookup , index - Reg

2011-09-20 Thread jmothilal
Dear Friends, Any limit is there vlookup and index. because i fix the array a1: a300 =index(b1:b300,match(a1,a1:a300,0)) some time its not work. if lesser array its working. i am using office 2003. -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 --

Re: $$Excel-Macros$$ Power point Query

2011-09-20 Thread excel lerner
Hi Dear Alisha Thanks for explain abt powerpoint presentaion shape rotate. thanks for your help. regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
Ashish you have the patience of a saint!! The workbook layout is perfect! Your book1 unprotects each of the worksheets perfectly! Is it possible to have your book1 unprotect the workbook itself (same password, "apple")? Is there anyway to stop or pause the macro in the returned workbook while th

Re: $$Excel-Macros$$ Importing csv file vba code

2011-09-20 Thread NOORAIN ANSARI
Dear Ajjw, It's macro is working fine on my worksheet. Can u share a sample sheet with us. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep 20,

$$Excel-Macros$$ *Macro Code Request*

2011-09-20 Thread Prabhu
Hi Friends, Column A & B contains some values and In Column "C" i want to add A & B value. In cell "C2" i put formula as =A2+B2 Now i want to copy the formula from cell "C2" till the last cell i.e Range should be equal to column "A" Can any one help me to know the VBA code to select range

RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
Hi Ashish, The workbook that you sent back looks awesome! When I attempt to use it; I receive a run-time error '1004' for not having the correct password. I have tried to edit the marco without any luck. Is it possible to change the setting to have "apple" as the only password (a

Re: $$Excel-Macros$$ Anyone like to take a project and challenge in excel

2011-09-20 Thread dguillett1
You may?? not find too many anxious to help telemarketers -Original Message- From: Mayank Sent: Sunday, September 18, 2011 12:03 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Anyone like to take a project and challenge in excel Need urgent help in excel project Process

RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
Hi Paul, Sorry about that. The password is "apple", to unprotect the VBA project; you were closer than you thought:) Thanks so much! Kent From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Sep

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Paul Schreiner
I won't be able to work with it unless I can unprotect the VBA project. I tried "pineapple" but it didn't work.. perhaps "grapefruit"? "Mangos"? "UglyFruit"?  (just kidding)   Paul - “Do all the good you can, By all the means you can, In all the ways you c

Re: $$Excel-Macros$$ Converting date with time to date withOUT time

2011-09-20 Thread Ms-Exl-Learner .
Hi Mich Mac, It's better if you provide some sample data in excel file, so that we can suggest you the exact formula to your expectation. --- Ms.Exl.Learner --- On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac wrote: > I am exporting a file from online which au

Re: $$Excel-Macros$$ Converting date with time to date withOUT time

2011-09-20 Thread XLS S
use =int() function ""The *Int* function returns the integer portion of a number."" On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac wrote: > I am exporting a file from online which automatically includes dates. > This interferes with my Pivot tables. How do I convert an entire > column of dates with

RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
Thank you Ashish - Yes I just send a copy of the workbooks to them to have them posted. I believe the workbook is up now - thanks for the suggestion, much appreciated! Regards, Kent From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread ashish koul
HI Kent if u want to share ur workbook within the group write a mail to excel-macros@googlegroups.com and attach ur wrkb On Tue, Sep 20, 2011 at 6:34 PM, HarryP Knuckles wrote: > Good morning Ashish! Thanks you for taking the time to assist with my > issue – really appreciated! > All the workb

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Paul Schreiner
Since these are "Event" type macros, they are probably in the "ThisWorkbook" module. You cannot delete the MODULE, but you can delete the macros within it. try this: Sub Remove_Test()     Dim cnt, wbName     Application.EnableEvents = False     wbName = "VBAtest.xls"     Set vbaModule = Workbooks

Re: $$Excel-Macros$$ List of text files with data to Excel.

2011-09-20 Thread johnofeasttex
At the risk of sounding like a rookie, which I am in regards to VBA, where within what I have would this need to be placed in order for it to proccess the proper file. Also, you stated that I need to have the full paths as in your example. The files do not always have a suffix on them. If I write t

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread HarryP Knuckles
Good morning Ashish! Thanks you for taking the time to assist with my issue – really appreciated! All the workbooks are currently in *.xls format. My objective is to create a template workbook that is will be used to CONTROL and change (unprotect the workbook and worksheets) the *.xls files. I woul

Re: $$Excel-Macros$$ Please suggest VBA Book Name

2011-09-20 Thread NOORAIN ANSARI
Dear Rupesh, I would suggest to check the Group's page for ebooks. Alternatively, you can also google and download pdf books as per your choice. There are many online tutorials available as per various expertise levels You can also download ebook... http://www.recordexcelmacro.com/vebook

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread HarryP Knuckles
Good morning Paul, Thank you for taking interest in my issue – I really appreciate it! To answer your questions: 1) Yes, ideally I would like to disable the macro permanently and then be able to save the disabled version. Having said that, if it is much easier to complete the task by

Re: $$Excel-Macros$$ Please suggest VBA Book Name

2011-09-20 Thread rajan verma
You can finf excel vba 2007 published by o reily On 20/09/2011, Rupesh Shrivastava wrote: > Hi, > > Can anybody suggest me the name of the Best book available in the market to > learn VBA. Please suggest. > > I have already one book "Excel 2010 Power programming with VBA" , By- John > Walkenbach

$$Excel-Macros$$ real time data storing

2011-09-20 Thread ajjw123
hi members I would like to store real time stock datas which are being updated in my excel sheet every second into a different workbook at constant time intervals,say 1min or 2 min or so on.Like i want a sanpshot of real time data every minute stored into a different workbook -- ---

Re: $$Excel-Macros$$ Importing csv file vba code

2011-09-20 Thread ajjw123
Thanks very much ,but unfortunately its not importing the file into the desired workbook On Sep 19, 9:11 pm, NOORAIN ANSARI wrote: > Dear Ajjw, > > Please try. > and see attached sheet.. > > *Sub import_csvfile() > On Error GoTo abc > Dim csvfile > csvfile = Application.GetOpenFilena

Re: $$Excel-Macros$$ Finding Merged cells in excel

2011-09-20 Thread Rupesh Shrivastava
Hi, Can anybody suggest me the name of the Best book available in the market to learn VBA. Please suggest. I have already one book "Excel 2010 Power programming with VBA" , By- John Walkenbach Thanks in Advance Regards, Rupesh Shrivastava -- ---