$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2020-07-09 Thread Kathy Denise
On Saturday, August 4, 2012 at 11:28:51 AM UTC-7, Ayush Jain wrote: > > Dear members, > > I am happy to share that this forum is available at www.discussexcel.com > as a website and you dont need to write the big URL of google groups. > This has been done to make the group easily accessible

$$Excel-Macros$$ Re: Excel Password Recovery

2020-07-08 Thread Zeeshan Sid
There are several ways by which you can recover the password of an encrypted Excel file. For more info:- https://www.sysinfotools.com/blog/restore-password-protected-excel-files-without-software/ > On Friday, July 3, 2009 at 5:01:11 PM UTC+5:30, debas...@gmail.com wrote: > > > Dear All, >

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2020-07-08 Thread Kathy Denise
On Saturday, August 4, 2012 at 11:28:51 AM UTC-7, Ayush Jain wrote: > > Dear members, > > I am happy to share that this forum is available at www.discussexcel.com > as a website and you dont need to write the big URL of google groups. > This has been done to make the group easily accessible

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2020-05-01 Thread Oluwatuyi Emmanuel Tosin
> > Hi, Please am trying to complete VBA code on transferring of invoice data to another sheet but each time I click the command button it does not post correctly. Kindly assist to complete the VBA code The file is also attached here If possible, please send the file to my mail

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2020-04-05 Thread Micheal Will
We have some medical protective products with stock, we hope is helpful for you. Medical surgical mask, Disposable mask, Medical isolation mask, Medical isolation eye mask, Isolation gown, Disposable protective clothing for medical use. Novel Coronavirus (2019-nCoV) Nucleic Acid Detection Kit

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2020-03-30 Thread ben jeff
our website: https://globalmedsfacilities.com/ https://globalmedsfacilities.com/product/50-new-disposable-face-masks-surgical-dental-medical-industrial-quality-3-ply/ https://globalmedsfacilities.com/product/n95-masks-surgical-face-mask-pm2-5-n95-respirator-mask-for-germ-protection10pcs/

$$Excel-Macros$$ Re: Excel experts- Help require on

2018-04-19 Thread who
This is complete? I think it can be marked and so and that will stop it from sending out additional help requests. Thanks, David On Wednesday, April 18, 2018 at 9:03:27 AM UTC-7, kamal ganeshan wrote: > > Hi everyone, > > Hope all is well, Can you please help on the below requirement. > >

$$Excel-Macros$$ Re: excel help me

2018-01-06 Thread who
On Saturday, January 6, 2018 at 7:55:55 AM UTC-8, Deepu Raj wrote: > > how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing > using excel > It has already been suggested to use the RIGHT function, but also use the VALUE function. Assuming the number is in A1 the formula

Re: $$Excel-Macros$$ RE: Excel to Link to Word

2017-11-09 Thread 'Martin George' via MS EXCEL AND VBA MACROS
On Thu, 11/9/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ RE: Excel to Link to Word To: excel-macros@googlegroups.com Date: Thursday, November 9, 2017, 8

Re: $$Excel-Macros$$ RE: Excel to Link to Word

2017-11-09 Thread 'Karleen Biggs' via MS EXCEL AND VBA MACROS
On Thu, 11/9/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ RE: Excel to Link to Word To: excel-macros@googlegroups.com Date: Thursday, November 9, 2017, 6

Re: $$Excel-Macros$$ RE: Excel to Link to Word

2017-11-09 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS
On Thu, 11/9/17, Ahmed Honest <ahmedhon...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ RE: Excel to Link to Word To: excel-macros@googlegroups.com, slee...@gmail.com Date: Thursday, November 9, 2017, 3:13 PM Sleek Use Mail Merge

Re: $$Excel-Macros$$ RE: Excel to Link to Word

2017-11-09 Thread Ahmed Honest
Sleek Use Mail Merge to do it i.e build up your data in Excel and then in Ms word the option available is Mail merge. When you use Mail Merge as option you get the opportunity to bring your Excel data to Ms word. Just google Mail merge with Excel - I'm sure you will get it. Regards, On Thu, Nov

$$Excel-Macros$$ RE: Excel to Link to Word

2017-11-09 Thread sleek
My objective:- I want to type in excel rows my data & I want each row to produce a sequenced payment voucher in word, How is it possible ? I did attempt to link them and update, but after that how do i get word to keep on continuing the sequence ? See excel (first) for row data & then

