Re: $$Excel-Macros$$ Chart related issue

2014-06-01 Thread amar takale
Thanks vabs bro.. for this website much knowledgeable for making chart On Sat, May 31, 2014 at 11:29 AM, Vaibhav Joshi wrote: > Yes you can .. > > See this http://peltiertech.com/Excel/Charts/ComboChart1.html > > Cheers!! > > > On Fri, May 30, 2014 at 4:38 PM, amar takale wrote: >> >> Dear vaibh

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
welcome have a nice day On Sun, Jun 1, 2014 at 1:15 PM, Michael Lovin wrote: > WOW man I think you did it...it is looking good...so much help and > paients with me...I thank you sincerely! > > > On Sunday, June 1, 2014 3:35:09 PM UTC+8, ashish wrote: > >> try this one >> Sub merge_data() >> D

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread Michael Lovin
WOW man I think you did it...it is looking good...so much help and paients with me...I thank you sincerely! On Sunday, June 1, 2014 3:35:09 PM UTC+8, ashish wrote: > > try this one > Sub merge_data() > Dim filenm As String, folderpath As String > folderpath = "C:\Users\ashishkoul\Desktop\Sampl

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread Michael Lovin
WAIT... my mistake...the last one worked...I had to rename the file in the VB to master_file1.xlsm On Sunday, June 1, 2014 3:35:09 PM UTC+8, ashish wrote: > > try this one > Sub merge_data() > Dim filenm As String, folderpath As String > folderpath = "C:\Users\ashishkoul\Desktop\Sample fil

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
its wokring at my end . On Sun, Jun 1, 2014 at 1:12 PM, Michael Lovin wrote: > No population at all now... by the way...I see why it was adding that > data coloms..there were 2 files with hose names in the folder...I removed > them...but yeah no data being populated at all now.. > > > On S

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread Michael Lovin
No population at all now... by the way...I see why it was adding that data coloms..there were 2 files with hose names in the folder...I removed them...but yeah no data being populated at all now.. On Sunday, June 1, 2014 3:35:09 PM UTC+8, ashish wrote: > > try this one > Sub merge_data() > D

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
try this one Sub merge_data() Dim filenm As String, folderpath As String folderpath = "C:\Users\ashishkoul\Desktop\Sample files 1 june 2014\students\" ' change folder here filenm = Dir(folderpath) Application.DisplayAlerts = False Application.ScreenUpdating = False While (filenm <> "") If In

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
can you share sample input file On Sun, Jun 1, 2014 at 12:56 PM, Michael Lovin wrote: > It worked sort of.. here is the master_file1.xlsmBEFORE running > the VB... > >Score by Category > > > > > Grammar > > > > > Reading / Writing > > > > > Vocabulary > > > > > Speaking / Lis

$$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread Michael Lovin
It worked sort of.. here is the master_file1.xlsmBEFORE running the VB... Score by Category Grammar Reading / Writing Vocabulary Speaking / Listening Here it is AFTER runing the last code you sent Score by Category student1 student2 student3 Studen

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
try this its working fine i tested it again add \ at teh edn of folder path C:\Users\ashishkoul\Desktop\Sample files 1 june 2014\students\ Sub merge_data() Dim filenm As String, folderpath As String folderpath = "C:\Users\ashishkoul\Desktop\Sample files 1 june 2014\students\" ' change folder h

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread ashish koul
ok wait 2 min On Sun, Jun 1, 2014 at 12:34 PM, Michael Lovin wrote: > office 2010 > > > On Sunday, June 1, 2014 2:53:01 PM UTC+8, ashish wrote: > >> are you using 2003 >> >> >> >> On Sun, Jun 1, 2014 at 12:18 PM, Michael Lovin wrote: >> >>> Wellit appears that it is doing something. (i see

Re: $$Excel-Macros$$ Re: Coloms in many workesbooks to rows in a master workbook?

2014-06-01 Thread Michael Lovin
office 2010 On Sunday, June 1, 2014 2:53:01 PM UTC+8, ashish wrote: > > are you using 2003 > > > > On Sun, Jun 1, 2014 at 12:18 PM, Michael Lovin > wrote: > >> Wellit appears that it is doing something. (i see as if files open >> but just for a second) .but still not populating the master