$$Excel-Macros$$ count if filter problem
Hi, need help on filter countif formula not showing only filtered calculation( count ) but count visible working fine here in attached file i put formula but when i put filter on pname showing all other count solution pls 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. countif filter.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Vlookup from ms access and sqlite
Hi Expert's, need help. It will great appreciated if someone can send me the macro i have data in ms access & sqlite multiple files regularly i received data in excel ms access & sqlite data received once in a month i convert access & sqlite data which data present in excel than use vlookup formula need your help to update data to excel file from ms access & sqlite Thanks in Advance V -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ need macro to generate serial no
any macro solution ? On Thu, Aug 27, 2015 at 10:18 PM, My Excel myxlg...@gmail.com wrote: Sir, need help on serial no generate (like attached file) using auto increment loop start from 1200 to better if possible 1 crore in 1 sheet 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Port VBA code to VB.net
sir, Pls share update of this thread how to convert vba to .exe thanks in advance On Thu, Oct 9, 2014 at 3:27 PM, Anil Gawli gawlianil8...@gmail.com wrote: Dear Rupesh, Pls share the file. Warm Regards, Gawli Anil. On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil patil.rupesh1...@gmail.com wrote: Hello Expert, In my organization we have developed VBA Application for doctors. now we want to create .exe file of this application so as per my knowledge we can't create .exe file of VBA application. so we need to port this code to .net. Could please assist me how to do this. -- Thanks Regards, Rupesh Patil, (9970196189), Ayushman Pvt. Ltd. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Find Color Details using search box output in form (UI editor add-in)
experts, need output in form check using vlookup in colordata.xlsx it near 500 records to search easily by seeing on cotton it vl be helpful to my friend thanks On Wed, Apr 1, 2015 at 8:35 PM, myxlg...@gmail.com wrote: Sir, need form to show result from colordata.xlsx (auto search in closed workbook) when i put colorcode in (color code.xlsm) box result will display on 1 form pls solve my friend query sir 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ multiple files to single file
Sir, when i browse not showing .csv files excel worksheet thank you On Wed, Mar 11, 2015 at 11:59 PM, Bé Trần Văn betnmtdongna...@gmail.com wrote: Try using the Merge File. See instructions in File. 2015-03-11 20:02 GMT+07:00 myxlg...@gmail.com: Sir, i need a macro to import multiple file to single file i got some files in a week later i copy those to 1 file some time not copy (some in 2003 format,some 2007,some .csv,.xlsm etc) some times files contains more than 1 sheet need help copy all those files which i save in Latest Data(this is my folder name)(all excel format == as it is data) in to new file thank you in advance -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Information
shocking news you are not from IT field not trained programming lang is it possible me also guruji ? than suggest basic vba for me pls check my url guruji thanks On Wed, Dec 3, 2014 at 12:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi There is no team buddy.. 80-90% queries are not a new, i have already answered it in past or its simple logic! Also i am not from IT field i have not obtained formal programming training.. so every new query makes me more curious to learn new thing! what all knowledge i have gained / am gaining is from open forums only..by referring books you will learn only syntax they don't teach you problem solving but by solving each query you makes your self available to new knowledge! To correct, there are many well trained programmer here on forum i have learned many things from them.. only diff is that i am replying max queries in my free time .. Thanks for question be part of forum, you will learn more out of it by participating queries.. Try to learn diff way of solving same query is key to learn new thing.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 3, 2014 at 12:42 PM, Mandeep Baluja rockerna...@gmail.com wrote: This question is for vabz, Mostly the queries answered by vaibhav Are you working with a team or you are answering the queries by yourself only ??? without getting help of someone, because you're the only efficient programmer in vba here.And I am new in this field.Can you recommend the best book for vba to me too. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from
Re: $$Excel-Macros$$ need help to convert this code into excel macro
( (MCC=$mcc MNC=$mnc LAC=$lac CID=$cid)); echo pa href='http://maps.google.com/maps?q=$addr$t' target='_top'Lat=$lat Lon=$lon/a; } ? p iframe width=425 height=350 frameborder=0 scrolling=no marginheight=0 marginwidth=0 src=http://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=?php if(isset($addr)) echo $addr; else echo '41.038526,28.985649 '?ie=UTF8ll=?php if(isset($addr)) echo $addr; else echo '41.038526,28.985649'?sll=?php if(isset($addr)) echo $addr; else echo '41.038526,28.985649'?t=hz=12output=embed/iframe pnbsp; pnbsp; p On Fri, Nov 28, 2014 at 12:09 PM, my excel myxlg...@gmail.com wrote: sir, this code from bahri in c# php something sir pls help convert it to excel macro thank you html head titleGSM LAC/CID - loc test/title /head body style type=text/css body { font-family: Verdana, Helvetica, Geneva, Arial, SunSans-Regular, sans-serif; font-size:12; } td { font-family: Verdana, Helvetica, Geneva, Arial, SunSans-Regular, sans-serif; font-size:12; } /style center table width=450 trtd /td/tr /table form method=post action=?php echo $PHP_SELF;? table tr tda href=http://en.wikipedia.org/wiki/List_of_mobile_country_codes;MCC - Mobile Country Code/a/td td input type=text size=5 name=mcc value=?php if(isset($mcc)) echo $mcc; else echo 286?br / /td tr tda href=http://en.wikipedia.org/wiki/Mobile_Network_Code;MNC - Mobile Network Code/a/td td input type=text size=5 name=mnc value=?php if(isset($mnc)) echo $mnc; else echo 01?br / /td tr tdLAC - Location Area Code/td td input type=text size=5 name=lac value=?php if(isset($lac)) echo $lac; else echo 21534?br / /td /tr tdCID - Cell ID/td td input type=text size=5 name=cid value=?php if(isset($cid)) echo $cid; else echo 271?br / /td /tr tr td colspan=2centerinput type=Submit value=Check it/center/td /tr /table /form ?php if (isset($lac) isset($cid) isset($mnc) isset($mcc)) { $data = \x00\x0e. \x00\x00\x00\x00\x00\x00\x00\x00. \x00\x00. \x00\x00. \x00\x00. \x1b. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \xff\xff\xff\xff. \x00\x00\x00\x00; $is_umts_cell = ($cid 65535); if ($is_umts_cell) // GSM: 4 hex digits, UTMS: 6 hex digits $data[0x1c] = 5; else $data[0x1c] = 3; $hexmcc = substr(.dechex($_REQUEST[mcc]),-8); $hexmnc = substr(.dechex($_REQUEST[mnc]),-8); $hexlac = substr(.dechex($_REQUEST[lac]),-8); $hexcid = substr(.dechex($_REQUEST[cid]),-8); echo pMCC=$hexmcc MNC=$hexmnc LAC=$hexlac CID=$hexcid; $data[0x11] = pack(H*,substr($hexmnc,0,2)); $data[0x12] = pack(H*,substr($hexmnc,2,2)); $data[0x13] = pack(H*,substr($hexmnc,4,2)); $data[0x14] = pack(H*,substr($hexmnc,6,2)); $data[0x15] = pack(H*,substr($hexmcc,0,2)); $data[0x16] = pack(H*,substr($hexmcc,2,2)); $data[0x17] = pack(H*,substr($hexmcc,4,2)); $data[0x18] = pack(H*,substr($hexmcc,6,2)); $data[0x27] = pack(H*,substr($hexmnc,0,2)); $data[0x28] = pack(H*,substr($hexmnc,2,2)); $data[0x29] = pack(H*,substr($hexmnc,4,2)); $data[0x2a] = pack(H*,substr($hexmnc,6,2)); $data[0x2b] = pack(H*,substr($hexmcc,0,2)); $data[0x2c] = pack(H*,substr($hexmcc,2,2)); $data[0x2d] = pack(H*,substr($hexmcc,4,2)); $data[0x2e] = pack(H*,substr($hexmcc,6,2)); $data[0x1f] = pack(H*,substr($hexcid,0,2)); $data[0x20] = pack(H*,substr($hexcid,2,2)); $data[0x21] = pack(H*,substr($hexcid,4,2)); $data[0x22] = pack(H*,substr($hexcid,6,2)); $data[0x23] = pack(H*,substr($hexlac,0,2)); $data[0x24] = pack(H*,substr($hexlac,2,2)); $data[0x25] = pack(H*,substr($hexlac,4,2)); $data[0x26] = pack(H*,substr($hexlac,6,2)); /* I used file_get_contents() at my laptop webserver, but it seems like the PHP version * at my hosting company is old and it is not supporting that. * For the hosting company, here we're using cURL. */ $use_curl = true; if ($use_curl) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, http://www.google.com/glm/mmap;); curl_setopt($ch, CURLOPT_HEADER, true); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1); curl_setopt($ch, CURLOPT_HTTPHEADER, Array(Content-type: application/binary)); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); curl_setopt($ch, CURLOPT_POST, 1); $response = curl_exec($ch); if (curl_errno($ch)) exit(Error: Failed to post data $str curl_errno($ch)); $header_size = curl_getinfo($ch, CURLINFO_HEADER_SIZE); $str = substr($response, $header_size); curl_close($ch); } else { $context = array ( 'http' = array ( 'method' = 'POST', 'header'= Content-type: application/binary\r\n . Content-Length: . strlen($data) . \r\n, 'content' = $data
Re: $$Excel-Macros$$ need help to convert this code into excel macro
])); if (ret_code == 0) { double lat = ((double)((ps[7] 24) | (ps[8] 16) | (ps[9] 8) | (ps[10]))) / 100; double lon = ((double)((ps[11] 24) | (ps[12] 16) | (ps[13] 8) | (ps[14]))) / 100; Console.WriteLine(Latitude: {0}, Longitude: {1}, lat, lon); Process p = new Process(); p.StartInfo.FileName = iexplore; Console.WriteLine(\nClose map window to exit\n); p.StartInfo.Arguments = String.Format( http://maps.google.de/maps?f=qhl=deq={0},{1}ie=UTF8z=15;, lat.ToString().Replace(',','.'), lon.ToString().Replace(',','.')); p.Start(); p.WaitForExit(); } else Console.WriteLine(Error {0}, ret_code); } else Console.WriteLine(HTTP Status {0} {1}, res.StatusCode, res.StatusDescription); } catch (Exception) { throw; } } } } On Mon, Dec 1, 2014 at 7:43 PM, Vaibhav Joshi v...@vabs.in wrote: Hi pl share us code in proper html file format instead of this code.. + *I did not do this for you. God is here working through me for you.* On Mon, Dec 1, 2014 at 1:36 PM, my excel myxlg...@gmail.com wrote: hi experts pls convert to vba macro mmc input text box mnc input text box lac input text box cid input text box button below code table width=450 trtd /td/tr /table form method=post action=?php echo $PHP_SELF;? table tr tda href=http://en.wikipedia.org/wiki/List_of_mobile_country_codes;MCC - Mobile Country Code/a/td td input type=text size=5 name=mcc value=?php if(isset($mcc)) echo $mcc; else echo 286?br / /td tr tda href=http://en.wikipedia.org/wiki/Mobile_Network_Code;MNC - Mobile Network Code/a/td td input type=text size=5 name=mnc value=?php if(isset($mnc)) echo $mnc; else echo 01?br / /td tr tdLAC - Location Area Code/td td input type=text size=5 name=lac value=?php if(isset($lac)) echo $lac; else echo 21534?br / /td /tr tdCID - Cell ID/td td input type=text size=5 name=cid value=?php if(isset($cid)) echo $cid; else echo 271?br / /td /tr tr td colspan=2centerinput type=Submit value=Check it/center/td /tr /table /form ?php if (isset($lac) isset($cid) isset($mnc) isset($mcc)) { $data = \x00\x0e. \x00\x00\x00\x00\x00\x00\x00\x00. \x00\x00. \x00\x00. \x00\x00. \x1b. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \xff\xff\xff\xff. \x00\x00\x00\x00; $is_umts_cell = ($cid 65535); if ($is_umts_cell) // GSM: 4 hex digits, UTMS: 6 hex digits $data[0x1c] = 5; else $data[0x1c] = 3; $hexmcc = substr(.dechex($_REQUEST[mcc]),-8); $hexmnc = substr(.dechex($_REQUEST[mnc]),-8); $hexlac = substr(.dechex($_REQUEST[lac]),-8); $hexcid = substr(.dechex($_REQUEST[cid]),-8); echo pMCC=$hexmcc MNC=$hexmnc LAC=$hexlac CID=$hexcid; $data[0x11] = pack(H*,substr($hexmnc,0,2)); $data[0x12] = pack(H*,substr($hexmnc,2,2)); $data[0x13] = pack(H*,substr($hexmnc,4,2)); $data[0x14] = pack(H*,substr($hexmnc,6,2)); $data[0x15] = pack(H*,substr($hexmcc,0,2)); $data[0x16] = pack(H*,substr($hexmcc,2,2)); $data[0x17] = pack(H*,substr($hexmcc,4,2)); $data[0x18] = pack(H*,substr($hexmcc,6,2)); $data[0x27] = pack(H*,substr($hexmnc,0,2)); $data[0x28] = pack(H*,substr($hexmnc,2,2)); $data[0x29] = pack(H*,substr($hexmnc,4,2)); $data[0x2a] = pack(H*,substr($hexmnc,6,2)); $data[0x2b] = pack(H*,substr($hexmcc,0,2)); $data[0x2c] = pack(H*,substr($hexmcc,2,2)); $data[0x2d] = pack(H*,substr($hexmcc,4,2)); $data[0x2e] = pack(H*,substr($hexmcc,6,2)); $data[0x1f] = pack(H*,substr($hexcid,0,2)); $data[0x20] = pack(H*,substr($hexcid,2,2)); $data[0x21] = pack(H*,substr($hexcid,4,2)); $data[0x22] = pack(H*,substr($hexcid,6,2)); $data[0x23] = pack(H*,substr($hexlac,0,2)); $data[0x24] = pack(H*,substr($hexlac,2,2)); $data[0x25] = pack(H*,substr($hexlac,4,2)); $data[0x26] = pack(H*,substr($hexlac,6,2)); /* I used file_get_contents() at my laptop webserver, but it seems like the PHP version * at my hosting company is old and it is not supporting that. * For the hosting company, here we're using cURL. */ $use_curl = true; if ($use_curl) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, http://www.google.com/glm/mmap;); curl_setopt($ch, CURLOPT_HEADER, true); curl_setopt($ch
$$Excel-Macros$$ need help to convert this code into excel macro
sir, this code from bahri in c# php something sir pls help convert it to excel macro thank you html head titleGSM LAC/CID - loc test/title /head body style type=text/css body { font-family: Verdana, Helvetica, Geneva, Arial, SunSans-Regular, sans-serif; font-size:12; } td { font-family: Verdana, Helvetica, Geneva, Arial, SunSans-Regular, sans-serif; font-size:12; } /style center table width=450 trtd /td/tr /table form method=post action=?php echo $PHP_SELF;? table tr tda href=http://en.wikipedia.org/wiki/List_of_mobile_country_codes;MCC - Mobile Country Code/a/td td input type=text size=5 name=mcc value=?php if(isset($mcc)) echo $mcc; else echo 286?br / /td tr tda href=http://en.wikipedia.org/wiki/Mobile_Network_Code;MNC - Mobile Network Code/a/td td input type=text size=5 name=mnc value=?php if(isset($mnc)) echo $mnc; else echo 01?br / /td tr tdLAC - Location Area Code/td td input type=text size=5 name=lac value=?php if(isset($lac)) echo $lac; else echo 21534?br / /td /tr tdCID - Cell ID/td td input type=text size=5 name=cid value=?php if(isset($cid)) echo $cid; else echo 271?br / /td /tr tr td colspan=2centerinput type=Submit value=Check it/center/td /tr /table /form ?php if (isset($lac) isset($cid) isset($mnc) isset($mcc)) { $data = \x00\x0e. \x00\x00\x00\x00\x00\x00\x00\x00. \x00\x00. \x00\x00. \x00\x00. \x1b. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \x00\x00\x00\x00. \xff\xff\xff\xff. \x00\x00\x00\x00; $is_umts_cell = ($cid 65535); if ($is_umts_cell) // GSM: 4 hex digits, UTMS: 6 hex digits $data[0x1c] = 5; else $data[0x1c] = 3; $hexmcc = substr(.dechex($_REQUEST[mcc]),-8); $hexmnc = substr(.dechex($_REQUEST[mnc]),-8); $hexlac = substr(.dechex($_REQUEST[lac]),-8); $hexcid = substr(.dechex($_REQUEST[cid]),-8); echo pMCC=$hexmcc MNC=$hexmnc LAC=$hexlac CID=$hexcid; $data[0x11] = pack(H*,substr($hexmnc,0,2)); $data[0x12] = pack(H*,substr($hexmnc,2,2)); $data[0x13] = pack(H*,substr($hexmnc,4,2)); $data[0x14] = pack(H*,substr($hexmnc,6,2)); $data[0x15] = pack(H*,substr($hexmcc,0,2)); $data[0x16] = pack(H*,substr($hexmcc,2,2)); $data[0x17] = pack(H*,substr($hexmcc,4,2)); $data[0x18] = pack(H*,substr($hexmcc,6,2)); $data[0x27] = pack(H*,substr($hexmnc,0,2)); $data[0x28] = pack(H*,substr($hexmnc,2,2)); $data[0x29] = pack(H*,substr($hexmnc,4,2)); $data[0x2a] = pack(H*,substr($hexmnc,6,2)); $data[0x2b] = pack(H*,substr($hexmcc,0,2)); $data[0x2c] = pack(H*,substr($hexmcc,2,2)); $data[0x2d] = pack(H*,substr($hexmcc,4,2)); $data[0x2e] = pack(H*,substr($hexmcc,6,2)); $data[0x1f] = pack(H*,substr($hexcid,0,2)); $data[0x20] = pack(H*,substr($hexcid,2,2)); $data[0x21] = pack(H*,substr($hexcid,4,2)); $data[0x22] = pack(H*,substr($hexcid,6,2)); $data[0x23] = pack(H*,substr($hexlac,0,2)); $data[0x24] = pack(H*,substr($hexlac,2,2)); $data[0x25] = pack(H*,substr($hexlac,4,2)); $data[0x26] = pack(H*,substr($hexlac,6,2)); /* I used file_get_contents() at my laptop webserver, but it seems like the PHP version * at my hosting company is old and it is not supporting that. * For the hosting company, here we're using cURL. */ $use_curl = true; if ($use_curl) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, http://www.google.com/glm/mmap;); curl_setopt($ch, CURLOPT_HEADER, true); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1); curl_setopt($ch, CURLOPT_HTTPHEADER, Array(Content-type: application/binary)); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); curl_setopt($ch, CURLOPT_POST, 1); $response = curl_exec($ch); if (curl_errno($ch)) exit(Error: Failed to post data $str curl_errno($ch)); $header_size = curl_getinfo($ch, CURLINFO_HEADER_SIZE); $str = substr($response, $header_size); curl_close($ch); } else { $context = array ( 'http' = array ( 'method' = 'POST', 'header'= Content-type: application/binary\r\n . Content-Length: . strlen($data) . \r\n, 'content' = $data ) ); $xcontext = stream_context_create($context); $str=file_get_contents(http://www.google.com/glm/mmap;, FALSE, $xcontext); } $opcode1 = ((ord($str[0]) 8)) | ord($str[1]); $opcode2 = ord($str[2]); if (($opcode1 != 0x0e) || ($opcode2 != 0x1b)) exit(pError: Invalid opcode $opcode1 $opcode2. Maybe the LAC/CID is invalid); $retcode = ((ord($str[3]) 24) | (ord($str[4]) 16) | (ord($str[5]) 8) | (ord($str[6]))); if ($retcode != 0) exit(pError: Invalid return code $retcode. Maybe the LAC/CID is invalid); $lat = ((ord($str[7]) 24) | (ord($str[8]) 16) | (ord($str[9]) 8) | (ord($str[10]))) / 100; $lon = ((ord($str[11]) 24) | (ord($str[12]) 16) | (ord($str[13]) 8) | (ord($str[14]))) / 100; // exit script if cannot geocode cell
Re: $$Excel-Macros$$ Userform - Login
Guru Vaibhav Sir, is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- PramodSingh -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group
Re: $$Excel-Macros$$ Userform - Login
thanks for replying i named this mail id as myxlguru bcoz whatever i posted question in this group i got exact correct answer who send solution to me i called him as guru (master) vaibhav sir, ashish sir, paul sir etc all are masters master thanks On Mon, Nov 3, 2014 at 8:08 PM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am not sure who this is myxlg...@gmail.com. Please use a different mail to solve your queries, as it may confuse me to look for an appropriate answer and ask question to the experts. On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- PramodSingh -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post
Re: $$Excel-Macros$$ Userform - Login
Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- PramodSingh -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
$$Excel-Macros$$ If Condition Problem
Sir, i created an add-in for my excel work but i am trying to write a condition it will only run in Computer Name= PCEARTH otherwise sub programs will be disabled automatically or not working thanks Sub CompName() Dim tSName As String Dim ThisComputerName As String ThisComputerName = Environ(computername) tSName = ThisComputerName ActiveSheet.Range(S2).Value = ThisComputerName If (ActiveSheet.Range(S2).Value = PCEARTH) Then ActiveSheet.Range(S1).Value =INDIA Else MsgBox (Sorry You are Not a Authorised User) ' below sub programs must be disabled sub PerInfo(ByVal Control As IRibbonControl) sub Edu(ByVal Control As IRibbonControl) sub Service(ByVal Control As IRibbonControl) End If End Sub -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ If Condition Problem
thanks a lot sir On Mon, Sep 22, 2014 at 3:41 AM, Vaibhav Joshi v...@vabs.in wrote: Hi Use this code: Sub CompName() Dim ThisComputerName As String Dim myAddIn As AddIn If UCase(Environ(computername)) = PCEARTH Then ActiveSheet.Range(S1).Value = INDIA Else MsgBox (Sorry You are Not a Authorised User) ' below sub programs must be disabled For Each myAddIn In AddIns Debug.Print myAddIn.Name If myAddIn.Name = MYADDIN_NAME1.xlam _ Or myAddIn.Name = MYADDIN_NAME2.xlam _ Or myAddIn.Name = MYADDIN_NAME2.xla _ Then myAddIn.Installed = False End If Next End If End Sub here MYADDIN_NAME1.xlam is name of your adding file, replace with your adding file name delete additional file name. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 22, 2014 at 2:56 PM, my excel myxlg...@gmail.com wrote: Sir, i created an add-in for my excel work but i am trying to write a condition it will only run in Computer Name= PCEARTH otherwise sub programs will be disabled automatically or not working thanks Sub CompName() Dim tSName As String Dim ThisComputerName As String ThisComputerName = Environ(computername) tSName = ThisComputerName ActiveSheet.Range(S2).Value = ThisComputerName If (ActiveSheet.Range(S2).Value = PCEARTH) Then ActiveSheet.Range(S1).Value =INDIA Else MsgBox (Sorry You are Not a Authorised User) ' below sub programs must be disabled sub PerInfo(ByVal Control As IRibbonControl) sub Edu(ByVal Control As IRibbonControl) sub Service(ByVal Control As IRibbonControl) End If End Sub -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data
$$Excel-Macros$$ Folder data to wbk
Sir, i need on copy data from a folder. daily i receive 4-5 excel file email from my friends i download that file in to a folder on sunday i copied all files in to 1 file sir need a macro button to copy of all that files in to single workbook without any data change using (open dialog window choose that particular folder) ex: folder name = 6sept14 files : arun6, ravi6,raju6,kulkarni6, arun15,ravi15,raju16,kulkarni16,arun30, ravi30,raju30,kulkarni30 etc 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Folder data to wbk
Sir, copy all data from folder into 1 workbook sheet wise choose any folder containing excel file open new work book run macro that macro it vl copy 1 file sheet to sheet1 than next to sheet2 so on thanks On Sat, Sep 6, 2014 at 1:35 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi, you want to copy all data from folder into 1 Sheet. (Header Wise) Explain more your query. Regards Ashish -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Folder data to wbk
Ultimate Sir thanks a lot sir On Sat, Sep 6, 2014 at 7:57 PM, Vaibhav Joshi v...@vabs.in wrote: cheers bro!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 6, 2014 at 7:53 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, Its Classic, Superb!! Regards Ashish -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ CCare Log Mgnt Sys
Hi, possible to show like heat map chart not like attached file opinion : not possible to all pivot (double click data) show surrounding to that toll free no Vibhav Brother did good work thanks to him Tnx to all On Thu, Aug 28, 2014 at 3:55 PM, Vaibhav Joshi v...@vabs.in wrote: Check this one... Cheers!! On Thu, Aug 28, 2014 at 3:29 PM, Vaibhav Joshi v...@vabs.in wrote: Check this... Cheers!! On Thu, Aug 28, 2014 at 1:46 PM, veeru h veeresh2...@gmail.com wrote: Sir, i tested this attached sample data its not showing correctly pls combine all macro in to one ThanQ On Thu, Aug 28, 2014 at 1:02 PM, Vaibhav Joshi v...@vabs.in wrote: Try this, its dynamic with any data size. Cheers!! On Sun, Aug 24, 2014 at 11:24 AM, veeru h veeresh2...@gmail.com wrote: Hi, I need a help. i am doing my brother small project i completed basic work for that file. yesterday he said, he want another option for that file. pls see I attached excel file named TestData it contains CCareLog worksheet using that sample data he want result like = Result ChartWithPivot type chart 1 or chart 2 (first preference is chart 2 )I need a macro for that, means center one icon text box show180 (A Column) if click opp icon show that pivot details ex: 1234567890 (3 times he called CCare) There is a Excel attached = ChartModel which my brother saw. Please help me in this, thanks in advance. Veeru. ~♥FRIENDS FOREVER♥~ -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to
Re: $$Excel-Macros$$ make 10 digit data
is any solution from expert? On Tue, Aug 5, 2014 at 12:52 PM, my excel myxlg...@gmail.com wrote: just copy paste data to excel if i select A column data hit on button A column data convert in to 10 digit no... i want data as text also convert in to number it must be 10 digit mobile no remove 91 remove 0 using = right 10 want in macro button On Mon, Aug 4, 2014 at 2:03 PM, Vaibhav Joshi v...@vabs.in wrote: hi you can do it without macro by changing cell format to number format. Cheers!! On Sun, Aug 3, 2014 at 9:36 PM, my excel myxlg...@gmail.com wrote: Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430 94949494949 [image: Inline image 1] Q: how to convert to 10 digit mobile no ? i used =right ( but some in text format pls make useful macro 4 me selecting A column i can make it 10 digit, by selecting B column i can make it 10 digit, selecting Z column i can make it 10 digit thanks in advance -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ make 10 digit data
thank you On Thu, Aug 7, 2014 at 10:00 AM, Vaibhav Joshi v...@vabs.in wrote: check this file.. press Alt + F8 to run macro Cheers!! On Wed, Aug 6, 2014 at 5:31 PM, my excel myxlg...@gmail.com wrote: is any solution from expert? On Tue, Aug 5, 2014 at 12:52 PM, my excel myxlg...@gmail.com wrote: just copy paste data to excel if i select A column data hit on button A column data convert in to 10 digit no... i want data as text also convert in to number it must be 10 digit mobile no remove 91 remove 0 using = right 10 want in macro button On Mon, Aug 4, 2014 at 2:03 PM, Vaibhav Joshi v...@vabs.in wrote: hi you can do it without macro by changing cell format to number format. Cheers!! On Sun, Aug 3, 2014 at 9:36 PM, my excel myxlg...@gmail.com wrote: Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430 94949494949 [image: Inline image 1] Q: how to convert to 10 digit mobile no ? i used =right ( but some in text format pls make useful macro 4 me selecting A column i can make it 10 digit, by selecting B column i can make it 10 digit, selecting Z column i can make it 10 digit thanks in advance -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http
Re: $$Excel-Macros$$ make 10 digit data
just copy paste data to excel if i select A column data hit on button A column data convert in to 10 digit no... i want data as text also convert in to number it must be 10 digit mobile no remove 91 remove 0 using = right 10 want in macro button On Mon, Aug 4, 2014 at 2:03 PM, Vaibhav Joshi v...@vabs.in wrote: hi you can do it without macro by changing cell format to number format. Cheers!! On Sun, Aug 3, 2014 at 9:36 PM, my excel myxlg...@gmail.com wrote: Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430 94949494949 [image: Inline image 1] Q: how to convert to 10 digit mobile no ? i used =right ( but some in text format pls make useful macro 4 me selecting A column i can make it 10 digit, by selecting B column i can make it 10 digit, selecting Z column i can make it 10 digit thanks in advance -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ make 10 digit data
Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430 94949494949 [image: Inline image 1] Q: how to convert to 10 digit mobile no ? i used =right ( but some in text format pls make useful macro 4 me selecting A column i can make it 10 digit, by selecting B column i can make it 10 digit, selecting Z column i can make it 10 digit thanks in advance -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Fwd: R Shop Data
thanks a lot guruji On Fri, Jul 18, 2014 at 9:12 PM, Vaibhav Joshi v...@vabs.in wrote: PFA excel with vba Macro!! Its more dynamic, click blue button new sheet will get created. Cheers!! On Fri, Jul 18, 2014 at 10:30 AM, my excel myxlg...@gmail.com wrote: Sir, i sent attached file of my friend ration shop pls see out put data he wanted a macro to generate output data pls help regards: Veerendra -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ macro
Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi v...@vabs.in wrote: Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call Macro3 End Sub On Sat, Jul 19, 2014 at 6:41 PM, daya p princedaya2...@gmail.com wrote: Sir, i created 3 macro i want run all 3 macro at a time means macro1,macro2,macro3 macro1 for sheet2 report macro2 for sheet3 report macro3 for sheet4 report pls suggest with example sir thanks sir, Daya -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ macro
thanks daya brother On Sat, Jul 19, 2014 at 9:46 PM, my excel myxlg...@gmail.com wrote: Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi v...@vabs.in wrote: Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call Macro3 End Sub On Sat, Jul 19, 2014 at 6:41 PM, daya p princedaya2...@gmail.com wrote: Sir, i created 3 macro i want run all 3 macro at a time means macro1,macro2,macro3 macro1 for sheet2 report macro2 for sheet3 report macro3 for sheet4 report pls suggest with example sir thanks sir, Daya -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Fwd: R Shop Data
Sir, i sent attached file of my friend ration shop pls see out put data he wanted a macro to generate output data pls help regards: Veerendra -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. RationShop.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ my vba macro file
Sir, i created a vba project file (macr0) someone (friend) put unknown password for it (fun) how can i recover it contains imp data i need urgentely thanks, Veer -- 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. 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.