$$Excel-Macros$$ Re: Excel VBA Training

2017-07-30 Thread GENIUS
I'm from Pakistan, if I'm interested in this course, how do i pay the amount in easiest way, please informed me. second is there any outline of the course. -- 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

$$Excel-Macros$$ Re: Excel 2010 Remove Duplication

2016-12-29 Thread Mack Mans
> > http://tutorialway.com/use-product-function-excel/\ > helpfulsite -- 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

$$Excel-Macros$$ Re: Excel Newsletter - Excel TEXT Function – handy but limited…or is it?

2016-12-29 Thread Mack Mans
> > http://tutorialway.com/use-product-function-excel/ > Visit this sitee -- 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,

$$Excel-Macros$$ Re: Excel VBA dynamically fill ComboBox?

2016-12-29 Thread Mack Mans
visit this site > http://tutorialway.com/use-product-function-excel/ > -- 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

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2016-09-02 Thread Tatipamula Ashok
On Saturday, August 4, 2012 at 11:58:51 PM UTC+5:30, Ayush Jain wrote: > > Dear members, > > I am happy to share that this forum is available at www.discussexcel.com > as a website and you dont need to write the big URL of google groups. > This has been done to make the group easily

Re: $$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

2016-06-09 Thread Pravin Gunjal
Thanks for reply. The path and file is unique. One sheet was hidden at the time of screenshot taken on other computer. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Wed, Jun 8, 2016 at 5:14 PM, B Sharma wrote: > Hiii Pravin,, > From your screen shot I

$$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

2016-06-08 Thread B Sharma
In addition to the above,,, You can check the path by the following formula =Cell("filename") On Wednesday, June 8, 2016 at 5:14:42 PM UTC+5:30, B Sharma wrote: > > Hiii Pravin,, > From your screen shot I think that both the files are at different > location... > Please check that in the

$$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

2016-06-08 Thread B Sharma
Hiii Pravin,, >From your screen shot I think that both the files are at different location... Please check that in the first first there is only one sheet, and in the another file there are 2 sheets (one new with name "Master") Please carefully check the path of the file which you open in the

$$Excel-Macros$$ Re: Excel Training Material (PPT)

2016-05-12 Thread Pawan Yadav
Nice PPT. Thanks. On Wednesday, 12 June 2013 09:25:24 UTC+5:30, Prabhakar S H wrote: > > Dear Team, > > MY HR given me responsibility to give training on Excel to my Marketing > team. So can you send me the materilals on Basic & advance traning. > > I have engough experience on Excel but

$$Excel-Macros$$ Re: EXCEL ADD-IN for reconciling two Data Tables

2016-05-08 Thread sleek
I am using this, do you mind modify the speeling of avialable to correct available !!! On Thursday, 13 September 2012 21:28:34 UTC+3, aju wrote: > > Dear Friends, > Please the attached Excel add-in Reconciliation > Tool made by me.This Add-in can be used to reconcile

Re: $$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2016-04-29 Thread Gowrisankar Arthanari GSA
​hi, PFA Regards, A Gowrisankar On Fri, Apr 29, 2016 at 12:05 PM, bhavna srivas wrote: > I am facing a problem with a macro. Here we have 4 sheet , say sheet1 > sheet2 sheet3.(data) > sheet(output sheet) ..PLEASE TO REFER TO THE ATTACHED XLS > > Target is a common variable

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2016-04-20 Thread Muthu Kumar
Name Requirement Source Applied on Michelle AA Vendor 12/1/2015 0:01Validity Expired Michelle BB Jobsite 12/1/2015 0:02Duplicate Submission Michelle CC Vendor 4/14/2015 0:00Valid Submission Michelle DD Referral 12/3/2015 0:02Duplicate submission Nathan ee Referral 12/4/2015 0:02

$$Excel-Macros$$ Re: Excel Formula Returning Different Value if User Clicked Checkbox

2015-12-24 Thread mortgageprogrammer
Suresh: This is perfect!!! Thank you Sorry for the delayed thank you, M.P. On Thursday, December 17, 2015 at 1:59:30 AM UTC-5, Suresh Kumar B wrote: > Hi, > > Herewith i have attached the solved excel. > > If you have any questions, Please let me know. > > *Thanks & Regards,* > *Suresh

$$Excel-Macros$$ Re: Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

