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 wrote:
> Respected Vaibhavji I am changing the value of -- Sheet6-C22
> - everytime - By formula =H33 Where it values changes as per I
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?
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 wrote:
> Dear Vaibhav Joshi, I checked it and found it worki
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 tha
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
wrote:
> Hi Ashu,
>
> Check this
>
> Resolved by VBA. HIT the button and select your data and press OK.
>
>
> Regards
> Ashish
>
>
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 @
https://www.facebook.com/
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 R
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$(sInp
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.
{=INDEX(Func.Query.xlsm!InvNo,SMALL(IF(INT(SaleData!$A$2:$A$100)=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleDat
vba.
Thanks
Ashu Kenith
On Tue, Dec 23, 2014 at 11:13 AM, Ashish Kumar
wrote:
> Hi Ashu,
>
> You want resolution by VBA or formula.
>
> Reply.
>
> Regards
> Ashish
>
> On 23 December 2014 at 11:10, Ashu k wrote:
>
>> Dear Seniors,
>>
>> I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in
Hi Ashu,
You want resolution by VBA or formula.
Reply.
Regards
Ashish
On 23 December 2014 at 11:10, Ashu k 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.
>
>
> Please help.
>
>
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 offici
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
wrote:
> Now this macro works for 3 lakh rows you can increase the range as per
> your convenience.
>
> Regards,
>
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 wrot
Thanks Vaibhav .
Will look at chandoo.com .
On Mon, 22 Dec 2014 15:40 Vaibhav Joshi 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 10:23 AM
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
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 cont
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 = CreateObject("Shell
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 ch
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 expec
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
Fo
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 t
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 sprea
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 Pleas
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 working
Dear Ashish Sir,
Thanks a lot for your help. thankyou.
Thanks
Ashu kenith
On Mon, Dec 22, 2014 at 5:56 PM, Ashish Kumar
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
> =TIME(2,DO:IT,N:OW) ! Join off
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, lik
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
wrote:
> Welcome.
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME
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 Hel
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. Po
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, l
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, accura
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 wrote:
> PFA
>
> +
> *I did not do this for you. God is here worki
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 Pur
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 wrote:
> Now, It is working excellent. Thanks for this great help, dear experts.
> ---
>
> On Mon, Dec 22,
Now, It is working excellent. Thanks for this great help, dear experts.
---
On Mon, Dec 22, 2014 at 1:32 PM, Vaibhav Joshi wrote:
> Try this...Removed some bugs, now its working good...
>
> Cheers!!
>
> +
> *I did not do this for yo
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 wrote:
> Hi Zafar,
>
> Pls let us know error, before that ..
>
> Trust Access To Visual Basics Project must b
Please see attached file.
Let me know if any additional info is required.
On Mon, Dec 22, 2014 at 3:18 PM, Anil Gawli wrote:
> Dear Rockernayal,
>
> Pls share a workbook with us.
>
> Regards,
> Gawli Anil
>
> On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja
> wrote:
> > Please explain your Qu
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 Options>Macro Settings>Developer Macro Settings, Tick Trust
Access to the VBA object
Try this file..
Cheers!!
+
*I di
Dear Rockernayal,
Pls share a workbook with us.
Regards,
Gawli Anil
On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja 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 ,
> document no. whe
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
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
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 wrote:
> Dear Ashish
>
> Your Code is work
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, 20
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]
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 wrote:
> Dear Vaibhav Joshi, all fil
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 M
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 wrote:
> Well done, Thanks
>
> On Wednesday, December 17, 2014 3:41:22 PM UTC+3, Vabz wrote:
>>
>> hi
>>
>> can you share your experience with
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
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 th
PFA
+
*I did not do this for you. God is here working through me for you.*
-- Forwarded message --
From: Vaibhav Joshi
Date: Sat, Dec 20, 2014 at 6:33 PM
Subject: Re: $$Excel-Macros$$ solve vba Query
To: Ashish Kumar
Check formula column...
Cheers!!
+
*I did not do t
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
> > wrote:
>>
>> Hey Zafar,
>>
>>
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" >
> wrot
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 wrote:
> Dear Experts,
> Below mentioned code is to
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 wrote:
> Dear All,
>
>
> PFA. there have two column we w
55 matches
Mail list logo