tag:blogger.com,1999:blog-40254501978593081932024-03-12T21:32:22.923-07:00Ramneek Sharma - VB From Technical View MCTS, MCPD, MCT, IBM SQA,Green Belt Six Sigma.Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.comBlogger212125tag:blogger.com,1999:blog-4025450197859308193.post-25965909125201375542017-10-06T13:15:00.000-07:002017-10-06T13:15:40.891-07:00Mobile app to control your bots<div dir="ltr" style="text-align: left;" trbidi="on">
No body realised that how android application can control and lead your system bots.<br />
<br />
Launching bot controler 2.6 which is an open source and connects with almost all automation tools in few clicks. Now manage ur bots from cell phones.<br />
<br />
Register to get pre launching download link..<br />
<br />
Ramneek</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com1tag:blogger.com,1999:blog-4025450197859308193.post-17608258001316449112017-05-27T06:22:00.000-07:002017-05-27T06:22:23.515-07:00Difference Between Citirx and Desktop Autmation in RPA<div dir="ltr" style="text-align: left;" trbidi="on">
Yes if its citrix platform the all the elements are image.<br />
* Best way to handle citrix automation is by sending keystrokes.<br />
* Mouse clicks is the biggest bot failure reason as it fails when system changes or x and y position of the elements are changed.</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-48616618533588013222017-05-27T06:18:00.001-07:002017-05-27T06:18:19.664-07:00AI Tool with RPA<div dir="ltr" style="text-align: left;" trbidi="on">
Best tool could be <span style="background-color: white; font-family: arial, sans-serif; font-size: x-small;">NumPy as this based on python. Which is supported by almost every system.</span></div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com1tag:blogger.com,1999:blog-4025450197859308193.post-29958789799932499292017-05-27T05:58:00.002-07:002017-05-27T05:58:33.527-07:00Automation is an Art<div dir="ltr" style="text-align: left;" trbidi="on">
People may think or ask what languages do you know to do automation.<br />
I believe automation is an art. If you'r logic's are clear then no automation is impossible. <br />
</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-3389842994808674292017-05-27T05:43:00.003-07:002017-05-27T05:45:31.241-07:00RPA POC Duration<div dir="ltr" style="text-align: left;" trbidi="on">
RPA or any POC duration should not be more than 3 - 5 minutes. It's an capability of your skills and tool that you demonstrate while presenting it to your customer. POC's should be short precise with text and audio which will help the customer to understand and evaluate your skills. Even your workflows and Diagrams are ready but it's good to have POC for your ready products.<br />
<br />
* Remember live workflows or demonstration may fail due to different system environments ex Webex meetings or VC's. An video presentation (POC's) are your side jacks.<br />
</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-33954140774129889872017-05-24T03:23:00.004-07:002017-05-24T03:24:39.085-07:00When Bots are crashed? Dev should know...<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<div style="text-align: justify;">
<b><u>When Bots are crashed? Dev should know...</u></b><o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
Today let's talk something interesting about Bot
configuration. What could be the dead ends where a working bot may start
behaving incoherent? There are many technical aspects at activity level where
Robo fails due to configuration setup/exception handling and overburden or over
processing. Few points will help us to understand some errors and technical
solutions. <o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
1) Consider the process
where bot will read the image and identify the background color to perform certain
action based on that color. Ex IF Red then.....execute... Else..... Exit...
There are many activities in RPA tools to read the background attribute of the
image and get the background color. However in most of the cases developers
will face challenge to configure it as this will not solve the equation for
you. Whenever bot will reach in this IF ELSE box it interprets Black Color by
default and gets confused between screen resolution. Especially in case of citrix.</div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
<div style="text-align: justify;">
How to do it: - Configure the try catch block and capture
the image from the middle to get the true color and pixels then plot the IF block. In "Else IF" block
record the image edges just to ensure Robo checks the edges in case of failure.
Populate the "Final" block to exit from the condition.<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
2) Complex process
requires very logical framework layer in configuration of the Bots. Take an
example of the process where for every input or data gathering from multiple systems.
Developers declared variables to store the information based on scope and then forward
it to different platforms. UN doubly this Robo will crash due to overburden of
memory utilization. "More you declare variables turns low on processing
for bots, Remember Bots working at front end are more impacted as no background
threads or commands initiated". <o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
How to do it: - Access clipboard storage and instead of
declaring # of variables store the information in relevant databases.<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
3) Very simple process can be automated by using RPA
recorders and activity learners. Now let's consider the example where user has
to <o:p></o:p></div>
</div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
<div style="text-align: justify;">
Logon to some website and copy paste the data into excel.
What do you think “Developer should use the recorder to do it or build the Sequence
code. Recording actions are more prone to failures and also increases slowness
in the applications.<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
How to do it: - Configure sequences and use hot keys not
recording.</div>
<div style="text-align: justify;">
<br /></div>
<o:p></o:p></div>
<div class="MsoNormal">
<div style="text-align: justify;">
4) Robos doing data manipulation and conversion makes bot
processing very slow and turns into crash landing. Bot's working at front End goes very low on processing if it has to deal with huge
amount of data. Example of the process where thousands of records needs to be Checked and validated in the excel sheet. Configuration of
such bots is very easy but dawdling.</div>
</div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
<div style="text-align: justify;">
How to do it: - Configure the bot at the back end with action
scripts.<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
5) Using mouse clicks and cursor movements makes the Bot
into nowhere situation as and when system changes or x and y position of the
object.<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
How to do it: - Configure Robo using keyboard events/sending
keys/Tabs<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
6) Never use ALT + TAB to switch between the applications.
This will halt the Robo execution.<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
7) Use * symbol for image recognition and title
representation<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
8) Before running OCR on pdf's identify field names and
parse it on OCR tool using action scripts. This increase the accuracy of the
output.<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
9) Run bots from command center and send input data at
runtime to all respective bots<o:p></o:p></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<br /></div>
</div>
<div style="text-align: justify;">
<br /></div>
<div class="MsoNormal">
<div style="text-align: justify;">
10) Don’t forget to show exit points in configuration. Very
important to get back into exit mode after processing<o:p></o:p></div>
</div>
</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com1tag:blogger.com,1999:blog-4025450197859308193.post-65583857384825981212016-03-30T05:39:00.001-07:002016-03-30T05:39:08.368-07:00Virtual Keys - Control/ Capture Keyborad and Mouse to complete your tasks <div dir="ltr" style="text-align: left;" trbidi="on">
Sub Virtual_Keys()<br />
' To run this example please open word and ensure the title of the word file is Document1 - Microsoft Word. If not please update the title in the below AppActivate code<br />' This example will type your Name in word document and would automatically populate save and send feature.<br />' Good examples for beginers<br />
<br />
AppActivate "Document1 - Microsoft Word"<br />
Application.Wait (Now + TimeValue("00:00:02"))<br />
Application.SendKeys ("Hello" & " " & Application.UserName)<br />
Application.SendKeys ("%{f}{d}") ' Virtual Keys % = ALT & FDA = Save and Send as attcahment<br />
Application.SendKeys ("{a}")<br />
<br />
End Sub</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-39365061478963483692016-03-30T05:08:00.003-07:002016-03-30T05:08:58.936-07:00Auto Kill Files and then empty Folder after specified timeline <div dir="ltr" style="text-align: left;" trbidi="on">
Sub Autokill_Files_Folders()<br />
On Error Resume Next<br />
Application.Wait (Now + TimeValue("00:00:05"))<br />Kill "D:\Users\Ramneeks\Desktop\Sample Folder\New folder\*" ' Deletes Files<br />
Application.Wait (Now + TimeValue("00:00:01"))<br />
RmDir "D:\Users\Ramneeks\Desktop\Sample Folder\New folder" ' Delete empty folder<br />
End Sub<br />
</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-91869273395317322382016-03-30T05:05:00.000-07:002016-03-30T05:05:48.908-07:00Auto Kill or Delete files within specified timeline <div dir="ltr" style="text-align: left;" trbidi="on">
Sub autokill_Files()<br />
On Error Resume Next ' To skip any error<br />
Application.Wait (Now + TimeValue("00:00:05")) ' Time can be changed <br />Kill "D:\Users\Ramneek sharma\Desktop\Sample Folder\*" ' Set the path as required<br />
End Sub</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-45624921605119761562016-03-30T04:29:00.001-07:002016-03-30T04:29:26.537-07:00Shell Commands to delete Internet Files <div dir="ltr" style="text-align: left;" trbidi="on">
Shell "RunDll32.exe InetCpl.cpl, ClearMyTracksByProcess 4" ' Delete Temp internet Files<br />Shell "RunDll32.exe InetCpl.cpl, ClearMyTracksByProcess 16" ' Delete Froms Data<br />Shell "RunDll32.exe InetCpl.cpl, ClearMyTracksByProcess 32" ' Delete Password<br />Shell "RunDll32.exe InetCpl.cpl, ClearMyTracksByProcess 1" ' Delete History<br />Shell "RunDll32.exe InetCpl.cpl, ClearMyTracksByProcess 2" ' Delete Cookies</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-29375662158369826952016-02-29T05:16:00.001-08:002016-02-29T05:16:06.906-08:00Simple formula to split First and Last Name<div dir="ltr" style="text-align: left;" trbidi="on">
First Name<br />
<br />
=LEFT(A1,(FIND(" ",A1,1)-1))<br />
<br />
Last Name<br />
<br />
=RIGHT(A1,(FIND(" ",A1,1)-1))</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-51839616919723882002016-01-28T05:54:00.000-08:002016-01-28T05:54:20.302-08:00Which reference is required to connect VBA with internet explorer.<div dir="ltr" style="text-align: left;" trbidi="on">
Microsoft Internet Controls refrence is required. </div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-2053798154603516892016-01-19T05:47:00.002-08:002016-01-19T05:47:37.321-08:00Simple way to check Negative or Positive Number<div dir="ltr" style="text-align: left;" trbidi="on">
=IF(SIGN(A1) = -1,"Negative","Positive")<br />
<br />
<br />
OR <br />
<br />
<br />
=IF(LEFT(A1,1)="-","Negative","Positive")</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-70078400326180092402015-12-22T07:38:00.001-08:002015-12-22T07:38:09.962-08:00Convert Gigahertz to Clock Cycles per Second<div dir="ltr" style="text-align: left;" trbidi="on">
=A1 * POWER(10,9)<br />
<br />
<br />
1 Gigahertz = 10<sup><span style="font-size: xx-small;">9</span></sup> </div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-44352385597764686252015-12-17T06:10:00.000-08:002015-12-17T06:10:04.867-08:00Macro to interchange (+) positive to (-) negative and vice-versa <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Sub change()<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<o:p><span style="font-family: Calibri;"> </span></o:p></div>
<span style="font-family: Calibri;">On Error Resume Next<o:p></o:p></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<o:p><span style="font-family: Calibri;"> </span></o:p><span style="font-family: Calibri;">For Each cell In Range("E1:e20")<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">If Not cell.Value Like "-" & "*"
Then<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">cell.Value = "-" & cell.Value<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Else<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">cell.Value = Abs(cell.Value)<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">End If<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">Next cell<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-family: Calibri;">End Sub<o:p></o:p></span></div>
</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-40854334797945854882015-11-27T04:05:00.001-08:002015-11-27T04:05:57.274-08:00Lock your system using Rundll32.exe <div dir="ltr" style="text-align: left;" trbidi="on">
Sub lock_system()<br />
Dim cm As String<br />
cm = "Rundll32.exe User32.dll,LockWorkStation"<br />
Shell cm<br />
End Sub</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-69176954290117916752015-11-26T01:44:00.003-08:002015-11-26T01:44:48.273-08:00VBA Page Down<div dir="ltr" style="text-align: left;" trbidi="on">
ActiveSheet.Previous.Select</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-46341759037533100602015-11-26T01:44:00.000-08:002015-11-26T01:44:13.325-08:00VBA Page UP<div dir="ltr" style="text-align: left;" trbidi="on">
ActiveSheet.Next.Select</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-78124497022640110582015-11-22T08:09:00.000-08:002015-11-23T01:11:53.802-08:00NIIT has given this opportunity for all those who believe "Still lot more to Learn".<div dir="ltr" style="text-align: left;" trbidi="on">
NIIT has given this opportunity for all those who believe "Still lot more to Learn".<br />
<br />
Come Join and learn, get your expertise, get skilled and groom yourself with NIIT.<br />
<br />
http://www.niit.tv/NIITOnlineLearning/<br />
<br />
- "<b>I teach to learn</b>" Learning never ends.</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-47009458962726897422015-11-12T10:31:00.001-08:002015-11-12T10:31:41.171-08:00Count occurrence > 1 (Duplicates Check)<div dir="ltr" style="text-align: left;" trbidi="on">
=COUNTIF(A:A,A:A)>1</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-12404575954099424842015-11-12T10:29:00.001-08:002015-11-12T10:29:40.819-08:00Excel Counting between two numbers using Countifs <div dir="ltr" style="text-align: left;" trbidi="on">
=COUNTIFS(A13:A17,">=" & 2,A13:A17,"<=" & 5)<br />
</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-86032778987943324932015-11-12T08:29:00.000-08:002015-11-12T08:29:34.282-08:00Excel using Rept keyword with space<div dir="ltr" style="text-align: left;" trbidi="on">
=REPT(A2 & " ",3)<br />
<br />
A2 contains some text<br />
& operator used to add space with every repetition of text<br />
3 is the count to repeat text </div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-38728934429151467992015-11-12T06:19:00.000-08:002015-11-12T06:19:03.174-08:00Sumif based on name, start and end date<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: left;">
By this example you can pull the data in excel based on name, start and end date</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
=SUMIFS($C$2:$C$32,$B$2:$B$32,I4,$A$2:$A$32,">="& $G$2,$A$2:$A$32,"<=" & $H$2)</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
to download the example click on the below link </div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<a href="http://s000.tinyupload.com/?file_id=24613670605322543211">http://s000.tinyupload.com/?file_id=24613670605322543211</a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
</div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-58259947453633084672015-11-12T04:48:00.000-08:002015-11-12T04:48:10.440-08:00Using excel data cleaning functions CLEAN () TRIM () & PROPER() <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Calibri;">Scenario - cell A1 contains text in Camel case <span style="font-family: Times New Roman;">"EXa</span>mPlE TEXT " with some extra spaces and non printable characters</span><br />
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;">Use combination of data cleaning functions in cell A2 =CLEAN(TRIM(PROPER(A1))) </span><br />
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;">You will get desired output as "Example Text".</span><br />
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;">Please note specially in case of Postal code/Zip Code use UPPER function by replacing PROPER as generally they are required in upper case. </span><br />
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;"> </span></div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0tag:blogger.com,1999:blog-4025450197859308193.post-35516383929115123182015-11-12T04:33:00.001-08:002015-11-12T04:33:23.519-08:00Excel using IF condition with RIGHT function to get two decimal values if cell value >= 8<div dir="ltr" style="text-align: left;" trbidi="on">
=IF(B2>=8,RIGHT(B2,2))<br />
<br />
Example we have to fetch two decimal values if cell value is >= 8<br />
<br />
By assuming B2 contains 8.32 , the output would be 32 </div>
Ramneek Sharma - VBA/Data Extraction/Automation/MIShttp://www.blogger.com/profile/03940798798101225006noreply@blogger.com0