$$Excel-Macros$$ Generate PDf Invoices from Excel

2018-10-02 Thread gargee singh
”. I have written the script but somehow can’t get the loop to work, my code only generates the first invoice and stops. Also I get the dialogue box for document inspector , can that be avoided. Thank you. Thanks and Regards, Gargee Singh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

$$Excel-Macros$$ Sending email from Excel

2016-12-05 Thread gargee singh
Hello Experts , I need help with being able to send email from excel based on a criteria . As in the excel attached herewith you will see Column D has dates , so if the date in column D is today's date (named range in Column L ) ,the email should be sent out as per the details mentioned in that

$$Excel-Macros$$ Copy over from different workbooks to master workbook

2016-05-02 Thread gargee singh
based on the list retrieved from vba and copy over the 5 tabs .Once all the files are copied over close all other files except the master file. Hope i have been able to explain myself here, however if there are any clarifications required please let me know. Thanks and Regards, Gargee Singh

$$Excel-Macros$$ VBA to save each page of a mail merge document seperately

2016-03-19 Thread gargee singh
hello Group, Need help with saving each page ( as a PDF or a word file) of a mail merge document. I tried to find a few codes on the net but havent been able to work my way around any of those ?:( Thanks and Regards, Gargee Singh -- Are you =EXP

RE: $$Excel-Macros$$ VBA to save each page of a mail merge document seperately

2016-03-19 Thread gargee singh
Hello everyone, Sorry forgot to share the file . Thanks and Regards, Gargee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA to save each page of a mail merge document seperately Date: Wed, 16 Mar 2016 18:50:06 +0530 hello Group, Need help

$$Excel-Macros$$ Help with sending file as an email with vba

2015-09-09 Thread gargee singh
u Mail has been sent to " & SendID) End Sub Thanks and Regards, Gargee Singh -- 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.fa

RE: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-18 Thread gargee singh
n and help me improve the code. It works wonderfully now. :) :) Thanks and Regards, Gargee Singh Date: Tue, 18 Aug 2015 12:14:58 + From: schreiner_p...@att.net To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ not able to repeat code through all sheets in workbook "T

$$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-17 Thread gargee singh
s, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End Sub Thanks for the help in advance. Thanks and Regards, Gargee Singh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N

RE: $$Excel-Macros$$ Query for Code

2015-08-12 Thread gargee singh
change since month of start can change. 4) The sample sheet is attached. Notes :- we will have multiple sheets in the exactly same format in this workbook. Thanks and Regards, Gargee Singh Date: Tue, 28 Jul 2015 11:35:04 + From: schreiner_p...@att.net To: excel

RE: $$Excel-Macros$$ Help with saveas file code

2015-08-11 Thread gargee singh
ath to the user's My Documents folder. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -----

$$Excel-Macros$$ Help with saveas file code

2015-08-09 Thread gargee singh
= 1 If .Show Then .Execute End With End Sub Thanks for the help in advance. Thanks and Regards, Gargee Singh -- 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

RE: $$Excel-Macros$$ Query for Code

2015-07-27 Thread gargee singh
summary sheet we want to see total of all centres based on the month of selection which is a respective start date. You can also suggest if there is a better way to do this. Hope this helps. Thanks and Regards, Gargee Singh Date: Mon, 27 Jul 2015 14:12:27 + From: schreiner_p...@att.net To

$$Excel-Macros$$ Query for Code

2015-07-27 Thread gargee singh
Notes :- The workbook will contain close to 200 individual sheets and one summary sheet. The data in the summary sheet will be given to me by individual teams and I will need to look at the summary sheet. Requirements :- ns-serif" size="2" style="font-size:10pt;" color="#00">

$$Excel-Macros$$ Code Loops indefiniely due to cell value

2015-07-27 Thread gargee singh
Dear Experts I wrote a code to multiply or divide a range of numbers by 1000 if depending on whether a user selects a yes or no from a drop down in cell k2 in the active sheet. The problem is that once I select “yes” or “no” the code loops indefinitely because it finds a yes or no in the cell

RE: $$Excel-Macros$$ batch file Query

2014-01-17 Thread gargee singh
can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: gargee singh To: "excel-macros@googlegroups.com" Sent: Wednesday, January 15, 2014 9:22 AM Subject: $$E

$$Excel-Macros$$ batch file Query

2014-01-15 Thread gargee singh
Hi All, I am trying to run a batch file from a VBA code. Both the excel file and the batch files are placed in the same folder.However the batch file does not extract names when I run it from VBA, if I do it manually then It works fine. Mentioned below are the codes, what could be the issue ? Ba

RE: $$Excel-Macros$$ Help with formula in vba

2013-12-07 Thread gargee singh
" & "OTH" & ",vlookup(x2,'C:\Users\User\Desktop\Reports\[Reason Codes.xlsx]Others'!$A$1:$B$62,2,FALSE),IF(K2=" & "CAR" & ",vlookup(x2,'C:\Users\User\Desktop\Reports\[Reason Codes.xlsx]Car'!$A$1:$B$62,2,FALSE),VLOOKUP(x2,&#

RE: $$Excel-Macros$$ Help with formula in vba

2013-12-07 Thread gargee singh
Hi Ravinder, thanks a lot, yes this is very helpful. exactly what i needed . :) Thanks and Regards, Gargee Singh From: ravinderexcelgr...@gmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 12

RE: $$Excel-Macros$$ discussexcel formula quiz 1

2012-11-10 Thread gargee singh
done.. waiting for results.. Thanks and Regards, Gargee Singh CC: excel-macros@googlegroups.com From: shreedar.panduranga...@gmail.com Subject: Re: $$Excel-Macros$$ discussexcel formula quiz 1 Date: Sat, 10 Nov 2012 14:10:23 +0530 To: excel-macros@googlegroups.com Done! On 10-Nov-2012

RE: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row

2011-12-09 Thread gargee singh
Hi Ashish, Thanks for the help once again. It works perfectly. Thanks and Regards, Gargee Singh Date: Fri, 9 Dec 2011 22:47:50 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row From: koul.ash...@gmail.com To: excel-macros@googlegroups.com Sub tests

RE: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row

2011-12-09 Thread gargee singh
Hi Ashish, If you select both the columns ie D and E in audit sheet and do a paste special - transpose , that is what it should look like . Thanks and Regards, Gargee Singh Date: Fri, 9 Dec 2011 22:21:01 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple

RE: $$Excel-Macros$$ $$ excel - macro $$

2011-12-08 Thread gargee singh
Hi Ashish Yes , that's what i had thought, seems a good idea. Thanks for the help once again.. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 23:18:02 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com in

RE: $$Excel-Macros$$ $$ excel - macro $$

2011-12-08 Thread gargee singh
Hi Don Thanks for your time and help , one fellow group member helped me with the code and it seemed to work fine. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11

RE: $$Excel-Macros$$ $$ excel - macro $$

2011-12-08 Thread gargee singh
argee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 22:58:21 +0530 Hi Ashish, Thanks for such quick reply and time. This is fantastic :) .Completely meets my requirements. Thanks and Regards, G

RE: $$Excel-Macros$$ $$ excel - macro $$

2011-12-08 Thread gargee singh
Hi Ashish, Thanks for such quick reply and time. This is fantastic :) .Completely meets my requirements. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:51:54 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ $$ excel - macro $$

2011-12-08 Thread gargee singh
and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:09:11 -0600 It would be

RE: $$Excel-Macros$$ $$ excel - macro $$

2011-12-08 Thread gargee singh
the help. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu

$$Excel-Macros$$ $$ excel - macro $$

2011-12-08 Thread gargee singh
a for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards