Typing mistake..... Sort 600-01, 600-02, 600-03 and so.
---------------------------------------------------------------
On Tue, Jan 6, 2015 at 6:08 PM, Zafar Iqbal <ziqba...@gmail.com> wrote:
> Dear Expert, Thanks for it. Can we sort data later on in code and position
> them in proper ascending 6001-01, 600-02 & so on?
>
> Regards,
> ZAFAR IQBAL
> ---------------------------------------------------------------
>
> On Tue, Jan 6, 2015 at 5:59 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>
>> Try code from module ..Data_Flex_Merger_AddToEnd
>>
>> This wll delete existing data & add that file at the end..
>>
>> +++++
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Tue, Jan 6, 2015 at 8:17 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>>
>>> can you send me three separate files..
>>>
>>> +++++
>>> *I did not do this for you. God is here working through me for you.*
>>>
>>> On Tue, Jan 6, 2015 at 8:11 PM, Zafar Iqbal <ziqba...@gmail.com> wrote:
>>>
>>>> Dear Expert, I appreciate your guidance. There is minor correction
>>>> still needed. Now, it is deleting some data down the bottom.
>>>>
>>>> Data of Files 601-01, 600-02, 600-03, 600-04 & 600-05 Exists in sheet.
>>>> Overwrite of first file 600-01 (only), Delete Contents of 600-02 and 600-03
>>>> (two files) whereas its border / format exists and below data of 600-04/05
>>>> in OK un-touch. When we overwrite second file 600-02, it delete contents of
>>>> below file 600-03 (one file only) and 600-04/05 is OK. When we overwrite
>>>> 600-03, it deletes contents of 600-04 and 600-05 in OK un-touch. When
>>>> overwrite of 600-04 is carried out there is no error to below data
>>>> (un-touch). Please help for this error. Thanks
>>>>
>>>> Regards,
>>>> Zafar Iqbal
>>>>
>>>> On Tuesday, 6 January 2015 17:17:58 UTC+3, Vabz wrote:
>>>>>
>>>>> Check this....
>>>>>
>>>>> In your original code you was selecting whole range from data file...
>>>>>
>>>>> I rectified to select upto last used row...
>>>>>
>>>>> Cheers!!
>>>>>
>>>>> +++++
>>>>> *I did not do this for you. God is here working through me for you.*
>>>>>
>>>>> On Tue, Jan 6, 2015 at 7:29 PM, Zafar Iqbal <ziqb...@gmail.com> wrote:
>>>>>
>>>>>> Dear Expert, It is very nice. Thanks for it.
>>>>>>
>>>>>> A little problem is observed. If data over write is falling at start
>>>>>> or in middle of existing data, it overwrite well, but delete exiting data
>>>>>> down the bottom.
>>>>>>
>>>>>> For example, Data from files 601-01, 600-02 & 600-03 already exists.
>>>>>> When overwrite of 601-01 (first file) is needed, it will delete all data
>>>>>> below from files 600-02 and 600-03. Similarly if over write is for 600-02
>>>>>> only (middle file) then date below it 600-03 is deleted. Can it be
>>>>>> rectified, please? Thanks for your efforts & excellent work, always.
>>>>>>
>>>>>> Regards,
>>>>>> Zafar Iqbal
>>>>>>
>>>>>> On Tuesday, 6 January 2015 16:37:10 UTC+3, Vabz wrote:
>>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>> Check module 2 *Data_Flex_Merger_Overwrite*
>>>>>>>
>>>>>>> This will meet your requirement..i am not sure of your file
>>>>>>> structure but i have tried my best guessing...
>>>>>>>
>>>>>>> Cheers!!
>>>>>>>
>>>>>>> +++++
>>>>>>> *I did not do this for you. God is here working through me for you.*
>>>>>>>
>>>>>>> On Tue, Jan 6, 2015 at 12:15 PM, Zafar Iqbal <ziqb...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Dear Expert,
>>>>>>>>
>>>>>>>> Now, It is working fine. Bundle of Thanks for it.
>>>>>>>>
>>>>>>>> I checked my data files and found that exiting files will be
>>>>>>>> revised in few cases. In this scenario, only contents of existing file
>>>>>>>> will
>>>>>>>> modify and number of rows will remain same, i.e data height which you
>>>>>>>> pointed out earlier will not change.
>>>>>>>> So, I request that if code finds that file name already exists in
>>>>>>>> sheet, then send message "do you want to replace data - File Name?",
>>>>>>>> upon
>>>>>>>> yes, replace else go to next file. It will be great help for me,
>>>>>>>> please.
>>>>>>>> Thanks in advance.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Zafar Iqba
>>>>>>>>
>>>>>>>> On Monday, 5 January 2015 17:59:56 UTC+3, Vabz wrote:
>>>>>>>>>
>>>>>>>>> ok, check this now..
>>>>>>>>>
>>>>>>>>> Cheers!!
>>>>>>>>>
>>>>>>>>> +++++
>>>>>>>>> *I did not do this for you. God is here working through me for
>>>>>>>>> you.*
>>>>>>>>>
>>>>>>>>> On Mon, Jan 5, 2015 at 8:22 PM, Zafar Iqbal <ziqb...@gmail.com>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Dear Expert,
>>>>>>>>>>
>>>>>>>>>> Code is stuck at line For j = LBound(nCount) To UBound(nCount)
>>>>>>>>>> when run first time while Active Sheet was blank and data is pasted
>>>>>>>>>> from
>>>>>>>>>> target files.On Second run it is working as per requirement,
>>>>>>>>>> excluding
>>>>>>>>>> files whose Names are already present.
>>>>>>>>>>
>>>>>>>>>> Paste Special Column Width is not working, right now. Kindly
>>>>>>>>>> rectify both problems. Thanks
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> Zafar Iqbal
>>>>>>>>>>
>>>>>>>>>> On Monday, 5 January 2015 17:40:42 UTC+3, Vabz wrote:
>>>>>>>>>>>
>>>>>>>>>>> Hi
>>>>>>>>>>>
>>>>>>>>>>> Try code in attached excel file...I assumed shipment # will be
>>>>>>>>>>> in third row of Product delivery note & there will be only one PD
>>>>>>>>>>> in excel
>>>>>>>>>>> file...
>>>>>>>>>>>
>>>>>>>>>>> Cheers!!
>>>>>>>>>>>
>>>>>>>>>>> +++++
>>>>>>>>>>> *I did not do this for you. God is here working through me for
>>>>>>>>>>> you.*
>>>>>>>>>>>
>>>>>>>>>>> On Mon, Jan 5, 2015 at 6:03 PM, Zafar Iqbal <ziqb...@gmail.com>
>>>>>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Dear Vabz,
>>>>>>>>>>>>
>>>>>>>>>>>> For this condition, I request code to exclude/skip those files
>>>>>>>>>>>> whose names are already present in sheet. Thanks
>>>>>>>>>>>>
>>>>>>>>>>>> Regards,
>>>>>>>>>>>> Zafar Iqbal
>>>>>>>>>>>>
>>>>>>>>>>>> On Monday, 5 January 2015 15:19:57 UTC+3, Vabz wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>> hi
>>>>>>>>>>>>>
>>>>>>>>>>>>> Height of every file is not same, so how you want to paste
>>>>>>>>>>>>> data on existing data if file no. is matching?
>>>>>>>>>>>>>
>>>>>>>>>>>>> +++++
>>>>>>>>>>>>> *I did not do this for you. God is here working through me for
>>>>>>>>>>>>> you.*
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Mon, Jan 5, 2015 at 5:03 PM, Zafar Iqbal <ziqb...@gmail.com
>>>>>>>>>>>>> > wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Dear Experts,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> By hit & trial method, I got file name with file path by
>>>>>>>>>>>>>> adding line Range("A65536").End(xlUp).Offset(3, 17) =
>>>>>>>>>>>>>> FileName in the code.
>>>>>>>>>>>>>> Please guide me how to get file name only from full path
>>>>>>>>>>>>>> address. I will need answer to balance points # 2, 3 & 4 from
>>>>>>>>>>>>>> you, please.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES
>>>>>>
>>>>>> 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) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>> and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to excel-macros...@googlegroups.com.
>>>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>>
>>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 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) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/excel-macros/fpS4GXF_eK4/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
