$$Excel-Macros$$ printing an userform in pdf format

Dear experts I am using to take a printout of an userform by using the following code in a command button: me.printform But, is there any option to take a softcopy of an unserform in a .pdf format ? regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

RE: $$Excel-Macros$$ how to convert dbf III (Dos Based Fox-pro 2.5) file to CSV file

Govind, Correction. I seem to have been mistaken. File, Open. Change the file types ("Excel Files") to "dBase Files (*.dbf)". Still an option in Excel 2010. Then Save as, change file type to CSV. If that import doesn't work as desired, you can try Data>Get External Data>From Other Sourc

Re: $$Excel-Macros$$ format a cell

Dear All,   If my input is 1215 or 12.15 converted to 12:15 of 12:15         From: Aamir Shahzad To: excel-macros@googlegroups.com Sent: Thursday, March 29, 2012 12:22 AM Subject: Re: $$Excel-Macros$$ format a cell Now see the attached file.  Aamir Shahzad

Fwd: $$Excel-Macros$$ Service Count problem

-- Forwarded message -- From: Shankar Bheema Date: Sat, Mar 24, 2012 at 11:00 AM Subject: $$Excel-Macros$$ Service Count problem To: excel-macros@googlegroups.com Dear Experts In the userform of the attached workbook contains Date of Joining text box and Date of Retirement textb

Re: $$Excel-Macros$$ checkbox query

Dear all, Sorry for asking late. I use the code from KRIS and put in SHANKAR file, however, the below error happened. Could SHANKAR please share your new file with KRIS code? Also, I found there is some output in the "Intermediate" window, could anyone provide some information/ resources on how

Re: $$Excel-Macros$$ Re: Formula for Unique Values with Condition

