Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Hi You did not acknowledged response on last Query!! Read rule # 4) Acknowledge the responses you receive, good or bad. + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 12:32 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Experts, Below

Re: $$Excel-Macros$$ Vba Query

You did not acknowledged response on last Query!! Read rule # 4) Acknowledge the responses you receive, good or bad. + *I did not do this for you. God is here working through me for you.* On Sun, Dec 21, 2014 at 2:22 PM, sanjai Kumar sanjai99...@gmail.com wrote: Dear All, PFA. there

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

If there is no short cut then I will follow your suggestion. Thanks for your guidance. On Sunday, December 21, 2014 11:16:34 AM UTC+3, Vabz wrote: Try to open file one by one using macro n save it as macro free workbook . Xlsx Cheers On Dec 21, 2014 1:03 PM, Zafar Iqbal

Re: $$Excel-Macros$$ Re: Excel Macro to add rotated picture in Cell Comments

Well done, Thanks On Wednesday, December 17, 2014 3:41:22 PM UTC+3, Vabz wrote: hi can you share your experience with us? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 2:14 PM, Vaibhav Joshi v...@vabs.in javascript: wrote: Hey

Fwd: $$Excel-Macros$$ solve vba Query

PFA + *I did not do this for you. God is here working through me for you.* -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Sat, Dec 20, 2014 at 6:33 PM Subject: Re: $$Excel-Macros$$ solve vba Query To: Ashish Kumar kumar.ashish...@gmail.com Check formula

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Hi Zafar, If this is not as per your requirement then macro can be made as per your need.. Coz.. .xlsx file extension is not supported in older version then in that case this solution will not work.. Do let us know if you want .xls extension post removal of VBE. Cheers!! + *I did not do

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Dear Expert, Sorry for it. I replied to query Rotate Picture in Cell Comments appreciated your efforts. However, for query Remove all Macros in multiple files, I was hoping to get help from someone else in the forum so delayed my response to your reply. I will follow forum rules send you

Re: $$Excel-Macros$$ Re: Excel Macro to add rotated picture in Cell Comments

Thanks for acknowledging again.. + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 1:59 PM, Zafar Iqbal ziqba...@gmail.com wrote: Well done, Thanks On Wednesday, December 17, 2014 3:41:22 PM UTC+3, Vabz wrote: hi can you share your

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Dear Vaibhav Joshi, all files are with extension xls. If code will temporarily or permanently do something with extension, it is no harm to me. I can handle both .xls and .xlsx without any difficulty. Thanks Regards, ZAFAR IQBAL --- On

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Dear Ashish Your Code is working fine.. Dear Zafar, Check this file, i have modified Ashish Kumar's code to suit your need,,, Cheers! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 2:13 PM, Zafar Iqbal ziqba...@gmail.com wrote: Dear

$$Excel-Macros$$ Re: VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

This will help you PFA !! Don't delete the hide sheet. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Monday, December 22, 2014 11:20:25 AM UTC+5:30, big smile wrote: Hellow Friends 1]

$$Excel-Macros$$ Re: Use of ADO Connection in Excel Macro

Open sheet 1 by 1 with the help of macro use file dilaog method to get the names of the files and save it in xls Extension. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Monday, December 22,

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Right now, I tried it and getting error message. Let me check possible corrections at my end. Thanks for this kindness. Regards, ZAFAR IQBAL --- On Mon, Dec 22, 2014 at 12:19 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Your

$$Excel-Macros$$ Re: Use of ADO Connection in Excel Macro

Dear Mandeep Baluja, I want this file dialog method to be added in below mentioned code. I tried it with hit trial but could not succeed. Please add this command at suitable position with related parameters in below code. Thanks On Monday, December 22, 2014 12:32:54 PM UTC+3, Mandeep Baluja

$$Excel-Macros$$ Re: Macro for Ageing of Inventory

Please explain your Query Again I an unable to understand it . Aeging can be count but on what criteria whether on particular order no, material no , document no. where is availble qty column. On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote: Hi, I have purchase data in a

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

Dear Rockernayal, Pls share a workbook with us. Regards, Gawli Anil On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja rockerna...@gmail.com wrote: Please explain your Query Again I an unable to understand it . Aeging can be count but on what criteria whether on particular order no, material no

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Hi Zafar, Pls let us know error, before that .. Trust Access To Visual Basics Project must be enabled. From Excel: Tools | Macro | Security | Trusted Sources.. or Excel OptionsMacro SettingsDeveloper Macro Settings, Tick Trust Access to the VBA object Try this file.. Cheers!! + *I did

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

