Re: $$Excel-Macros$$ Unsubscribing due to unsolicited emails

Noted Paul... Thanks' Eugene On Thu, Aug 9, 2018 at 8:51 PM Paul Schreiner wrote: > Dear fellow programmers, > I have been a member of this group for a number of years, but the extreme > abundance of unsolicited SPAM in the form of job postings (which is > specifically disallowed in the forum

Re: $$Excel-Macros$$ Macros for screenshot

use ActiveSheet.Paste to paste the content from excel clipboard. Regards Eugene On Thu, Mar 23, 2017 at 1:43 PM, suresh k wrote: > Hi All, > > I have 10 files in my c drive. I have to capture other applications > screenshot and paste in all 10 files. > > I am able to

Re: $$Excel-Macros$$ Accessing a function of another Workbook.

At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Monday, November 21, 2016 3:31 AM, Eugene Bernard < > eugene.bern...@gmail.com> wrote: > > > I have two open workboo

$$Excel-Macros$$ Accessing a function of another Workbook.

I have two open workbooks A and B, in my system, and I like to use the function available in Workbook A from Workbook B. Is it possible. Regards Eugene -- 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$$ Re: ExcelQuery

Thanks Mark !!! Regards Eugene On Wed, Apr 20, 2016 at 7:06 AM, noodnutt wrote: > Hi Eugene > > This link provides an example of extracting data from multiple workbooks > and condensing it into 1 file: > > https://msdn.microsoft.com/en-us/library/gg549168.aspx > > As a side

$$Excel-Macros$$ ExcelQuery

Hi All, Please find attached Book1.xls, where in I am using an ExcelQuery Script to extract data from 12 different files and saving it in 12 sheets. I like to save the data in single sheet. Regards Eugene -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

Please remove the $ from the formuala =AND(F5<>"",F5 wrote: > > > > Respected All > > I have attached excel files too It has some still issue . I think there > is some correction required in the

$$Excel-Macros$$ Split a row based on a condition

Hi all, Please find below a snap, My requirment scenario is, I have components like "A001","C001" and "B001" going thro 3 production process, i call it here as Stages as "S1","S2" and "S3". If I release a work order to produce a component "A001" on 25th Aug, it goes thro 3 stages on various

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

Hi Van, Excellent sample, Thanks. Eugene On Wed, Jul 22, 2015 at 12:47 AM, Bé Trần Văn betnmtdongna...@gmail.com wrote: B3 selected in the drop down list, View Results. 2015-07-21 19:08 GMT+07:00 Paul Schreiner schreiner_p...@att.net: First: Your EMP ID field is mixed with text and

Re: $$Excel-Macros$$ What will be the best code to count the number of visible rows after autofilter.

://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Friday, March 20, 2015 at 9:35:43 PM UTC+5:30, Eugene Bernard wrote: The below code already given in this group by Mr Asish Kumar start= ActiveSheet.UsedRange.Offset(1).SpecialCells( xlCellTypeVisible

Re: $$Excel-Macros$$ What will be the best code to count the number of visible rows after autofilter.

The below code already given in this group by Mr Asish Kumar start= ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeVisible).Row end= ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row norows=end-start+1 Regards Eugene On Thu, Mar 19, 2015 at 12:56 PM, Mandeep baluja

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

Hi Asish, Thank you, The two line code is very useful for me. Thanks again. Eugene On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Eugene, PFA, Filter your data then after hit the button Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

Dear Vaibhav, When I hit the button, I am getting the below error. [image: Inline image 1] Regards Eugene On Sat, Mar 7, 2015 at 4:00 PM, Vaibhav Joshi v...@vabs.in wrote: Check this.. Cheers!! On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Eugene,

Re: $$Excel-Macros$$ Re: Finding Start and End visible Row numbers

Mandeep, Thanks for the reply. But this is not my requirement. Please see the below macro. Sub test() ThisWorkbook.Activate mynum = Application.InputBox(Enter a Code) Cells(1, 25).Value = (mynum) ActiveSheet.ListObjects(Table1).Range.AutoFilter Field:=1, Criteria1:=mynum End Sub The user input

Re: $$Excel-Macros$$ Re: Finding Start and End visible Row numbers

Thank you Mandeep !!! Now i got it. Regards Eugene On Thu, Mar 5, 2015 at 4:49 PM, Mandeep baluja mandeepbal...@gmail.com wrote: giving correct results which is going in g7 and g8 what else do you want Sub test() ThisWorkbook.Activate mynum = dw* Cells(1, 25).Value = (mynum)

$$Excel-Macros$$ Finding Start and End visible Row numbers

Hi all, Please find attached a sample file , where I use a macro test to filter code. I like to get the Start and End row numbers of the filtered rows. For example if I give the filter value of CP*, the start and end row numbers for the visbile rows are 7 and 13 respectively. How to get these

