Thanks alot Daniel
On Mon, Apr 4, 2011 at 2:38 PM, Daniel wrote:
> Hi,
>
> Paste this macro in the first workbook. Open it manually and run the “Test”
> macro.
>
>
>
> Sub test()
>
> Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range
>
> Const strPath As String = "D:\Donnees\Daniel\mpfe
Its awesome.Hats off to Ashish.
Regards,
C.G.Kumar
On Thu, Apr 7, 2011 at 10:35 AM, ashish koul wrote:
> try this
>
> On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar
> wrote:
>
>> Hi Experts,
>>
>>
>> We required your help for creat auto mailer in excel. or any other way,
>>
>> I have to send 200
HI Ashish,
Its helping but i dont want to create pivot every time. i want to remove
this manual effort.
Can you please share some macro i can enhance that. please send me some
macro.
when i press the button for SV. it has to calculate SV into three sheets.
Please help me on this.
Regards,
ANJ
Yes, you are on the right track. However, I am looking for more of an
automated loop with an option to prompt me as to how many repititions
to be made. I would probably want to run thousands.
After making this request, I noticed that here appears to be something
suspiciously wrong with the random
try this
On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar wrote:
> Hi Experts,
>
>
> We required your help for creat auto mailer in excel. or any other way,
>
> I have to send 200 mails with different attachment. can we creat auto
> mailer in excel thourgh macros.
>
> Please help me out.
>
> Thanx i
Save the Workbook as an Add-In
The workbook containing your code module now has to be saved as an Excel
Add-In (*.xla) file.
In the Excel window go to *File > Save* to open the *Save As* dialog. Enter
a name for your Add-In file (the usual file naming rules apply) and use the
*Save as type:* opti
You might be using a 2007+ Excel file. Try using the extension .xlam
On Apr 6, 6:01 pm, Deepak Rawat wrote:
> Hi Friends,
>
> I have made some macros for some purpose and i want to use that in my
> all the excels.
> i got information from the net that is i change the extension of file
> to xla an
Dear members,
Thanks for all your contribution to group. I am very happy to see the
great participation in the group.
For me its very important to know what you feel about the group, So that I
can take any action or initiative on the basis of your feedback.
This is an anonymous survey , so f
This really works
One thing more.You have to keep your outlook opened to get this done
On Wed, Apr 6, 2011 at 1:32 AM, Sanjoy Nath wrote:
>
> Public olApp As Object
> Public oNewMail As Object
> Public FilePath As String
>
> Public isthereFileAttach As Boolean
> Public bd As String
> Public sb A
Hi Friends,
I have made some macros for some purpose and i want to use that in my
all the excels.
i got information from the net that is i change the extension of file
to xla and put in addin folder then it will work.
But its giving error that the file is not in proper fomat.
Pls help me on this
Congratulations Ashish especially for your help and also to this forum, i
have to say my learnings in macro are exponential since this was created, i
was a zero at the beginning!
2011/4/6 Aindril De
> Congrats Ashish!! Keep up the good work!! Cheers
> Andy
>
>
> On Wed, Apr 6, 2011 at 3:21 PM, N
Ohh thank you very much :)
2011/4/6 ashish koul
> try this
>
> Sub Datacopy()
>
>
> Sheets("teste").Range(Sheets("teste").Cells(1, 1),
> Sheets("teste").Cells(Sheets("teste").Range("a65356").End(xlUp).Row,
> 3)).Copy
>
>
> With Sheets("destino")
> .Cells(Sheets("destino").Range("a6
Ashish is really very good in VBA Programming and He want to help people by
Using his excellent knowledge of Excel VBA,
Good Going Bro... keep it Up.
Rajan
On Mon, Apr 4, 2011 at 5:01 PM, Raghunandan wrote:
> Gr8 goin
>
>
> On Mon, Apr 4, 2011 at 10:25 AM, mrinal saha wrote:
>
>> Ashish,
Hi,
I have this great Monte Carlo Simulation program for blackjack. I am
not all that good in VBA, but would like a small macro to run this
program, the copy and paste the results to another sheet, then repeat
that task again for as many times as I wish.
Any takers ? I can forward the spreadshee
Congrats Ashish!! Keep up the good work!! Cheers
Andy
On Wed, Apr 6, 2011 at 3:21 PM, NOORAIN ANSARI wrote:
> Congrats Ashish..Keep it up
>
> On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote:
>
>> Hello Everyone,
>>
>> Ashish Koul has been selected as 'Most Helpful Member' for the month of
>> Ma
Hi,
Try :
Sub test2()
Dim c
With Sheets("calculator")
On Error Resume Next
For i = 1 To .Shapes.Count
Var = .Shapes(i).OLEFormat.progID
If Err.Number <> 0 Then
Err.Clear
Else
If .Shapes(i).OLEFormat.progID = "Forms.TextBox.1" _
Congrats Ashish..Keep it up
On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> March'11
> He has posted 48 posts in March 2011 and helped many people through his
> expertise. He has been consistent con
Is it possible in any version of excel to save text file as ANSI
encode instead of Unicode
regards,
Farhan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitt
I want to thanx to all member and specially Dilip who give some usefull
suggestion and tricks .
Regards
Manoj Kumar
On Thu, Mar 31, 2011 at 10:34 AM, Dilip Pandey wrote:
> Hi Manoj,
>
> You can subscribe to this group by following the below link:-
> http://groups.google.com/group/excel-macros
Public olApp As Object
Public oNewMail As Object
Public FilePath As String
Public isthereFileAttach As Boolean
Public bd As String
Public sb As String
Public Sub ONE_ONE(ByVal recipient As String)
Set olApp = CreateObject("Outlook.Application")
Set oNewMail = olApp.CreateItem(olMailItem)
W
Dear Santosh,
Please find & see attached sheet, if it help..
--
Thanks & regards,
Noorain Ansari
On Wed, Apr 6, 2011 at 3:00 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Group,
>
> Need a code to clear the values of all the text boxes ,comboboxes in one
> click in a excel
=Mid(cell Reference, Start from Digit, No of Digits)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http:
Hi in this formula if i am incresing the range 25 to 125 then it is counting
blank cell also and traeting blank cell as a jan month so is there any
suggestion where can we ignore blank cell
=IF(ISERROR(AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125))),"",AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125)))
U can Use Mid Function for the same
=Mid(Cell Reference, Starting Num, No of Chars)
For eg
Ur Orignal Code is 8900765
U want 765 then fromula is
=mid(cell Ref, 5,3)
Hope this will get result as u want.
On Apr 1, 6:55 pm, "Puttu *" wrote:
> Can you please please help any one
>
>
>
>
>
> On Fri
24 matches
Mail list logo