Please see attached file. Let me know if any additional info is required. On Mon, Dec 22, 2014 at 3:18 PM, Anil Gawli gawlianil8...@gmail.com wrote: Dear Rockernayal, Pls share a workbook with us. Regards, Gawli Anil On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Try this...Removed some bugs, now its working good... Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 3:26 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Zafar, Pls let us know error, before that .. Trust Access To Visual Basics

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Now, It is working excellent. Thanks for this great help, dear experts. --- On Mon, Dec 22, 2014 at 1:32 PM, Vaibhav Joshi v...@vabs.in wrote: Try this...Removed some bugs, now its working good... Cheers!! + *I did not do this

Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files

Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 4:06 PM, Zafar Iqbal ziqba...@gmail.com wrote: Now, It is working excellent. Thanks for this great help, dear experts. ---

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

Hi, At year end, we need to determine age of Items left in Inventory. For example, we are left with 2 pieces of Material Part No.357000 at year end, and need to determine age of these two quantities of material based on purchase. We go to purchase data and find most recent purchase. Recent

Re: $$Excel-Macros$$ solve vba Query

this is with VBA Macro... Check this file, click button data will be filled in B column.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at 2:02 PM, Vaibhav Joshi v...@vabs.in wrote: PFA + *I did not do this for you. God is

$$Excel-Macros$$ Pivot Query

Dear Seniors, Please help to create pivot table by VBA. Regards Ashu Kenith -- 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,

Re: $$Excel-Macros$$ Pivot Query

Hi Ashu, Check this. Regards Ashish -- 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,

Re: $$Excel-Macros$$ Pivot Query

Dear Ashish Sir, Thank you so much. Regards Ashu Kenith -- 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.

Re: $$Excel-Macros$$ Pivot Query

Welcome. Regards Ashish -- 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

Re: $$Excel-Macros$$ Pivot Query

Dear Sir, one more help required on this. Can we add delete pivot table option in it. Please Help. Thanks Ashu Kenith On Mon, Dec 22, 2014 at 5:41 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Welcome. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Pivot Query

Hi Ashu, PFA.! Regards Ashish -- 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,

Re: $$Excel-Macros$$ Pivot Query

Dear Ashish Sir, Thanks a lot for your help. thankyou. Thanks Ashu kenith On Mon, Dec 22, 2014 at 5:56 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Ashu, PFA.! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

Hi Big smile check this... Mandeep's code is working fine, made few change to it like..if same value is entered then it is not captured...Also restricted cell values to range specified by you..also it works with out dependent sheet! Cheers!! + *I did not do this for you. God is here

Re: $$Excel-Macros$$ Pivot Query

Welcome...!! Regards Ashish -- 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

$$Excel-Macros$$ Re: Macro for Ageing of Inventory

Try this File hope it reach you expected Result. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote: Hi, I have purchase data in a

Re: $$Excel-Macros$$ Scale Chart for rating

Hi How did you made it in current case? It appears to be diagram! If yo want it to be part of chart then its alignment seems to be not logical, because it is neither increasing or decreasing.. After 230 you have 211 then 234 then 251 + *I did not do this for you. God is here working

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Hi Zafar, Try this: Sub Data_Merge_From_All_Files() Dim bookList As Workbook Dim mergeObj, dirObj, filesObj, everyObj As Object Application.ScreenUpdating = False Set mergeObj = CreateObject(Scripting.FileSystemObject) Set dirObj = mergeObj.Getfolder(D:\Test) Set filesObj = dirObj.Files For

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

Macro is not providing desired result. Attached worksheet looks at total Purchase of Specific qty and provides ageing. But the need is to have ageing ( Value) of balance stock only. This mean in Solved worksheet of yours, total qty left in Cell B5 is to be keyed in Manually and macro is

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Dear Vaibhav Joshi, I think my query was not well written so needs to repeat it. This code is working fine for all files at fixed folder location written in code as D:\Test. I want to make it flexible. Instead of manually writing folder location, File Open Dialog window should pop up enabling

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Ok Try this... Sub Data_Merge_From_All_Files() Dim bookList As Workbook Dim mergeObj, dirObj, filesObj, everyObj As Object Application.ScreenUpdating = False Set mergeObj = CreateObject(Scripting.FileSystemObject) 'Set dirObj = mergeObj.Getfolder(D:\Test) Set objShell =

$$Excel-Macros$$ Urgent need of Java Developer with JBoss Camel experience ---- Boston, MA.

Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for Java Developer with JBoss Camel experience. position in *Boston, MA*. Please find below the job description for the same and revert back to me with your consultant updated profile and

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Dear Vaibhav Joshi, I checked it and found it working till selection of Folder after that it is stuck at line Set filesObj = dirObj.Files .Please help to fix this error mentioned below. Thanks Run-time error '438': Object does not support this property or method Regards, ZAFAR IQBAL

Re: $$Excel-Macros$$ Cash Flow Dashboard

Thanks Vaibhav . Will look at chandoo.com . On Mon, 22 Dec 2014 15:40 Vaibhav Joshi v...@vabs.in wrote: PFA, this is what i found on Web, however you can check on chandoo.org. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 22, 2014 at

$$Excel-Macros$$ Re: Help required for Match DATA

Now this macro works for 3 lakh rows you can increase the range as per your convenience. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, It gives NA# again. Kindly run macro and See the result in Cell C1 and C12. Sheet attached. Thanks Ashu Kenith On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja rockerna...@gmail.com wrote: Now this macro works for 3 lakh rows you can increase the range as per your

$$Excel-Macros$$ How to extract only numbers

Dear Seniors, I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in string. I want extract only Numbers and delete rest of string. It's possible. Please help. Thanks Ashu Kenith. -- 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

Re: $$Excel-Macros$$ How to extract only numbers

Hi Ashu, You want resolution by VBA or formula. Reply. Regards Ashish On 23 December 2014 at 11:10, Ashu k direct2as...@gmail.com wrote: Dear Seniors, I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in string. I want extract only Numbers and delete rest of string. It's possible.

Re: $$Excel-Macros$$ How to extract only numbers

vba. Thanks Ashu Kenith On Tue, Dec 23, 2014 at 11:13 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Ashu, You want resolution by VBA or formula. Reply. Regards Ashish On 23 December 2014 at 11:10, Ashu k direct2as...@gmail.com wrote: Dear Seniors, I have Data in Cell A1

$$Excel-Macros$$ Need function help for output of particular list on matching data

Dear experts, I try below function to get output from other sheet on matching data written in L1 in sheet of 'Letter'. But this function is not working and I'm not able to understand error.

Re: $$Excel-Macros$$ How to extract only numbers

Use below code of UDF. Function removeSpecial(sInput As String) As String Dim sSpecialChars As String Dim i As Long sSpecialChars = \/:*?{}[](),!`~\:;'._-=+^%$|ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz For i = 1 To Len(sSpecialChars) sInput = Replace$(sInput,

Re: $$Excel-Macros$$ How to extract only numbers

Hi Ashu, Check this Resolved by VBA. HIT the button and select your data and press OK. Regards Ashish -- 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

Re: $$Excel-Macros$$ How to extract only numbers

Dear Ashish Bhalara Sir, Thanks for your help, but this udf is not working according to my requirement. Regards Ashu Kenith. -- 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 @

Re: $$Excel-Macros$$ How to extract only numbers

Dear Ashish Sir, Thanks a ton for your help. Your macro is working perfect. Thanks a lot sir. Regards Ashu Kenith. On Tue, Dec 23, 2014 at 11:26 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Ashu, Check this Resolved by VBA. HIT the button and select your data and press OK.

Re: $$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

Respected Vaibhavji I am changing the value of -- Sheet6-C22 - everytime - By formula =H33 Where it values changes as per I change h33 calculate premium But it does not work now. It only works if I change manually c22 If possible you give me the guidelines so

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Hi Add this line before Set filesObj = dirObj.Files Set dirObj = mergeObj.Getfolder(dirObj.self.Path) Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 12:40 AM, Zafar Iqbal ziqba...@gmail.com wrote: Dear Vaibhav Joshi, I checked it

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

Dear Vaibhav Joshi, Now, It working excellently. It is fulfilling my request's one part. Thanks for it. It is copying data from all files in selected folder. Can you make it more flexible to select one or more files with shift/ctrl keys, please?

Re: $$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL

Hi Check this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 11:48 AM, big smile bigsmile...@gmail.com wrote: Respected Vaibhavji I am changing the value of -- Sheet6-C22 - everytime - By formula =H33 Where it