$$Excel-Macros$$ Re: Reading Layout VBA

2018-07-09 Thread karthikeyan sankaran
Hi All, How to create Reading Layout in Excel and how to insert in Excel bar. Thanks, karthik On Sat, Jul 7, 2018 at 11:18 AM karthikeyan sankaran < karthikeyansankar...@gmail.com> wrote: > Hi All, > > How to create Reading Layout in Excel and how to insert in Excel

$$Excel-Macros$$ Reading Layout VBA

2018-07-06 Thread karthikeyan sankaran
Hi All, How to create Reading Layout in Excel and how to insert in Excel bar. Thanks, karthik -- 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) U

Re: $$Excel-Macros$$ Reg: copy files from folder to another Based On Cell List using vba

2017-05-11 Thread karthikeyan sankaran
On Tue, May 9, 2017 at 3:38 PM, karthikeyan sankaran < karthikeyansankar...@gmail.com> wrote: > Hi, > > Any one help to solve , copy files from folder to another folder based On > Cell List using vba. > > Pls attach sample excel sheet. > > Thanks > karthik > &

$$Excel-Macros$$ Reg: copy files from folder to another Based On Cell List using vba

2017-05-09 Thread karthikeyan sankaran
Hi, Any one help to solve , copy files from folder to another folder based On Cell List using vba. Pls attach sample excel sheet. Thanks karthik -- 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 @ http

$$Excel-Macros$$ Password Protection

2017-02-19 Thread karthikeyan sankaran
Dear All, I have 100 adobe Payslip-files in one folder. I have share that folder via mail to everyone. Now , I need to enter Employee code that particular Adobe file only wants to open. Other adobe Payslip-files does not show to others. Thanks, karthik. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: Fwd: Fwd: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.

2013-05-16 Thread DHAMODHARAN KARTHIKEYAN
hn Wesley > *- > > > -- > *From:* DHAMODHARAN KARTHIKEYAN > *To:* Paul Schreiner ; > excel-macros@googlegroups.com > *Sent:* Thu, May 16, 2013 2:41:06 PM > *Subject:* Re: Fwd: Fwd: $$Excel-Macros$$ PROTECT

Fwd: Fwd: $$Excel-Macros$$ Sorting and Numbering through Macros

2013-05-16 Thread DHAMODHARAN KARTHIKEYAN
ely no interest in coding for requirements which keep escalating or changing with each response. Rgds. On May 16, 2013 8:29 PM, "DHAMODHARAN KARTHIKEYAN" wrote: > Dear Friend, > > *Sub : Sorting and Numbering through Macros.* > > First, I'd like to mention my tha

Re: Fwd: Fwd: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.

2013-05-16 Thread DHAMODHARAN KARTHIKEYAN
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 > *--------- > > > --

Fwd: $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX.

2013-05-16 Thread DHAMODHARAN KARTHIKEYAN
o all the people you can, As long as ever you can.” - John Wesley *----- -- *From:* DHAMODHARAN KARTHIKEYAN *To:* excel-macros@googlegroups.com *Sent:* Thu, May 16, 2013 10:10:53 AM *Subject:* $$Excel-Macros$$ PROTECT EACH SHEET WITH MSG BOX. Dear Friend(s), *S

$$Excel-Macros$$ IDENTIFY EMPTY SHEETS AND MOVE TO END

2013-05-16 Thread DHAMODHARAN KARTHIKEYAN
Dear Friend(s), *SUB : IDENTIFY EMPTY SHEETS AND MOVE TO END.* I have more than 50 sheets in a file. I may not be aware, where the empty sheets are placed. Hence, I look for the following : 1. Identify the Empty Sheet / Display the Empty Sheet with Msg Box. 2. Then, move

Fwd: $$Excel-Macros$$ Excel Validation

2013-05-16 Thread DHAMODHARAN KARTHIKEYAN
will be there will be no possibilities to enter a wrong PAN number.* *let me know if u want this kind of solution.* *Regards* On Thu, May 16, 2013 at 2:07 AM, DHAMODHARAN KARTHIKEYAN < deekart...@gmail.com> wrote: > Dear Friend, > > > First, I'd wish to express my sincere t

