Dear Mr.Prabhu, Pls add my number also in Whatsapp Group
Mobile: 9321035459
Regards
Bala
On Tue, Sep 19, 2017 at 12:32 PM, Manoj Garg wrote:
> Dear Mr. Prabhu
> Please add me in WHATAPP GROUP
>
> M: 9927199217 <099271%2099217>
>
> On Tue, Sep 19, 2017 at 12:17 PM, N.Shi
Bala Iyer From Mumbai
On Sat, Sep 21, 2013 at 11:10 AM, Rupesh Patil
wrote:
> Hi My name is Rupesh from Pune Maharashtra, India. I am working as
> technical support engineer and customer support engineer.
> I am looking for VBA help. actually I have task assigned to build up tool
&
hi,
see this link :
http://www.dailydoseofexcel.com/archives/2004/09/22/automating-internet-explorer/
with regards
Bala
On Apr 15, 11:16 am, kris wrote:
> Hi All,
>
> I have a requirement to work with internet and to enter some text,
> need to select option buttons, need work with
Str(Element.Value, Caption) > 0 Then
Call Element.Click
Call LoadPage
Exit Function
End If
Next Element
Button = False
End Function
Sub LoadPage()
' Pauses execution until the browser window has finished loading
Do While brs.Busy Or br
example pls, then only i can try and give the feedback to you
On Apr 16, 6:52 pm, santosh bahuguna
wrote:
> Thanks a lot bala i like the way you this
>
> i wanted a solution for you , in vba if we got alertbox in webpage
> everything got stop i wanted to get the text on the alert
Else
strTest = strTest & ActiveCell.Value
End If
ActiveCell.Offset(1, 0).Select
Wend
Range("D6").Value = strTest
End Sub
regads
bala
--~--~-~--~~~---~--~~
-
.Copy
End With
Next
'Paste it into word
appWord.Activate
With appWord
.ActiveWindow.Selection.Goto what:=wdGoToPage,
Which:=wdGoToNext, Name:=strPageNumber
.ActiveWindow.Selection.Paste
End Wit
mats
End Select
End If
Next
Unload Me
End Sub
regards
Bala
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video
Hi,
Try this code
dim dtDate as Date
dtDate = Thisworkbook.Names("IDO_Date"").RefersToRange.Value
for i = 2 to Sheets.count
sheets(i).select
if date(Range("B2").value)=dtdate then
Exit For
end if
Next
On May 19, 7:44 pm, Doug wrote:
> Hello,
> I have a work
Hi,
Try this code
Range("A1").select
while Activecell.value <> ""
if len(Activecell.value) >3 then
Activecell.offset(0,1).value = Activecell.value
else
Activecell.offset(0,1).value = 0 & Activecell.value
end if
Activecell.offset(1,0).select
uot; & ActiveCell.Offset(0, 89).Address & " is
empty"
End If
ActiveCell.Offset(1, 0).Select
Wend
End Sub
Regards
Bala
On May 29, 12:53 pm, amrahs k wrote:
> Hi Harmeet,
>
> I just want a macro for validating a particular column in the attached
> spreadsheet.
Hi;
use this formula and drag it ==> =IF($E$4+R9<$I$4,$E$4+R9,"")
Regards
Bala
On May 29, 11:26 am, Prashanth Banneni wrote:
> Hi All,
>
> I have a issue with excel. Hope you can solve it easily :)
>
> I have a list with start date and and end date.
>
>
hi,
Sub test()
icount = Len(ThisWorkbook.Name)
icount = icount - 4
strtest = Left(ThisWorkbook.Name, icount)
ThisWorkbook.SaveAs (ThisWorkbook.Path & "\" & strtest & " " & Format
(Date, "dd-mmm-yyyy") & ".xls")
End Sub
with Regards
sample file needed
On May 29, 10:01 pm, "Abdul Shakeel" wrote:
> Hi All,
>
> I am searching for macro that hide or delete column(s) if they haven't any
> values, & if any cell in that particular column(s) have any value then we
> couldn't delete or hide the column.
>
> Regards,
>
> Shakeel
--~-
Cell.Offset(0, 13).Value = "" Then
ActiveCell.Offset(0, 13).Value = 0
End If
' For SQFT
If ActiveCell.Offset(0, 14).Value = "" Then
ActiveCell.Offset(0, 14).Value = 0
End If
' For COUNTRY
If ActiveCell.Offset(0, 17).Value = "" Then
hi,
use this code in Worksheet_Change
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Target.Value = Left(Target.Value, 25)
End If
End Sub
Regards
bala
On Jun 1, 2:44 pm, manish gupta wrote:
> Hi Bala,
> Thank you for helping me in this matter,it is w
Hi,
try this code
Activeworkbook.saveas(Thiswookbook.path & "\" ClinentName & format(now
(),"ddmmhhmm")&".xls")
With regards
BALA
On Jun 27, 5:14 pm, "Chidurala, Shrinivas "
wrote:
> Dear Friends
>
> I want file sho
hi,
use this formula : =IF(INT((LEFT(A2,LEN(A2)-1)))<1000,1,"NA")
with regards
BALA
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and
hi,
in workbook_open write --> Sheets("Sheet3").Activate
Private Sub Workbook_Open()
Sheets("Sheet3").Activate
End Sub
with regards
BALA
On Jun 30, 11:16 am, DEBASHIS BANERJEE wrote:
> I am enclosing herewith an Excel File containing Three Sh
ate
Activecell.value = strDocName
Activecell.offset(1,0).select
End If
Wbk.Close False
sFil = Dir
Loop
With Regards,
Bala
--~--~-~--~~~---~--~~
--
Some impor
Len
(ActiveCell.Value) - 1)
End If
ActiveCell.Offset(1, 0).Select
Wend
End Sub
with Regards
BAla
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
Hi,
use this following link...I think it will be helpful to you.Good Luck
http://support.microsoft.com/kb/213360
On Fri, Jul 10, 2009 at 3:32 PM, amresh kumar wrote:
> Hi,
>
> Please give me a solution urgent.
>
> formula of convert numeric value of in Text
>
> Example:
>
> If
Hi All,
Can anyone help me in loading the excel information to Oracle Applications.
I have a list of transactions which I manually enter in to Oracle AP
transactions manually. can we record macro which automatically pic the
transactions by step and post it to the Oracle Applications tab which I u
Hi Roopesh...
Thanks for that...
On Mon, Aug 17, 2009 at 1:31 PM, Roopesh Kapur wrote:
>
> y can either use sendkey or go to a website cld.
> Www.dataload.net<http://www.dataload.net/>
>
> On 8/17/09, bala Subrahmanyam puligadda wrote:
> > Hi All,
> >
>
gust 17, 2009 4:01:17 AM
> *Subject:* $$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)
>
>
> y can either use sendkey or go to a website cld.
> Www.dataload.net<http://www.dataload.net/>
>
> On 8/17/09, bala Subrahmanyam puligadda wrote:
> > Hi All,
> &
Hi ALL,
Please help me in the repeating some calculations by using the macro.
the following are the details for that
we have to do calculation on the Employee Summary Rep tab.
Please look into
A17 row i.e., the subtotal for Organisation name ABC
now what we have to do is to calculate the
sum of
Can any one help me...I need this very urgent..
Thanks...
-- Forwarded message --
From: bala Subrahmanyam puligadda
Date: Sat, Nov 28, 2009 at 12:00 PM
Subject: $$Excel-Macros$$ Help required in repeating calculation using macro
To: excel-macros@googlegroups.com
Hi ALL
Hi ALL,
Please help me in the repeating some calculations by using the macro.
Please find the attachment.
the following are the details for that
we have to do calculation on the Employee Summary Rep tab.
Please look into
A17 row i.e., the subtotal for Organisation name ABC
now what we have to d
Hi, can you please tell me what additional information you need.
Thanks,
Bala
On Thu, Dec 3, 2009 at 9:21 PM, RolfJ wrote:
> I'd be happy to help, but would need a bit more information.
>
> Rolf Jaeger
> SoarentComputing
> http://soarentcomputing.com/SoarentComputin
29 matches
Mail list logo
