Excellent, u r so nice.
Really I was struggling with this bloody problem..
Good bye to the problemblemblemblemblemblem...
Thanks & Regards,
Muneer,
CC...
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] O
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: Saturday, February 18, 2012 6:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Mr.Noorain there is again some problem in
u r solv
OK.
first I find the number in the dial which is the greatest number less than
or equal to the required value. I use match to find how far down it is
from J2. This number goes in P7.
Then I find out the chart value and corresponding angle for that lower
amount and these go int P8 and Q8
Next I
Hi,
Is thr good future in learning Imacros?
Thanks
On Fri, Feb 17, 2012 at 11:12 PM, xlstime wrote:
> Hi Amit,
>
> iMacros is the *only* software that can *automate both Internet Explorer
> and Firefox.* You can control both web browsers directly from Excel.*iMacros
> works with every website
Wow Dave,and wow again, this is a gret solution, never mind
replying late, this is so incredible. after a while i thought it was
not possible, great mind you got over there, thumbs up seven times,
but sorry man you need to expalin the relevance of using the offset
function there and the fo
Sir,
vow instant reply, great!!
but i am getting error in line
Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File
Names").Range("c2").Value & "*", After:=wk.Cells(1, 1), _
LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)
pls hel
Dear Raghu,
Plwase try it..
Dim j As Long
Dim fldpath
Dim fld, fil, subfld As Object
Sub search_workbooks()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
'* to get file names in folder
Application.FileDialog(msoFileDialogFolderPicker).Title = "Choose Fo
hi all,
how to find a text in folder.
Example - suppose in 1 folder there are 40 excel files, if i want find a
text "apple" is in which file (as it becomes tedious to open each and every
file and use ctrl +F option).
with regards
raghu
--
FORUM RULES (986+ members already BANNED for violation
Simply record a macro while doing a manual edit>find>then add your input box
and clean it up.
If you need further help, post back and/or send a file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: David Grugeon
Sent: Friday, February 17, 2012 11:25 PM
To: excel-macros@googlegroups.co
Plz see the attached
From: PRAVESH KUMAR
To: excel-macros@googlegroups.com
Sent: Saturday, 18 February 2012 12:38 PM
Subject: $$Excel-Macros$$ Conditional formatting
HI,
Please help...for conditional formatting
PFA attached file
Hi Noorain,
It will work only one cell at a time, is it possible to put subject to
multiple cellls at a time.
Regards,
Vijayendra
2012/2/17 NOORAIN ANSARI
> Hi Renu,
>
> Please see attached Screen shot, it might be helpful
>
>
> On Fri, Feb 17, 2012 at 1:17 PM, Renukachari Kasee wrote:
>
>>
hi
Option Explicit
Sub ExportToExcel()
On Error GoTo ErrHandler
Dim appExcel As Excel.Application
Dim wkb As Excel.Workbook
Dim wks As Excel.Worksheet
Dim rng As Excel.Range
Dim strSheet As String
Dim strPath As String
Dim intRowCounter As Integer
Dim intColumnCounter As Integer
Dim msg A
hi
it was not work actually in my excel backend some code is there once
can you check tahat and give me solution for that
thanks for ur valueble replay
On Feb 17, 4:48 am, NOORAIN ANSARI wrote:
> Hi Renu,
>
> Please see attached Screen shot, it might be helpful
>
> On Fri, Feb 17, 2012 at 1:1
13 matches
Mail list logo