$$Excel-Macros$$ Excel Validation

2013-05-15 Thread DHAMODHARAN KARTHIKEYAN
Dear Friends, *Sub : Validation.* Please see the attached sheet, which is self-explanatory. I need to have validation for PAN. That is, the PAN structure is AAAPA 1234 A First, Five Characters are to be only ALPHA i.e. AAAPA Sixth to Ninth Character have to be only Numeral i.e. 1234 Tenth Ch

$$Excel-Macros$$ Sorting and Numbering through Macros

2013-05-15 Thread DHAMODHARAN KARTHIKEYAN
File not attached in my previous mail. I will avoid such things in future. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Dear Friends, At the outset, I would like to introduce myself as a reader of your group mails. I do not have knowledge in

$$Excel-Macros$$ Sorting and Numbering through Macros

2013-05-15 Thread DHAMODHARAN KARTHIKEYAN
Dear Friends, At the outset, I would like to introduce myself as a reader of your group mails. I do not have knowledge in Excel VBA Codes. However, after started reading certain mails of your group, I gradually improved my interest in Excel VBA Codes. I am just a learner of any interested subjec

Re: $$Excel-Macros$$ mouse right click option not working in excel sheets

2013-04-02 Thread karthikeyan sankaran
re but Don't Delete that. Thanks karthikeyan On 2 April 2013 14:03, excel lerner wrote: > good evening experts > > I am using excel 2007.In my excel work book i have 10 sheets with > defferent names.i want to colour the sheet tabs.when i right click on > sheet name wit

Re: $$Excel-Macros$$ Locking Only Selected Cell

2012-09-14 Thread karthikeyan sankaran
Hi, Select sheet(Ctrl+A)--Goto Format cells--untick*Locked*--Ctrl+Click desire cell--Goto Format cells--tick*Locked*--ok--click*protect sheet*. Now desire cell only lock. Thanks karthik On 14 September 2012 17:07, sharad jain wrote: > Dear Experts, > > Can someone please let me know how to loc

$$Excel-Macros$$ Re: file rename-macro help

2012-07-28 Thread karthikeyan sankaran
Can any one help . attach sample excel sheet. On 27 July 2012 18:53, karthikeyan sankaran wrote: > Hi, > > I have a 500 files(.pdf/.xls/.txt) in one folder.How to get .pdf files > name only in excel sheet and rename desired name what i entered in > other column in excel sheet.

Re: $$Excel-Macros$$ file rename-macro help

2012-07-27 Thread karthikeyan sankaran
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: karthikeyan sankaran > To: excel-ma

Re: $$Excel-Macros$$ file rename-macro help

2012-07-27 Thread karthikeyan sankaran
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 > - > > > > > > F

$$Excel-Macros$$ file rename-macro help

2012-07-27 Thread karthikeyan sankaran
Hi, I have a 500 files(.pdf/.xls/.txt) in one folder.How to get .pdf files name only in excel sheet and rename desired name what i entered in other column in excel sheet. ex: old namedesired name A.pdf karthik.pdf can any help and resolve this problem.Thanks for

$$Excel-Macros$$ Excel Macro

2011-07-14 Thread karthikeyan
Hi all, How to call *Macro confirmation Dialog box* open my macro excel book in excel-2007/10. If i click *Disable macro* macro excel book should goes to close.How to do that.Pls help. Thanks -- -- Some important li

$$Excel-Macros$$ MS ACCESS

2010-12-18 Thread karthikeyan
DEAR ALL, I WOULD LIKE TO MS ACCESS THROUGH ONLINE. CAN ANY ONE SUGGEST URL SITE OR SEND PDF FILE. THANKS IN ADVANCE KARTHIK -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

$$Excel-Macros$$ MAIL MERGE HELP

2010-05-22 Thread karthikeyan
Hi all, Do the mailmerge in excel? if posible how to do explain. thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Filter Query

2010-05-01 Thread karthikeyan
Hi All, I have create a filter through macro.Crietiria=100,Filed=3 Example:- col-"A" col-"B" col-"C" NameId Amt X 1 100 Y 2 200 Z

