I haven't followed all of this but it seems to me that there is no reason
for separate files. To get reports or print you can use filtering
with/without macros and use only ONE file. Good design???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-----Original Message-----
From: Somnath Khadilkar
Sent: Monday, April 09, 2012 9:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter
condition
Sir,
there are many many colm.in the sheets [ that mighht complex the
issue ] , but as a sample I am able to limit to the TWO fields and one
QTY field. I need all the colm A thru C here in the RESPECTIVE files.
-------
issue 2.
I am able to generate a datafile [ thru some 'C' code , can you
guide me to 'CONVERT' these into XLS files thru some tool, [ w/o
openining/saving individualllly, as these are TOO many, I need to
AUTOMAIL ] THIS is altogether a diff. issue, but any help will be
highly appreciated ]
=Mangal Ho
On 4/9/12, Rajan_Verma <rajanverma1...@gmail.com> wrote:
So , what the excel file will conatin? Only one Row?
-----Original Message-----
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Somnath Khadilkar
Sent: Apr/Mon/2012 08:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter
condition
Dear Sir,
The attachment is file with more data in it [ only ONE work SHeet , say
sheet1 ]
1. the col.A contains CITY code [ say currently upto 10 eg AHM, DEL,
DEL..
]
2. the col.B contains item-code say item-1, item-2, item-3...[ for
that matter mango,apple,banana ] currently upto 25 distinct 'FRUITS'
3. Colm C contains just a number showing how many of these exists say 1,2,
600 etc..
now the output after running thr macro should be containining a subfolder
say 'data' and XL files in it by name say AHM-item-1, AHM-item-10, ....[
if
quantity exists for the perticular city/item-codeXX ]
=mangal ho
On 4/9/12, Rajan_Verma <rajanverma1...@gmail.com> wrote:
Can you add more data and explain how you want to bifurcate the data?
Rajan.
-----Original Message-----
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com]
On Behalf Of Somnath Khadilkar
Sent: Apr/Mon/2012 07:37
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ one to many FILES , depeding upon filter
condition
Dear Sir,
I reqd the output to be upto say 25 * 10 distict FILES [ sir, not
diff WorkSheets ] the names of these files will be combination of the
'CITY' and 'ITEM' code eg del-item001, hyd-item002, [ in a named
subfolder, so that I can routinely keep track. ]
thanks in adv.
PS: if the file exists --- may be just OVERwrite it...[ if possible
w/o prompting the user]
=mangal ho
On 4/9/12, Somnath Khadilkar <khadilka...@gmail.com> wrote:
Dear Sir,
MY request is to get the data into MULTIFLE FILES depending upon
FILTER Selected. The file names should be say ahm-item-1, ahm-item-2
etc.. [ these will be unique combination] in a subdirectory named
say XXYY, which will cotain ALL colms for the selected filters on
col. A & B so a unique list of cities say 10, and uniq list of items
say 25 could generate upto 250 files.
Pl help, attachment enclosed.
=mangal ho
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
---------------------------------------------------------------------
-
-------------------------------- To post to this group, send email to
excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
----------------------------------------------------------------------
------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
----------------------------------------------------------------------
-------------------------------- To post to this group, send email to
excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