* * * * Hi Noorain/Haseeb, Perfect answers. This is what I was looking for... Thanks... Kiran On Thu, Mar 29, 2012 at 9:06 AM, Haseeb A wrote: > Hello Kiran, > > In G4 with CTRL+SHIFT+ENTER, rather than just ENTER > > > =IFERROR(INDEX(D$2:D$498,MATCH(1,IF(ISNA(MATCH(D$2:D$498,G$3:G3,0)),IF($C$

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Hi Noorain, Regarding the code provided from above, do the custom control button and tab include all operations too? For example, the sorting button, the operations include in the following code? I would like to learn more from this. .Caption = "Sort Names Descending" .On

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Dear Ravi, Please use =REPT("0",15-LEN(A2))&A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi < friendswrite...@gmail.com> wrote: > I have an excel file each cell may have different custom formats such a

Re: $$Excel-Macros$$ how to convert dbf III (Dos Based Fox-pro 2.5) file to CSV file

Dear Govind, Please try through below link, http://www.dbf2002.com/csv-converter/ On Wed, Mar 28, 2012 at 3:58 PM, Govind Mori wrote: > Dear Members > > I m new to this group, Please help me to easy way of converting DBF file > to CSV file > > Thanks > > Govind Mori > > > -- > FORUM RULES (986+

$$Excel-Macros$$ Re: Formula for Unique Values with Condition

Hello Kiran, In G4 with CTRL+SHIFT+ENTER, rather than just ENTER =IFERROR(INDEX(D$2:D$498,MATCH(1,IF(ISNA(MATCH(D$2:D$498,G$3:G3,0)),IF($C$2:$C$498="Agent",1)),0)),"") Then copy across & down. if you have huge list, this will slow down the sheet performance. ___ HTH, Haseeb -- FORUM

Re: $$Excel-Macros$$ Tab Strip or Multi page problem

Dear Thomp, Please share your workbook with group. On Thu, Mar 29, 2012 at 1:02 AM, Thomp wrote: > Was playing around with Tab Strip and Multi Page but on each every time I > add a check box on the tab it disappears the minute I take in out of design > mode..Anyone know what I am doing wrong he

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

Dear Divakar, Please use below code to add custom button and Tab Option Explicit 'Add a new menu to Worksheet Menu Bar Public Sub AddCustomMenu() Dim cbr As CommandBar Dim ctlMenu As CommandBarControl 'Add new menu control Set cbr = Application.CommandBars("Worksheet Menu Bar")

RE: $$Excel-Macros$$ Re: DELETE BLANK ROW AND COLUMN

Thanks a lot don From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Wednesday, March 28, 2012 6:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: DELETE BLANK ROW AND COLUMN Should do it. Don Guillett

RE: $$Excel-Macros$$ how to convert dbf III (Dos Based Fox-pro 2.5) file to CSV file

Hi Govind, At last check, MS Access (if you have it) can still import and export both DBF and CSV files. Older Excel versions (2003 and older I believe) can import/export from DBF natively. CSV is still supported. Also, free OpenOffice and LibreOffice have that capability. It should b

Re: $$Excel-Macros$$ how to convert dbf III (Dos Based Fox-pro 2.5) file to CSV file

https://www.google.com/#hl=en&sugexp=epsugrstma&gs_nf=1&tok=yQU8bSdwbrVg0d2-9kIpdg&cp=17&gs_id=25&xhr=t&q=excel:+dbf+to+csv&pf=p&output=search&sclient=psy-ab&oq=excel:+dbf+to+csv&aq=&aqi=&aql=&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=7fb1484f2d5d4b11&biw=1066&bih=670 Don Guillett M

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Do you mean values >0 such as 2 for the last example? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ravi Kumar Vandavasi Sent: Tuesday, March 27, 2012 10:39 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Reading custom format as it appears in a c

Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of object 'Range' failed

'Assumes this in DV list 'DC36U 'DC44U 'AC42U Private Sub Worksheet_Change(ByVal Target As Range) Dim DC36U As String Dim DC44U As String Dim AC42U As String '??DC36U = "Tekelec Eagle XG 870-3040-06 (DC)" '??DC44U = "Tekelec Eagle XG 870-3068-06 (DC)" '??AC42U = "Teke

Re: $$Excel-Macros$$ format a cell

what about Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, March 28, 2012 3:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ format a cell Hi All, thanks a lot for everyone, special to Aamir yes this what

Re: $$Excel-Macros$$ Test to see if cell value starts with a "D"

sub findd() dim c as range for each c in range(“a2:a22”) if ucase(left(c,1))=”D” then msgbox c next c end sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Preston Moore Sent: Wednesday, March 28, 2012 12:52 PM To: excel-macros@googlegroups.com Subject: $$Excel

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

Hi Kiran, the easiest way of doing it is pivot table (so you can manage as you want) both request attached. From the macro point of view I can't help you with, but I've got your piont sometimes you want to see it to be able to learn it. Regards, Pawel ps I couldn't send you attachment - limi

Re: $$Excel-Macros$$ format a cell

Hi All, thanks a lot for everyone, special to Aamir yes this what I was looking for THANKS a lot again. Regards, Pawel From: Aamir Shahzad To: excel-macros@googlegroups.com Sent: Wednesday, March 28, 2012 7:52 PM Subject: Re: $$Excel-Macros$$ format a cell

$$Excel-Macros$$ Test to see if cell value starts with a "D"

This a probably a simple question, but I am new to VBA... How do I test to find cells that contain text starting with the letter "D"? Thank you Pres -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thre

Re: $$Excel-Macros$$ Email Sheet with message

Hi Darwin, If you are not able to see mentioned reference " Microsoft Outlook 12.0 Object Library " in your machine, then probably you can get it by installing VB 6.0 edition in your computer. Mangesh. On Wed, Mar 28, 2012 at 3:49 PM, Jorge Marques wrote: > Talal, i´m also a beginner, i´m u

$$Excel-Macros$$ how to convert dbf III (Dos Based Fox-pro 2.5) file to CSV file

Dear Members I m new to this group, Please help me to easy way of converting DBF file to CSV file Thanks Govind Mori -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Co

$$Excel-Macros$$ Reading custom format as it appears in a cell

I have an excel file each cell may have different custom formats such as "000" or "0940101" or "0080100" etc. I would like to count number of characters in each cell. If I use len() function it retreives the length as it appears in the formula bar and not the maked c

$$Excel-Macros$$ Run-time error message: Method 'Hidden' of object 'Range' failed

Hi, I'm new to VBA and I'm posting this because I've been tearing my hair out over this all day, so I hope someone has seen this before and can point me in the right direction. I have created a worksheet change event which hides some columns according to a string that is chosen from a list in

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

congrats noorain bhai..!!Ashish Saxena (ASE) DelhiClaris Lifesciences Ltd.Mb :- 9871140113From: NOORAIN ANSARI Sent: Mon, 26 Mar 2012 23:24:39 To: excel-macros@googlegroups.comSubject: Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.** FI

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

Why not add a date column and still use autofilter. Why a formula when a macro would be so much better. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Kiran Kancherla Sent: Wednesday, March 28, 2012 2:12 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-M

$$Excel-Macros$$ Tab Strip or Multi page problem

Was playing around with Tab Strip and Multi Page but on each every time I add a check box on the tab it disappears the minute I take in out of design mode..Anyone know what I am doing wrong here thanks Bill -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate t

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

Hi Don, I totally agree. I can use auto filter or advanced filter to get the out put. This report is a daily report for me and there will be lot of additions and deletions will be there. I need a formula to get the output... Thanks, Kiran Sent on my BlackBerry® from Vodafone Thanks & Regards.

Re: $$Excel-Macros$$ Fwd:

more info on the AFTER look. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ram Sent: Wednesday, March 28, 2012 12:56 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Can you help on below. I want to convert the data in the big table bel

Re: $$Excel-Macros$$ Formula for Unique Values with Condition

Why not just use data>filter>autofilter see att Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Kiran Kancharla Sent: Wednesday, March 28, 2012 1:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula for Unique Values with Condition Hi All,

Re: $$Excel-Macros$$ format a cell

Now see the attached file. Aamir Shahzad On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD wrote: > Dear Noorain, > > I think he want 532, and I'd like to be converted to 05:32 > > > > *From:* NOORAIN ANSARI > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, March 28, 2012 7:55 A

$$Excel-Macros$$ Formula for Unique Values with Condition

Hi All, In the attached file I have names of the people who left the company. I need a formula to Extract the names of the Team Leader's and Team Manager's, where in Column "C" have Agent. I mean, I want to get only those Names, where they have attrition for "Agent" Request you to please help m

Re: $$Excel-Macros$$ REG:$$Column to table formula now working

Sir,(All forum members) Re: $$Excel-Macros$$ REG:$$Column to table formula Now working It is fine.Working well.Thank you very much for your timely help and guidence. Karunanithi R From: Sourabh Salgotra To: excel-macros@googlegroups.com Sent: Wednesday, March

$$Excel-Macros$$ Fwd:

> > Can you help on below. I want to convert > the data in the big table below in the Following > Format..Any formulas to do that? >> >> I >> >> Ozip.DestzipM >> >> 8810. 7188 33.8 >> 8816. 7188 28.07 >> > And so on > >> I want to convert below bi

Re: $$Excel-Macros$$ Difficulty referencing non active sheet but this must be possible

I found references on the losing scope issue. I think I understand what I am up agains there. I think unhandled errors the most likely cause if I hit it. I will probably only use one module for what I am doing with appropriate hierarchy of procedures so really public is not needed, but from what

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

Sir, It is happy to see the desired result. But after typing the formula I pressed with ctrl+shift+enter,I dont get the result. Is there any other procedure? Please help in detail. Thank you very much. -Karunanithi R 91-9486100934. From: Sourabh Salgotra To: e

Re: $$Excel-Macros$$ Difficulty referencing non active sheet but this must be possible

You should write a book. I agree with what you say where I understand it. In fact I am playing with references to learn but for final could would probably use fully qualified paths in places like initialization areas called once. Also not a fan of global vars usually but to save a lot of repiti

Re: $$Excel-Macros$$ vlookup with more than one value

ok thanks From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Wednesday, March 28, 2012 7:45 AM Subject: Re: $$Excel-Macros$$ vlookup with more than one value Dear Lakshman,   No problem bro..but in this case we should try to keep criteria range

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

chk this one. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a questio

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

i think u want as attachment. see attachment On Wed, Mar 28, 2012 at 4:51 PM, karunanithi ramaswamy wrote: > Sir, > the file is attached. > >*From:* dguillett1 > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, March 27, 2012 11:39 PM > *Subject:* Re: $$Excel-Macros$$ REG:$$Column to

Re: $$Excel-Macros$$ SQL Query - Excel VBA

Hi, Please see my comments in the tag [sharma]. Regards, Sharma On Sat, Mar 24, 2012 at 1:40 AM, Asa Rossoff wrote: > Hi Sharma, > > I replied two weeks ago when you posted this question with a detailed > response with tips and requesting more information if you still needed help. > >

Re: $$Excel-Macros$$ printing doubt

Thanks to Noorain Ansari, , Abhishek Jain Mothilal On Wed, Mar 28, 2012 at 11:09 AM, Abhishek Jain wrote: > Use below code for printing all sheets in a workbook - > > Option Explicit > > Sub PrintallSheets() > Dim ws As Worksheet > For Each ws In ActiveWorkbook.Worksheets > ws.PrintOut > Next w

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

Hi, For D1 Try, =ROW($A1)*3-(3-COLUMN($A1)) For H1 Try, =ROW($B1)*3-(3-COLUMN($B1)+1) Regards, MARIES. On Wed, Mar 28, 2012 at 3:21 PM, karunanithi ramaswamy wrote: > Sir, > the file is attached. > >*From:* dguillett1 > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, March 27, 2012

Re: $$Excel-Macros$$ REG:$$Column to table formula not working

Sir,  the file is attached. From: dguillett1 To: excel-macros@googlegroups.com Sent: Tuesday, March 27, 2012 11:39 PM Subject: Re: $$Excel-Macros$$ REG:$$Column to table formula not working Show us your before/after data and/or send a file with explanation

Re: $$Excel-Macros$$ Re: Match text to a list

Kris, Sorry, you are quite right. I made the mistake of copying the previous code and replacing the prvious code with the previous codes. thank you so much for your patience. On Thu, Mar 22, 2012 at 2:49 PM, Kris wrote: > That's not true. > > MATCH("A",**L6:L27,0) is not equal to MATCH("AA",

Re: $$Excel-Macros$$ Email Sheet with message

Talal, i´m also a beginner, i´m using some books, but i haven´t found any extensive one in VBA, i use recording methods to see what the code performs, and use other posts to see what it returns in the excel provided, it has helped me a lot improving my skills, i notice that i not still able to buil

Re: $$Excel-Macros$$ need help:save excel worksheet data into SQLserver using VBA code

Dear Noorain, Thanks,perfect, let's me study it. Best regards Gacia On Wed, Mar 28, 2012 at 3:00 PM, Darwin Chan wrote: > Dear Noorain, > > Really thanks for your information. I am also a newbie on DB > administration. Hope I can learn a lot from the tutorial you give. > > > 2012/3/28 NOORAIN

RE: $$Excel-Macros$$ Difficulty referencing non active sheet but this must be possible

Hi Howard, > So for cross referencing can I create a reference > Set pointer = sheets(chartvalue) then use pointer.cells(row,col) for > access since what I will be doing is reading cell values from one > sheet, performing functions on the values then setting cell values in > the other sheet. Or

FW: $$Excel-Macros$$ Macro to sort excel data & email to party

Can anyone please help me on this? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: 25 March 2012 18:33 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to sort excel data & email to party Dear Al