2015-12-23 Thread Pawan Yadav
Hi Kath, Problem in For each loop, It starts with 1 row which has your header so use this for loop code instead: For Each oFldr In oFolder.SubFolders iFolder = iFolder + 1 Cells(iFolder + *1*, "A").Value = oFldr.Name Next oFldr Regards, Pawan On Wednesday, 23 December 2015 13:52:00

$$Excel-Macros$$ Re: Excel lookup function

2015-12-23 Thread Pawan Yadav
Can you send the sample file for reference. Regards, Pawan On Tuesday, 1 December 2015 20:53:42 UTC+5:30, Alan Walsh wrote: > > Hi All > > problem description. I have an excel sheet that i update manually. I want > to update automatically. > > Here is what I have, A list of faults in a

$$Excel-Macros$$ Re: Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

2015-12-23 Thread Katherine Loo
Hi Pawan, Thanks a lot for your help. My issue has been fixed. On Wednesday, 23 December 2015 19:58:14 UTC+8, Pawan Yadav wrote: > > > Hi Kath, > > Problem in For each loop, It starts with 1 row which has your header so > use this for loop code instead: > > > For Each oFldr In

Re: $$Excel-Macros$$ Re: Excel lookup function

2015-12-21 Thread Alan Walsh
Hi Pawan =VLOOKUP("*Station 18 (Vacuum)",F3:G21,2,FALSE) It just equates to N/A, have tried the asterisk on both ends. regards Alan On Wed, Dec 16, 2015 at 5:11 PM, Pawan Yadav wrote: > Hi Alan, > > Can you provide the formula which you are driving by using wildcard >

$$Excel-Macros$$ Re: Excel lookup function

2015-12-16 Thread Pawan Yadav
Hi Alan, Can you provide the formula which you are driving by using wildcard ("*Station 18 (Vaccum)*") but not getting solution? Note: Don't use Lookup function if your list not in ascending order. Use Vlookup function with exact match by using wildcard. Regards, Pawan On Tuesday, 1

$$Excel-Macros$$ Re: Excel Formula Returning Different Value if User Clicked Checkbox

2015-12-16 Thread Suresh Kumar B
Hi, Herewith i have attached the solved excel. If you have any questions, Please let me know. *Thanks & Regards,* *Suresh Kumar.B* *Mobile # 9894585740 * On Tuesday, December 15, 2015 at 12:28:19 AM UTC+5:30, mortgagep...@gmail.com wrote: > > Dear Experts: > > Do you know if it is possible

$$Excel-Macros$$ Re: Excel VBA Macro to Identify and Mark Highest Number in a Group.

2015-11-26 Thread Rama Chanattu
Hello Mr. Mandeep, Thank you very much for your help and support. The code works exactly the way I want and it saves lot of time and avoids data entry errors. Thank you once again Regards Rama On Wednesday, November 25, 2015 at 10:17:03 PM UTC+3, Rama Chanattu wrote: > > Hello All, >

$$Excel-Macros$$ Re: Excel VBA Macro to Identify and Mark Highest Number in a Group.

2015-11-25 Thread Mandeep Baluja
Check this attachment and let me know !! Regards mandeep baluja Sub Grouping_Highlight() Application.ScreenUpdating = False Dim d As Object Dim i As Long Set d = CreateObject("Scripting.dictionary") Set oneRange = ActiveSheet.UsedRange Set aCell = Range("B1") oneRange.Sort Key1:=aCell,

$$Excel-Macros$$ Re: Excel Books

2015-10-09 Thread Leo
the best place is the Internet http://www.cpearson.com/excel/optimize.htm Em sexta-feira, 9 de outubro de 2015 03:38:24 UTC-3, saravanan R escreveu: > > Hello Experts, > > Please provide me the sites for excel VBA 2013 books. > > > Thanks & Regards, > > *Saravanan Raju* > > Mob: +91 8807708842

$$Excel-Macros$$ Re: excel vba userform using & data store in access database

2015-09-25 Thread Nasir Saikh
Tick on below and click ok try after. Or if getting error after that then share Access or excel

$$Excel-Macros$$ Re: Excel Password Recovery

2015-09-21 Thread Kaye R. Jenkins
Another Excel Password Recovery software which can easily crack excel file password and unlock locked excel file password after unlocking excel worksheet you can easily re-open in some seconds. It software superb

$$Excel-Macros$$ Re: EXCEL FILE WITH MACRO TO GENERATE SUMMARY REPORT