Re: $$Excel-Macros$$ Worksheet Function

can.” - John Wesley* - *From:* Eugene Bernard eugene.bern...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, January 8, 2015 11:50 AM *Subject:* $$Excel-Macros$$ Worksheet Function Please find attached a sheet, where i am facing

$$Excel-Macros$$ Worksheet Function

Please find attached a sheet, where i am facing a error in the one liner macro. TIA Regards Eugene -- 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$$ Happy New 2015

Hi all, Happy new year to you all. Regards Eugene On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi v...@vabs.in wrote: Joyous January –Fabulous February Magical March –Adorable April Magnificent May –Jolly June Jubilant July –Awesome August ScintillatingSeptember –Outstanding October

Re: $$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

to the Microsoft Outlook Object Library (Tools References... in the VBA editor) Check this.. + *I did not do this for you. God is here working through me for you.* On Fri, Dec 12, 2014 at 10:31 PM, Eugene Bernard eugene.bern...@gmail.com wrote: Just like put a string inside a day box

$$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

I like to put the strings from the column test of attached excel file in the Outlook calander (month format), based on date values. Is it possible. TIA Eugene -- 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

Re: $$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

/excel-questions/553718-excel-visual-basic-applications-update-create-delete-appointments.html + *I did not do this for you. God is here working through me for you.* On Fri, Dec 12, 2014 at 9:52 PM, Eugene Bernard eugene.bern...@gmail.com wrote: I like to put the strings from the column test

$$Excel-Macros$$ To find ADO object reference

How to find programattically using VBA, whether Ms-ADO object is already referenced in my excel vba project. TIA Eugene [image: Inline image 1] On Mon, Dec 8, 2014 at 4:51 PM, Rakesh rksharma...@gmail.com wrote: hello Experts, Need an index formula which combined the index which have na

Re: $$Excel-Macros$$ Tandem filtering

Wesley* - *From:* Eugene Bernard eugene.bern...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, November 18, 2014 11:13 AM *Subject:* $$Excel-Macros$$ Tandem filtering Hi all, I have attached two workbooks, Orders and Stocks

$$Excel-Macros$$ Tandem filtering

Hi all, I have attached two workbooks, Orders and Stocks. In the Orders workbook, I have a macro, which filters Itemwise once I run the macro and enter the filter values like A001, A002 etc.,. I like to have a slight modifications in the same macro, so that, when I run the macro, filtering

Re: $$Excel-Macros$$ Re: Fix the Shape

, Nov 15, 2014 at 10:50 AM, Eugene Bernard eugene.bern...@gmail.com wrote: Thanks, I am, temporarily doing by this mehod only. regards Eugene On Sat, Nov 15, 2014 at 9:49 AM, Mandeep Baluja rockerna...@gmail.com wrote: Try Freeze panes On Thursday, November 13, 2014 4:38:49 PM UTC+5:30

Re: $$Excel-Macros$$ Re: Fix the Shape

Thanks, I am, temporarily doing by this mehod only. regards Eugene On Sat, Nov 15, 2014 at 9:49 AM, Mandeep Baluja rockerna...@gmail.com wrote: Try Freeze panes On Thursday, November 13, 2014 4:38:49 PM UTC+5:30, Eugene Bernard wrote: Hi all, FInd attached an excel sheet, where in i

$$Excel-Macros$$ Fix the Shape

Hi all, FInd attached an excel sheet, where in i pasted a circular shape in that sheet. Whenever i scroll down the row, or move accross the column, I want keep the circle on the same position. ie i want to see the same always still i close the sheet. Regards Eugene -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

which clears existing data in sheet 2 from code.. If you need help then do tell me. Cheers On Sep 23, 2014 9:42 PM, Eugene Bernard eugene.bern...@gmail.com wrote: Exactly. Thank you so much Joshi. Is it possible to add the rows in sheet2, without removing existing rows in sheet2

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

me for you.* On Mon, Sep 22, 2014 at 9:38 PM, Eugene Bernard eugene.bern...@gmail.com wrote: Dear Joshi, Thanks for your reply. As already explained in my first post, rows having code with 11 is not to be treated as completed, since 3 rows having codes as 11 is with status tag

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

me for you.* On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard eugene.bern...@gmail.com wrote: -- Forwarded message -- From: Eugene Bernard eugene.bern...@gmail.com Date: Sun, Sep 21, 2014 at 8:54 PM Subject: $$Excel-Macros$$ Moving Completed rows to sheet2 To: excel-macros

Fwd: $$Excel-Macros$$ Moving Completed rows to sheet2

