$$Excel-Macros$$ Re: Input 2 files and create 3rd file

Any body can help on this issue? I appreciate any help. On Sunday, March 20, 2016 at 3:50:26 PM UTC-4, newexcel wrote: > > I have a challenges where I have two input files > > > 1. 1. Emp-Input.xlsx 2. Zip-Input file.xlsx > > > I am creating a 3rd workbook (Emp-Zip-Output.xlsx) file taking d

$$Excel-Macros$$ learning excel vba macros

Hi there I have been trying to learn Excel VBA for sometime but no luck. I have been collecting/watching many articls/tutorials/videos but again no success. What I am really looking for is basic step by step introduction that can the basic foundation of excel VBA so I can build on that. I learn

$$Excel-Macros$$ Input 2 files and create 3rd file

I have a challenges where I have two input files 1. 1. Emp-Input.xlsx 2. Zip-Input file.xlsx I am creating a 3rd workbook (Emp-Zip-Output.xlsx) file taking data from the two input files.The original file contains thousands of records. Can you suggest a VBA code to automate the proces

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

So this code will work with both naming format?? On Mar 17, 2016 10:15 PM, "Paul Schreiner" wrote: > ?? You mean like: > > fArray = Split(Replace(fName,"_","-"), "-") > > ?? > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

Thanks Paul, have posted another query on the same workbook, Will you please check that one also.☺ On Mar 17, 2016 10:24 PM, "Paul Schreiner" wrote: > If fName = atnst-a2-2*_*m_2_2x.jpg > > then Replace(fName,"_","-") > > will result in fname = atnst-a2-2*-*m-2-2x.jpg > > then, the split() comman