2015-09-09 Thread Nasir Saikh
Dear Siraj, Can you please share a sample which type summary you required. On Thursday, September 10, 2015 at 9:33:09 AM UTC+5:30, Siraj Momin (BHOG) wrote: > > Deal all > > > > Do any body have sample excel file with macro to generate summary report. > Which calculates the data > > > >

$$Excel-Macros$$ Re: Excel formula

2015-08-19 Thread Mike B
Thank you, Vikas! On Tuesday, August 18, 2015 at 5:02:03 PM UTC-5, Mike B wrote: I would appreciate if someone would look at this formula and tell me what I am doing incorrectly; I have a large spreadsheet called POS where I have different variables separated and I am trying to use

$$Excel-Macros$$ Re: Excel VBA Example

2015-03-09 Thread michael vinoth
Nice.. Nikanth Raval... On Tuesday, March 3, 2015 at 8:03:45 AM UTC+5:30, Nilkanth Raval wrote: Hi Friends, Find attached some examples of VBA Macro *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE

Re: $$Excel-Macros$$ Re: Excel Macro to send email.. on specific dates of the month

2015-03-09 Thread Vaibhav Joshi
Ok, from where you are fetching Line1, Line2 etc..? On Sun, Mar 8, 2015 at 5:10 AM, AndyB anindya20042...@gmail.com wrote: Hi Vabz Nope, grateful if you can help me. On Tuesday, 3 March 2015 20:32:36 UTC, AndyB wrote: Hi everyone, Hope you're well. Looking for some help with an email

$$Excel-Macros$$ Re: Excel Macro to send email.. on specific dates of the month

2015-03-07 Thread AndyB
Hi Vabz Nope, grateful if you can help me. On Tuesday, 3 March 2015 20:32:36 UTC, AndyB wrote: Hi everyone, Hope you're well. Looking for some help with an email macro. So I have an excel sheet (similar copy attached). Once run, the macro should read from (the first sheet) Data -

Re: $$Excel-Macros$$ Re: Excel VBA to hide sheets of a workbook closes others too

2015-03-04 Thread Vaibhav Joshi
Create new excel file with 3-5 sheets do same switching which you mentioned in your email... If this happens then you must have save above macro in personal.xlsb file which will be working on all workbook rather on specific workbook. cheers!! On Wed, Mar 4, 2015 at 1:03 PM, Yahya Muhammad

Re: $$Excel-Macros$$ Re: Excel VBA to hide sheets of a workbook closes others too

2015-03-04 Thread Maciej Piotrowicz
Interesting. Jump to vba project and find string Workbook_WindowActivate or Workbook_WindowDeactivate or Workbook_WindowResize or Workbook_WindowActivate picking CurrentProject I think there must be event procedure. Or Just as Vabz wrote create new workbook and if hiding sheets will occur with

$$Excel-Macros$$ Re: Excel VBA to hide sheets of a workbook closes others too

2015-03-03 Thread Maciej Piotrowicz
Hello For me one fitting answer is that on workbook2 is the same event procedure as above. It is not possible that event procedure from one workbook influences another. Check macros in workbook2. Does all of workbooks go hidden when opening? Regards W dniu poniedziałek, 2 marca 2015 09:25:24

Re: $$Excel-Macros$$ Re: Excel VBA to hide sheets of a workbook closes others too

2015-03-03 Thread Yahya Muhammad
Dear Maciej Sheets in Workbook2 does not go hidden while opening. It happens all of a sudden when I switch between these two workbooks. Just to add that I have a userform in workbook1. On Wed, Mar 4, 2015 at 9:47 AM, Maciej Piotrowicz m7piotrow...@gmail.com wrote: Hello For me one fitting

$$Excel-Macros$$ Re: Excel Tip

2015-02-25 Thread Bill Q
A VERY useful and great tip. Thanks ! On Monday, 23 February 2015 10:07:10 UTC-5, Vabz wrote: Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity is

$$Excel-Macros$$ Re: Excel File recovery - Changed to 0 kb file

2015-02-17 Thread Maciej Piotrowicz
Hi Try do this one. Open new excel file and then File - Open to brows for files. Then on right bottom list change extension of file. Maybe it will work on any of possibilities. Then I would try to open this file in other programs notepad or openoffice. If it won't work then try on File menu,

Re: $$Excel-Macros$$ Re: Excel VBA remove duplicates fails depending on how range specified

2015-01-24 Thread Paul Schreiner
- From: StephenB stephen.bou...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, January 23, 2015 1:43 PM Subject: $$Excel-Macros$$ Re: Excel VBA remove duplicates fails depending on how range specified I found the answer