me for you.* On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard eugene.bern...@gmail.com wrote: -- Forwarded message -- From: Eugene Bernard eugene.bern...@gmail.com Date: Sun, Sep 21, 2014 at 8:54 PM Subject: $$Excel-Macros$$ Moving Completed rows to sheet2 To: excel-macros

$$Excel-Macros$$ Moving Completed rows to sheet2

Dear all, Please find attached a sample worksheet, where in i like to move the completed rows to sheet 2 from sheet 1. In the attached example, rows having code 12 is completed which needs to be moved to sheet2. where as 11 is not to be moved since 3 more rows with code 11 is having

Fwd: $$Excel-Macros$$ Moving Completed rows to sheet2

-- Forwarded message -- From: Eugene Bernard eugene.bern...@gmail.com Date: Sun, Sep 21, 2014 at 8:54 PM Subject: $$Excel-Macros$$ Moving Completed rows to sheet2 To: excel-macros@googlegroups.com Dear all, Please find attached a sample worksheet, where in i like to move

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

in the same folder Regards, Basole. 2014-08-29 11:58 GMT-03:00 Eugene Bernard eugene.bern...@gmail.com: Basole, Thanks for your solution. Can you please send me the working example along with excel file with sample data. I tried your code with my data, and i am getting an error message

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

very much. Eugene On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® ricardo...@gmail.com wrote: Ok, is attached files. To test, hold the 2 files in the same folder Regards, Basole. 2014-08-29 11:58 GMT-03:00 Eugene Bernard eugene.bern...@gmail.com: Basole, Thanks for your solution

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

extracts the data from your file T2308.xls (T date: and change the name according to the current(or system date)), using ADO and SQL statement. regards. Basole 2014-08-23 8:55 GMT-03:00 Eugene Bernard eugene@gmail.com javascript:: Dear all, I am daily using the attached sample

$$Excel-Macros$$ Help required for changing the file name in a query programmatically

Dear all, I am daily using the attached sample query file to extract data from an excel file stored in my windows desktop. I am pasting below a part of code from the test.dqy file, where I am daily changing the file name based on the date on which it is being run. Instead of changing it

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

Hi Paul, The code given above works well for the sheets in same workbook. send me the code for data in two different work books. Regards Eugene On Fri, Apr 25, 2014 at 9:15 PM, Paul Schreiner schreiner_p...@att.netwrote: It works perfectly in my workbook. Row 6 is unhighlighted in sheet1

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

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:* Eugene Bernard eugene.bern...@gmail.com *To:* excel

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

Thank you paul, for exposing us to the scripting.dictionary object. Can you please share, some more details and uses of the dictionary Object. Regards Eugene On Tue, Apr 8, 2014 at 7:33 PM, Paul Schreiner schreiner_p...@att.netwrote: I did it two different ways. You IMPLIED that you wanted

$$Excel-Macros$$ Save an Excel file as XML

How to save an excel table data in XML format. TIA. Eugene -- 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$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

Please verify the data on 266th row, with the data above 266 rows. Regards Eugene On Thu, Nov 7, 2013 at 1:59 AM, Denisetoo denise...@gmail.com wrote: I get a run time 1004 when the comment lines are at 266 lines. WIth less than 200 comment lines the code runs fine. The DropDownTmp

Re: $$Excel-Macros$$ Autofill while typing in a cell

Dear Anil, I get an error Can't find the project or library , at the second line Dim Myconnection As Connection, during opening of the Autodropdown.xlsm file. Regards Eugene On Fri, Sep 27, 2013 at 3:13 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Pavan, See the attached

$$Excel-Macros$$ Filter to work in tandem

I have two excel workbooks in open condition. If I filter a value of one particular column in first workbook, i need the same filter condition should get applied to the other open worksheet also. How to achieve this. Please share me the macro or codes. Thanks Eugene -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Re: Formula require

. Regards Eugene On Thu, Jun 6, 2013 at 12:34 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Eugene Bernard, The double negative is used to coerce, as we say, a non-number type into a number type. Since only a number (not text, boolean, error value, etc.) can follow a minus sign

$$Excel-Macros$$ Preserving OLD values

I have a requirement like this If I enter some new value in cell A2, the previous value should get copied or backed up in cell b2. like wise for next 2000 rows. Any help greatly appreciated. Eugene -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Re: Formula require

Thanks Mr Vijaykumar. Regards Eugene On Thu, Jun 6, 2013 at 12:34 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Eugene Bernard, The double negative is used to coerce, as we say, a non-number type into a number type. Since only a number (not text, boolean, error value, etc.) can

Re: $$Excel-Macros$$ Re: Formula require

Hi Prince, What is the use of -- in the formula mentioned by you. The result is OK, but I do not find this of syntax in Excel Help. Please elaborate. Regards Eugene On Tue, Jun 4, 2013 at 5:16 PM, Prince prince141...@gmail.com wrote: may be it can help you.