$$Excel-Macros$$ EXCEL HELP

2010-03-07 Thread karthikeyan
HI, I HAVE 500 PERSONS NAME IN SHEET1. LIKE:-BOX BAT BALL BLACK AXE IN SHEET2 AND SELECT CELL A1 WHEN I ENTER FIRST LETTER (AVAILABLE IN SHEET1) LIKE "B" COLUMN "C" SHOWS LIST OF AVAILABLE NAMES STARTING WITH "B"-LETTER.ITS LIKE GOOGLE SEARCH

$$Excel-Macros$$ LIST OF AVAILABLE NAMES

2010-03-03 Thread karthikeyan
HI, I HAVE 500 PERSONS NAME IN SHEET1. LIKE:-BOX BAT BALL BLACK AXE IN SHEET2 AND CHOOSE CELL A1 WHEN I ENTER FIRST LETTER LIKE "B" CELL B1 SHOWS LIST OF AVAILABLE NAMES STARTING WITH "B"-STRING.ITS LIKE GOOGLE SEARCH. ANYBODY HELP ME ABOVE T

$$Excel-Macros$$ excel help

2009-12-01 Thread karthikeyan
Hi, A particular sheet in excel file doesn't allow cut/copy/paste. txs -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2.

$$Excel-Macros$$ excel certificate course

2009-11-15 Thread karthikeyan
Hi all, I am from chennai.If any body knows about online excel certificate course.Pls let me know. txs karthik -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins dow

$$Excel-Macros$$ need macro help

2009-10-31 Thread karthikeyan
hi, I put a validation in one excel worksheet .This worksheet doesn't allow paste values from any worksheet/workbook. tks karthik --~--~-~--~~~---~--~~ -- Some important links for exce

$$Excel-Macros$$ Excel Help

2009-10-25 Thread karthikeyan
HI, How can i fillter the colored cells in excel. Except 2007 Txs karthik --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Fr

$$Excel-Macros$$ Macro Help

2009-10-20 Thread karthikeyan
Hi All, Q1) - Some cells/columns/sheets doesn't allow the paste values(copy from one sheet) e.g : if i copied from one sheet to another sheet , excel show popups enter manually,don't copied form other sheet. Q2) - If I put the value in one cell then click enter , cell value automatically change

$$Excel-Macros$$ Macro Help

2009-10-18 Thread karthikeyan
Hi All, I have create a macro and sent to others these people open that particular file excel says popups 'ENABLE / DISABLE macros' they clicked DISABLE macros so macros are not working. How can i avoid this Proplem? Anybody knows let me know. thanks karthik --~--~-~--~~

$$Excel-Macros$$ EXCEL VALIDATION

2009-10-17 Thread karthikeyan
Hi All, I put a validation in one excel worksheet It's dosen't accept the data's copy from one sheet to past this sheet. e.g : copied from onther sheet and paste --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Macro Help

2009-10-11 Thread karthikeyan
Hi, I have enter E-mail id in one cell with space:e.g(karthi keyan sankar...@gmail.com). Excel automatically validate when i click enter button popup message : don't use space enter E-mail id. How to write coding.pls let me know. Thanks --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Excel Macro

2009-10-04 Thread karthikeyan
Anybody knows Excel Macro E-books? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excel

$$Excel-Macros$$ need help with excel macro

2009-10-02 Thread karthikeyan
I have put one listbox add some '.xls' file path through inputbox and store as a button in a toolbar. now want to open listindex files.e.g : listbox contains 5 '.xls'-files when am clicking file path name its opening in new workbook.can any body help me about this?. --~--~-~--~~--

$$Excel-Macros$$ Linking b/w 2 or more systems in Macro.

2009-01-06 Thread KARTHIKEYAN B
Hi, Can anybody extend ur knowledge for me. How to connect 2 or more systems using macro. Example connecting Excel and Mainframe, or Excel and Oracle, Excel and Peoplesoft etc... Also explain how to write a Macro command. Thanks Rgds/Karthik. -- Help the needy with SIMPLE and SAFE(LY)TY LIFE Ka