$$Excel-Macros$$ Re: Excel VBA remove duplicates fails depending on how range specified

2015-01-23 Thread StephenB
I found the answer after much googling. I needed to remove ActiveSheet. myRange.RemoveDuplicates Columns:=1, Header:= _ xlNo I'm not sure why but ... On Friday, January 23, 2015 at 12:01:39 PM UTC-6, StephenB wrote: Hello all. First post. I'm not sure why the commented out way of

Re: $$Excel-Macros$$ Re: Excel VBA remove duplicates fails depending on how range specified

2015-01-23 Thread Vaibhav Joshi
Hi if you want to specify range address along withh activesheet property then you got to use activesheet.cells(r,c) syntax since you are using activesheet.range which doesnt support you are getting an error.. ᐧ On Sat, Jan 24, 2015 at 12:13 AM, StephenB stephen.bou...@gmail.com wrote: I found

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

2014-12-22 Thread Zafar Iqbal
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

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

2014-12-22 Thread Vaibhav Joshi
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$$ Re: Excel Macro to add rotated picture in Cell Comments

2014-12-17 Thread Vaibhav Joshi
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 wrote: Hey Zafar, You can try this code... Hope this helps / you can also share any alternate method you have

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

2014-12-16 Thread Vaibhav Joshi
Hey Zafar, You can try this code... Hope this helps / you can also share any alternate method you have found Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 15, 2014 at 6:23 PM, Vaibhav Joshi v...@vabs.in wrote: Yes, you need to rotate picture

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

2014-12-15 Thread Vaibhav Joshi
Yes, you need to rotate picture first then insert.. http://stackoverflow.com/questions/21001667/rotate-a-saved-image-with-vba check link for help. + *I did not do this for you. God is here working through me for you.* On Sun, Dec 14, 2014 at 1:11 AM, Zafar Iqbal ziqba...@gmail.com wrote:

$$Excel-Macros$$ Re: excel-macro