Re: $$Excel-Macros$$ Data Validation and Automation

Anybody tried this !!! Regards Eugene On Sat, May 18, 2013 at 8:38 PM, Eugene Bernard eugene.bern...@gmail.comwrote: Dear all, Please go through the sheet attached, where there are 4 columns. Column 1 is ID which is used to differentiate the component or item. Column 2 is Stage, which

Re: $$Excel-Macros$$ Macros Tips

Very UsefulThanks to both of you. Regards Eugene On Fri, May 17, 2013 at 8:36 PM, Abhishek Jain abhishek@gmail.comwrote: The link was shared with me by Priti. She is an active learner and finds such stuff. Priti - please share more links like this, if you have. Regards,

Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

Hi Ravindar Thank you. Regards Eugene On Tue, May 7, 2013 at 12:46 PM, ravinder negi ravi_colw...@yahoo.comwrote: Hi, PFA solved. --- On *Mon, 5/6/13, Eugene Bernard eugene.bern...@gmail.com* wrote: From: Eugene Bernard eugene.bern...@gmail.com Subject: $$Excel-Macros$$ Creating

$$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

Hi all, I have a requirement to create a hyper link between two sheets (Summary and detail) in the attached sheet. I need to create a hyperlink in summary sheet, for all the value cells from B2:E5. From the created 16 hyperlinks from summary sheet, if for example , I click on cell B2, the

Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

If Application.EnableEvents = True Exit Sub Err: Application.EnableEvents = True End Sub On Mon, May 6, 2013 at 9:01 PM, Eugene Bernard eugene.bern...@gmail.comwrote: Hi all, I have a requirement to create a hyper link between two sheets (Summary and detail) in the attached sheet

$$Excel-Macros$$ Active Filters

Hi all, How to find list of active filters in place in Excel. Regards Eugene -- 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$$ Two-to-multi column sorting

Mr Koul, Tested the macro, the result is not exactly matching requirement requested by Chris. Regards Eugene On Sat, Jan 26, 2013 at 9:50 PM, ashish koul koul.ash...@gmail.com wrote: Try this Sub sample() Dim i As Long, j As Long Range(a1:b Range(a65356).End(xlDown).Row).Sort

Re: $$Excel-Macros$$ Two-to-multi column sorting

Yes Please. It is working perfectly. Regards Eugene On Sat, Jan 26, 2013 at 11:04 PM, ashish koul koul.ash...@gmail.com wrote: Hi Its working at my place . Please find the working file attached Regards Ashish Koul On Sat, Jan 26, 2013 at 10:58 PM, Eugene Bernard eugene.bern

$$Excel-Macros$$ Allocation problem between Requirement and Stock.

Dear all, Please find attached an excel workbook, having 2 sheets. In this REQT sheet, I need to fill in the column C with the quantities available from Stock sheet, based on Item. The allocation is based on Item, Requirement and Stock. The Requirement is filled in column B of REQT sheet. The

Re: $$Excel-Macros$$ Re: Card List view

Use grid control, to meet your requirement. Regards Eugene On Fri, Jan 11, 2013 at 4:35 PM, Prince prince141...@gmail.com wrote: Hi Chaya, Can you please shere ur workbook. One more thing where is the source of ur data. regards prince On Friday, January 11, 2013 4:03:27 PM UTC+5:30,

Re: $$Excel-Macros$$ Heplp Required

Hi Neeraj, Try these rwo statements. =TODAY()+RANDBETWEEN(1,31) =TIME(RANDBETWEEN(1,12),RANDBETWEEN(0,60),RANDBETWEEN(0,60)) Regards Eugene On Sat, Dec 1, 2012 at 10:48 AM, neeraj chauhan neerajchauhan...@gmail.comwrote: Dear Experts, i want randomly time and date like 10:43 AM

Re: $$Excel-Macros$$ Required Unique data with funtion

Dear Kuldeep, Is it possible to get the data in sorted order. Regards Eugene On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Dear Priyanka, See attached file. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) On

Re: $$Excel-Macros$$ Required Unique data with funtion

How to achieve this thro' functions without manually sorting. Regards Eugene On Fri, Nov 9, 2012 at 11:56 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Sure Priyanka, First Sort data then use formula. It's working fine. Regards, Kuldeep Singh On Fri, Nov 9, 2012 at 11:52 AM, Eugene

Re: $$Excel-Macros$$ MsgBox Query

Try this MsgBox (Sheets(1).Range(a1)) Regards Eugene On Tue, Oct 23, 2012 at 10:40 AM, SAJID MEMON sajidwi...@hotmail.comwrote: Dears, Find enclosed above attachemnt I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX Awiting... Sajid Memon -- Join official