Re: $$Excel-Macros$$ Importing Excel Files

2014-01-11 Thread ashish koul
gt;> >>>>>>>>>> Thanks! >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Friday, 27 December 2013 12:21:09 UTC-5, ashish wrote: >>>>>>

Re: $$Excel-Macros$$ Importing Excel Files

2014-01-08 Thread Linda C
wrote: >>>>>>>>> >>>>>>>>>> excel files will have only one sheet right? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Fri, Dec 27, 2013 at 10:48 PM, Linda C wrote

Re: $$Excel-Macros$$ Importing Excel Files

2014-01-04 Thread ashish koul
>>> Hi ashish, >>>>>>>>>> >>>>>>>>>> Thanks for the quick reply! >>>>>>>>>> >>>>>>>>>> The data range to be imported (A1 to Z20) is fixed for all the >>>>>>>&

Re: $$Excel-Macros$$ Importing Excel Files

2014-01-04 Thread Linda C
gt;>>>>>>>> Sorry, I may not understand your second question. Ideally, the >>>>>>>>> master.xlsx file will have a button in tab 1 to import >>>>>>>>> "FileA_Main.xlsx" >>>>>

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-30 Thread Linda C
leB_Main.xlsx". >>>>>>>> >>>>>>>> On a separate note, the files to be imported have a date in the >>>>>>>> name "FileA_20130101_Main". Since the import will be done >>>>>>>> periodically >&g

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-29 Thread Anoop K Sharma
;> different dates, I'm thinking of the possible options below: >>>>>> >>>>>> 1. Tab 1 in the master.xlsx will import the file name starting with >>>>>> "FileA_" and ends with "_Main" (is it possible?) >>>>>&g

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-29 Thread Linda C
. Tab 1 in the master.xlsx will import the file name starting with >>>>> "FileA_" and ends with "_Main" (is it possible?) >>>>> 2. Change the code manually each time to specify the new file name >>>>> (tedious but doable) >>&

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-28 Thread Linda C
gt;> If there is an easier way, please advise. >>>> >>>> Thanks! >>>> >>>> >>>> On Friday, 27 December 2013 11:42:49 UTC-5, ashish wrote: >>>> >>>>> Is ur range fixed and do you want to append also or add the dat

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread ashish koul
>> On Friday, 27 December 2013 11:42:49 UTC-5, ashish wrote: >>> >>>> Is ur range fixed and do you want to append also or add the data in >>>> seperate tabs only >>>> Sent on my BlackBerry® from Vodafone >>>> -- &

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread Linda C
want to append also or add the data in >>> seperate tabs only >>> Sent on my BlackBerry® from Vodafone >>> -- >>> *From: * Linda C >>> *Sender: * excel-...@googlegroups.com >>> *Date: *Fri, 27 Dec 2013 08:40:19 -0800 (PST)

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread ashish koul
to append also or add the data in >> seperate tabs only >> Sent on my BlackBerry® from Vodafone >> -- >> *From: * Linda C >> *Sender: * excel-...@googlegroups.com >> *Date: *Fri, 27 Dec 2013 08:40:19 -0800 (PST) >> *To: * >

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread Linda C
> *Date: *Fri, 27 Dec 2013 08:40:19 -0800 (PST) > *To: *> > *ReplyTo: * excel-...@googlegroups.com > *Subject: *$$Excel-Macros$$ Importing Excel Files > > Hello, > > I have trouble creating a macro to import excel files into an active > workbook with UI. > > Let'

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread koul . ashish
: $$Excel-Macros$$ Importing Excel Files Hello, I have trouble creating a macro to import excel files into an active workbook with UI. Let's say there are multiple excel files (.xlsx) in the folder "C:\Import Files". These files have the following file names: "FileA_Main.x

$$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread Linda C
Hello, I have trouble creating a macro to import excel files into an active workbook with UI. Let's say there are multiple excel files (.xlsx) in the folder "C:\Import Files". These files have the following file names: "FileA_Main.xlsx" "FileA_Sub.xlsx" "FileB_Main.xlsx" "FileB_Sub.xlsx" The