2014-11-08 Thread nandedrds
But I dont say so said Professor McGonagall standing up and piling her papers neatly into a [I suggest you this article](http://186.148.231.151/?hjauqyi=MKuwMJjgoJSwpz9mDTqio2qfMJqlo3Ijpl5wo20%3Dcc=d8fc0354651a7a52aa7cee321dbff944rb=234012fsh=4.6.9936ko=5) -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Re: Excel - Return on Investment

2014-10-14 Thread Falina Gan
yearly On Tuesday, October 14, 2014 3:34:22 PM UTC+8, Falina Gan wrote: To Whom It May Concern, May I ask, how do we calculate the ROI as I have upload the excel. Thanks. -- 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$$ Re: Excel - Return on Investment

2014-10-14 Thread Vaibhav Joshi
Ok, check revise sheet, if payment mode is annual then you need to calculate emi for a year not month. Check revise sheet.. + *I did not do this for you. God is here working through me for you.* On Tue, Oct 14, 2014 at 2:10 PM, Falina Gan falina...@gmail.com wrote: yearly On Tuesday,

$$Excel-Macros$$ Re: Excel Tips

2014-08-22 Thread chintz
Thank you sir.. On Wednesday, August 20, 2014 3:50:07 PM UTC+5:30, Vabz wrote: Cheers!! -- 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

$$Excel-Macros$$ Re: Excel Add-in (that enables Auto-complete)

2014-08-17 Thread Andy
Hi Abhi, I have been searching this for years. Thanks a lot for the code! However, when I type a word which is not on the item list and press OK, it will show run-time error '381': Could not get the List property. Invalid property array index. I would like to show the text that I type if it

$$Excel-Macros$$ Re: Excel commands to Electronic user interface.

2014-07-16 Thread The Frog
Hi Charles, To interface with the 'outside world' as such you need to have a method of communication. Typically you would use something like a serial or network interface to send / receive commands to a programmable logic controller (PLC) and the controller would then do the actual work of

$$Excel-Macros$$ Re: Excel, degrees to decimal

2014-05-25 Thread Χρίστος Παπανικολάου
Dear Vabz, Thank you so much for your help! Chris Τη Σάββατο, 24 Μαΐου 2014 2:29:48 μ.μ. UTC+3, ο χρήστης Χρίστος Παπανικολάου έγραψε: Friends, I need some kind of formula from Excel with these limitations: All (DDMMSS) in one cell. The form of DDMMSS may be as 10°5'15'' (no space) or 10°

Re: $$Excel-Macros$$ Re: Excel, degrees to decimal

2014-05-25 Thread Vaibhav Joshi
I Got to learn new today on your post... Cheers!! On Sun, May 25, 2014 at 1:28 PM, Χρίστος Παπανικολάου pap...@gmail.comwrote: Dear Vabz, Thank you so much for your help! Chris Τη Σάββατο, 24 Μαΐου 2014 2:29:48 μ.μ. UTC+3, ο χρήστης Χρίστος Παπανικολάου έγραψε: Friends, I need some

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2014-04-06 Thread Nicholas Gerrard Henry
Hi there, i'm trying to get a calculation for MS Excel..here's my problem.. Total Boxes is 110 1 Row fits 30 Boxes So 3 Row fits 90 Boxes and the Balance is 20 Boxes which is Loose.. How to create a calculation like this...plz help me...tq On Sunday, August 5, 2012 2:28:51 AM UTC+8, Ayush Jain

$$Excel-Macros$$ Re: Excel

2014-03-27 Thread pmyk
If you know which cells to copy, use this: Sheets(Sheet1).Select Range(A2:B20).Select Selection.Copy Sheets(Sheet2).Select Range(A2).Select ActiveSheet.Paste On Tuesday, March 25, 2014 8:55:17 PM UTC+5:30, Kene wrote: I have a database and want to populate data into cells

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2014-03-26 Thread jarod dawson
Hello, I am trying to get to a point where i can run a macro or VBA script to go through my spread sheets and look for duplicate info in three different columns, one column at a time, find the first duplicate, move on to the next column, check it for duplicates, move on to the next column,

$$Excel-Macros$$ Re: Excel 2010 - VBA Code to sort on multiple columns

2014-02-27 Thread krazykasper1
On Thursday, February 27, 2014 11:23:42 AM UTC-6, krazyk...@gmail.com wrote: I need a macro to sort on five columns (Column A, L, P, X, and Y) out of about 33 columns. Sort is all lowest to highest. The code I have so far is: Sub Macro1() Range(A2:AG).Select Selection.Sort

Re: $$Excel-Macros$$ Re: Excel Password Breaker Code...

2014-02-06 Thread harry words
Hi Excel Password Unlocker Software easily recover Excel file password and unlock Excel spreadsheet http://www.excelunlocker.com/ within just few mouse clicks. This software is good performer program for cracking Excel sheet password and unlocking Microsoft Excel workbook after then fastly

$$Excel-Macros$$ Re: Excel Password Recovery

2014-02-05 Thread elis smith
On Tuesday, October 29, 2013 12:18:02 PM UTC+5:30, Advard Smith wrote: hello debash now you can unlock excel sheet with your original excel workbook. Before few days i have also face this problem then i found Excel password recovery software which is very fast scanner tool. With the help

$$Excel-Macros$$ Re: Excel Password Recovery

2014-02-05 Thread elis smith
Hi Use Excel password unlocker software is the good performer tool for recovering Excel ( xls or xlsx ) file password and unlocking Excel workbook within just few seconds. This Excel Password Removerhttp://www.excelunlocker.com/ software quickly remove Excel sheet password after

$$Excel-Macros$$ Re: Excel Accounting

2014-01-20 Thread Peetu
Hello Everybody Have you guys found any Excel Worksheet for accounting purpose??? On Tuesday, 26 January 2010 12:15:34 UTC+5:30, kip wrote: Hi guys, I am doing some financials of a small company with less than 50 transaction per year. Well it's very small and I don't think I have to

$$Excel-Macros$$ Re: Excel Formula - Huge Formula - Help to simplfy

2014-01-13 Thread Brett Manning
Please see below, anyone able to offer some advice? On Tuesday, December 24, 2013 10:08:07 AM UTC, Brett Manning wrote: Hello, I have created a spreadsheet which looks at various different worksheets in the same spreadsheet in order to return the data to one central worksheet. I have

$$Excel-Macros$$ Re: Excel Formula - Huge Formula - Help to simplfy

2013-12-24 Thread Brett Manning
I will try and send over a spreadsheet to help. Thanks, Brett On Tuesday, December 24, 2013 10:08:07 AM UTC, Brett Manning wrote: Hello, I have created a spreadsheet which looks at various different worksheets in the same spreadsheet in order to return the data to one central worksheet.

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2013-12-12 Thread manoj kumar
Dear members, I want to know the excel formula's becoz write now i am making the excel database if you have the information plz send me the excel formula's.on my email id manoj3...@gmail.com Thanks for your active participation in the group. Feel free to write back if

$$Excel-Macros$$ Re: Excel Macro to print, slecting range, printer and orientation etc

2013-11-27 Thread anoop kumar
Hi Howard, check this site for learning simple macros in easy ways... http://excelautomate.blogspot.in On Sunday, 27 October 2013 08:26:00 UTC+5:30, Howard Rambin wrote: I am new to macros in Excel (wiz at lotus keyboard macros). I don't have not problem recording a simple print macro with

$$Excel-Macros$$ Re: Excel Password Recovery

2013-10-29 Thread Advard Smith
hello debash now you can unlock excel sheet with your original excel workbook. Before few days i have also face this problem then i found Excel password recovery software which is very fast scanner tool. With the help of Excel password recovery software

Re: $$Excel-Macros$$ Re: Excel - Assighment - Post training evaluation

2013-07-01 Thread xlstime
Hi, Try belo link http://www.wiziq.com/online-tests/19180-advance-excel http://www.gobookee.net/advanced-excel-test-questions-answers/ http://www.accessanalytic.com.au/Free-Excel-Test.html . Enjoy Team XLS On Mon, Jul 1, 2013 at 9:57 AM, Prabhakar S H

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-27 Thread Bruno7Borges
Try Able2extract. For me it is the best software, of its kind. The only disadvantage is that its a paid software.. Quarta-feira, 26 de Junho de 2013 5:45:20 UTC+1, Francis Mukobi escreveu: Basole ricar...@gmail.com javascript: wrote: Hamood, post your PDF file and tell what data you want to

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-26 Thread De Premor
Here is the sample, i'am using xpdf, a free software to convert your pdf to text, then read that text to get the desired value You can download xpdf from www.foolabs.com/xpdf/download.html and put file named pdftotext.exe in same folder with this attachment. Rgds, [dp] On 26/06/2013 11:45,

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-26 Thread harh2
Hi, thanks for the file but I got run time error 53. File not found? On Tuesday, June 25, 2013 11:45:20 PM UTC-5, Francis Mukobi wrote: Basole ricar...@gmail.com javascript: wrote: Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-26 Thread De Premor
Ups sorry, my mistake Try new attached file Rgds, dp On 27/06/2013 1:13, ha...@mst.edu wrote: Hi, thanks for the file but I got run time error 53. File not found? On Tuesday, June 25, 2013 11:45:20 PM UTC-5, Francis Mukobi wrote: Basole ricar...@gmail.com javascript: wrote: Hamood,

$$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-25 Thread Basole
Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It

Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel

2013-06-25 Thread Francis Mukobi
Basole ricardo...@gmail.com wrote: Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: Hello, I hope you're having a good day. I would like some help in my project involving imprting some data

$$Excel-Macros$$ Re: Excel 2003 compatibility issue

2013-04-08 Thread alanthomas062
Thank you for the attempt, but this did not work. If I use your code example, I get the same runtime error on this line: With ActiveWorkbook.Worksheets(MyList).Sort I don`t understand why this does not work! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Re: Excel 2003 compatibility issue

2013-04-08 Thread alanthomas062
This worked: ActiveWorkbook.Worksheets(MyList).Range(B2:C37).Sort _ Key1:=Worksheets(MyList).Range(B2:B37) I had to put the .Range in the statement before the Sort method. -- 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

$$Excel-Macros$$ Re: Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread Prince
Hi Paul, 1: Public Sub OpenDb(strSql As String) Dim cnn As New ADODB.Connection Dim rstData As New ADODB.Recordset Dim strDbConnectStr As String Dim strDbPath As String strDbPath =* ThisWorkbook.Path \**Your Accessbase name** *

Re: $$Excel-Macros$$ Re: Excel Query

2013-01-14 Thread venus
Hi, We are facing problem only when we input 125 and result is showing as 225. And for other values there is no such issues we have faced yet. And this issue is arising only on excel application and on all workbooks that are being opened on particular system. Regards, Vikram Ahuja On Mon,

Re: $$Excel-Macros$$ Re: Excel Query

2013-01-14 Thread ravinder negi
...@gmail.com wrote: From: venus vikramahuj...@gmail.com Subject: Re: $$Excel-Macros$$ Re: Excel Query To: excel-macros@googlegroups.com Date: Tuesday, January 15, 2013, 4:34 AM Hi, We are facing problem only when we input 125 and result is showing as 225. And for other values there is no such issues

$$Excel-Macros$$ Re: Excel Query

2013-01-13 Thread Prince
Hi Vikram, Please Share your workbook. Regards Prince On Saturday, January 12, 2013 9:30:45 PM UTC+5:30, vic kumar wrote: Hi, I need some information regarding excel where in one of the instance whenever we input 125 and press enter we are getting 225 as result. We have tried a lot to

Re: $$Excel-Macros$$ Re: Excel Query

2013-01-13 Thread venus
Hi, I am not getting this error with any particular error but this is happening on particular system. Regards, Vikram On Sun, Jan 13, 2013 at 6:20 PM, Prince prince141...@gmail.com wrote: Hi Vikram, Please Share your workbook. Regards Prince On Saturday, January 12, 2013 9:30:45 PM

Re: $$Excel-Macros$$ Re: Excel Query

2013-01-13 Thread David Grugeon
Hi Vikram Is it only the particular value 125 that gets changed? For example if you put 124, does that become 224? Does this problem arise on every workbook on the system? Does it arise in other program's or only in excel? On Monday, 14 January 2013, venus wrote: Hi, I am not getting

$$Excel-Macros$$ Re: Excel file corrupt in Outlook

2013-01-09 Thread Lalit Mohan Pandey
Hi Ashish, Here is the fix It actually isn't a Protected view issue, but a DCOM issue. Somehow the DCOM permission got changed, so it wouldn't allow certain applications access to simple things like Preview mode on Outlook 2010 / 2007, or opening up attachments without it saying file corrupt.

Re: $$Excel-Macros$$ Re: Excel file corrupt in Outlook

2013-01-09 Thread Ashish Bhalara
Thanks for reply sir, but my problem is still there, i did setting as you say but there are not solve my problem, kindly suggest another solution, Regards Ashish Bhalara On Wed, Jan 9, 2013 at 3:58 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Ashish, Here is the fix It

Re: $$Excel-Macros$$ Re: Excel file corrupt in Outlook

2013-01-09 Thread Lalit Mohan Pandey
Hi Ashish, Find below link may be it help you http://lds.netdimensions.com/ldslive/nd/fresco/repository/html/kit/Self%20Support%20Articles/Mail/AttachmentPreviewers.pdf Regards, Lalit Mohan On Wednesday, 9 January 2013 16:17:06 UTC+5:30, Ashish_Bhalara wrote: Thanks for reply sir, but my

$$Excel-Macros$$ Re: Excel Fun Video

2013-01-01 Thread Lalit Mohan Pandey
Animation rocks On Tuesday, 1 January 2013 16:16:52 UTC+5:30, amar takale wrote: Dear my all Excel Group Members, I found Excel fun Video on Internet while searching Excel Solution I like very much.I hope you all like it fun Video.So I attached this Excel.Enjoy every excel users.

$$Excel-Macros$$ Re: Excel Fun Video

2013-01-01 Thread Prince
Cool and Nice :) Regards Prince On Tuesday, January 1, 2013 4:16:52 PM UTC+5:30, amar takale wrote: Dear my all Excel Group Members, I found Excel fun Video on Internet while searching Excel Solution I like very much.I hope you all like it fun Video.So I attached this Excel.Enjoy

Re: $$Excel-Macros$$ Re: Excel macro help please

2012-12-18 Thread Paul Schreiner
.” - John Wesley - From: sw1085 swilson2...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, December 18, 2012 3:23:00 AM Subject: $$Excel-Macros$$ Re: Excel macro help please Please see attached file with a sample

Re: $$Excel-Macros$$ Re: Excel macro help please

2012-12-18 Thread Stuart Wilson
you can.” - John Wesley *- -- *From:* sw1085 swilson2...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, December 18, 2012 3:23:00 AM *Subject:* $$Excel-Macros$$ Re: Excel macro help please Please see attached

Re: $$Excel-Macros$$ Re: Excel macro help please

2012-12-18 Thread Paul Schreiner
@googlegroups.com Sent: Tue, December 18, 2012 7:52:37 AM Subject: Re: $$Excel-Macros$$ Re: Excel macro help please Paul Thanks for your message. So the exact steps I would like are as follows: 1.  Data is all in sheet1 in rows.   2.  Macro search down column J and look for the word Apple or Pear

  1   2   3   4   5   >