$$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

$$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-10 Thread gargee singh
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.faceboo

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

2015-08-18 Thread gargee singh
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 Technically

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

2015-08-17 Thread gargee singh
, _ 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:OW) ! Join official

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

2015-08-12 Thread gargee singh
will 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
- “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 - From: gargee singh garge

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

2015-08-09 Thread gargee singh
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 this forum @ https://www.facebook.com/discussexcel FORUM RULES

$$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 Notes

$$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

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

2015-07-27 Thread gargee singh
, in the 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

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

2014-01-17 Thread gargee singh
: gargee singh garge...@hotmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, January 15, 2014 9:22 AM Subject: $$Excel-Macros$$ batch file Query Hi All, I am trying to run a batch file from a VBA code. Both the excel file and the batch files are placed

$$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 ?

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$$ Help with formula in vba

2013-12-07 Thread gargee singh
\Reports\[Reason Codes.xlsx]Car'!$A$1:$B$62,2,FALSE),VLOOKUP(x2,'C:\Users\User\Desktop\Reports\[Reason Codes.xlsx]Rail'!$A$1:$B$62,2,FALSE)) Thanks and Regards, Gargee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros

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, 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 $$ 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

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

2011-12-08 Thread gargee singh
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, Gargee Singh

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

2011-12-08 Thread gargee singh
for 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

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

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

2011-12-08 Thread gargee singh
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, Gargee

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
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