so only dates in middle will be changing right?
On Thu, Jan 9, 2014 at 9:06 AM, Linda C wrote:
> There are around 40 files in the folder, but not all of them are needed.
>
> The names are like
> "COUNTY_CALIFORNIA_01350143_Main.xlsx": If the file name starts with
> "COUNTY_CALIFORNIA" and end
There are around 40 files in the folder, but not all of them are needed.
The names are like
"COUNTY_CALIFORNIA_01350143_Main.xlsx": If the file name starts with
"COUNTY_CALIFORNIA" and ends with "Main", import into "Sheet FileA"
"REGION_BRITAIN_02242044_Sub.xlsx": if the file name starts with
"
how many files are in folder .. can u share some full names of few files
and sheets thy need to go into
"Sheet FileA , "Sheet FileB will they be already existing or will be
created by macro only
On Sat, Jan 4, 2014 at 10:04 PM, Linda C wrote:
> Hi Ashish,
>
> On a separate note, is it possib
Hi Ashish,
On a separate note, is it possible to have a single button which will
trigger the import of multiple files into specific sheets on an active
workbook?
For example, the user only needs to specify the folder containing all the
files to be imported; there will be no user input to selec
Thanks Ashish & Anoop!
On Monday, 30 December 2013 09:44:29 UTC-5, ashish wrote:
>
> please find updated file attached
>
> Regards
> Ashish
>
>
> On Mon, Dec 30, 2013 at 10:47 AM, Anoop K Sharma
>
> > wrote:
>
>> just use below line
>>
>> Application.GetOpenFilename ("All Excel File (*.xls*),*.x
just use below line
Application.GetOpenFilename ("All Excel File (*.xls*),*.xls*")
On Sun, Dec 29, 2013 at 8:49 PM, Linda C wrote:
> Hi Ashish,
>
> Is it possible to actually show all the excel files (both .xls and .xlsx
> version) after clicking Browse button so I can directly click the file
Hi Ashish,
Is it possible to actually show all the excel files (both .xls and .xlsx
version) after clicking Browse button so I can directly click the file to
be imported? Instead of clicking the drop-down button to scroll to the
file? The reason is the files name could be very long and it wou
Thank you Ashish!
I will look at the file and will let you know if I have further questions.
:)
On Saturday, 28 December 2013 00:38:21 UTC-5, ashish wrote:
>
> enable macros
>
> 1 choose browse button and select the folder having the files and then
> choose file to import from first combobox
>
enable macros
1 choose browse button and select the folder having the files and then
choose file to import from first combobox
2 choose the sheet name from 2nd combo box
3 click on import button to import data
Regards
Ashish
On Sat, Dec 28, 2013 at 3:34 AM, Linda C wrote:
> Yes, there is
Yes, there is only one sheet in those import files.
Thanks!
On Friday, 27 December 2013 12:21:09 UTC-5, ashish wrote:
>
> excel files will have only one sheet right?
>
>
> On Fri, Dec 27, 2013 at 10:48 PM, Linda C
> > wrote:
>
>> Hi ashish,
>>
>> Thanks for the quick reply!
>>
>> The data range
excel files will have only one sheet right?
On Fri, Dec 27, 2013 at 10:48 PM, Linda C wrote:
> Hi ashish,
>
> Thanks for the quick reply!
>
> The data range to be imported (A1 to Z20) is fixed for all the import
> files.
>
> Sorry, I may not understand your second question. Ideally, the
> mast
Hi ashish,
Thanks for the quick reply!
The data range to be imported (A1 to Z20) is fixed for all the import files.
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" and another
button in tab 2 to import "Fi
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
-Original Message-
From: Linda C
Sender: excel-macros@googlegroups.com
Date: Fri, 27 Dec 2013 08:40:19
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Exc
13 matches
Mail list logo
