Send your requirements to jos...@innoverglobalinc.com
Hi There,
Hope you're doing well.!!
This is *Joshua *from *Innover Global Inc*. Please take a quick look at the
below list of available resources coming out of projects and kindly let me
know if you come across any suitable opportunities. Ple
Hi
Unable to download files. pls could you mail this to my id.
dias.da...@gmail.com
Regards
On Sunday, 7 October 2012 14:58:10 UTC+5:30, Bullet wrote:
> *@ Krishna, Sir right now it's working fine.thanks a lot for all your
> kind support throughout. :) it's really make my job simpler.*
Anil nim did you find any class or person?
I have already gone through the book excel vba programming for dummies
which is similar to the free vba course that was posted. I still need
further training so I was curious what you are doing.
On Tuesday, July 29, 2014 10:50:26 PM UTC-5, anil nim wr
I have a macro (first I've ever written!) that works wonderfully with cells
that have not been conditionally formatted:
I need help with:
Function CheckColor(range)
'Returns Opportunity Words on deal score value.
If range.Interior.Color = RGB(198, 239, 206) Then
CheckColor = "Oppor
Thanks, it work wonderfully! :)
bless you.
Daniel.
On Friday, May 30, 2014 9:46:29 AM UTC, Abhi wrote:
>
> Try this:
>
> Private Sub test()
> Dim myrng As Range
> Set myrng = ActiveSheet.UsedRange
> For Each cell In myrng
> If IsDate(cell.Value) = True Then
>
I also tried to write:
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To finalrow
If IsDate = True Then
Cells.NumberFormat = "dd/mm/"
End If
Next i
but i get an error: Argument not optional.
On Friday, May 30, 2014 12:07:47 PM UTC+3, Kof Bar wrote:
>
> I re
Thanks a lot. It works.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Rajan_Verma
Envoyé : samedi 20 octobre 2012 06:31
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format
Try this
Hello, all,
Someone asks me if it were possible to format a chart area with a gradient
fill of more than two colors. I can't find no clue to this one.
Can anyone help ?
TIA
Daniel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Thanks for your reply Rajan.
To be honest, I really don't know what a compiler is. If you think it
would give me the results I'm looking for, I'd certainly try it.
Thanks again.
On Fri, Sep 14, 2012 at 11:59 PM, Rajan_Verma wrote:
> *Do you want a compiler . which can generate a Flat File da
Hi,
In B8 formula, there is no field element « Full Year FY11» for field « Half
Yearly ». Which cell address do you intend to place in cell B8 ?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shiek Peer Mohd
Envoyé : samedi
Use COUNTIF to check filenumber is unique :
=COUNTIF(the filenumber column,filenumber)=0
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bheema Shankar
Envoyé : mardi 6 septembre 2011 16:40
À : MS EXCEL AND VBA M
Private Sub CommandButton1_Click()
TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0)
End Sub
100.1 results to be 101.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shankar Bheema
Envoyé : mercredi 7 septembre 2011 15:52
À
You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is
considered a variable name, not a range.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de David Lanne
Envoyé : lundi 5 septembre 2011 07:06
À : excel-macros
Paste the below macro into the sheet module :
Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Intersect(Target, [G11:G23]) Is Nothing Then Exit Sub
Cancel = True
frmCalendar.Show
End Sub
Daniel
De : excel-macros
yVal Sh As Object)
If Sh.Name = "Sheet1" Then
Application.OnKey "{UP}", "Plus"
Application.OnKey "{DOWN}", "Moins"
Else
Application.OnKey "{UP}", ""
Application.OnKey "{DOWN}", ""
] - 1, 0)
End If
End With
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : samedi 3 septembre 2011 03:13
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Counter in a Cell
Hi
Erratum :
Private Sub Spreadsheet1_Click()
Me.Spreadsheet1.Windows(1).FreezePanes = True
End Sub
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de John Holland
Envoyé : jeudi 1 septembre 2011 11:30
À : MS EXCEL AN
Try :
Private Sub Spreadsheet1_Click()
Me.Spreadsheet1.Windows(1).FreezePanes = True
End Sub
HTH
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de John Holland
Envoyé : jeudi 1 septembre 2011 11:30
À : MS EXCE
… or a driver ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : mardi 30 août 2011 05:56
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)
Hi once again
This is totally
Hi,
Fine. Maybe the device linked to the USB cable come with an ActiveX control
?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : mardi 30 août 2011 05:56
À : excel-macros@googlegroups.com
Objet : $$Excel
uot;=offset" Then
Tabl = Split(Right(N.RefersTo, Len(N.RefersTo) - 1), ":")
Var = Range(Tabl(0)).Resize(, 1).EntireColumn.Address
N.RefersTo = "=OFFSET(" & Tabl(0) & ",,,COUNTA(" & Var & "))"
E
Hello,
Use :
a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" &
"AAO" & """),--(" & rng4 & "))"
HTH
Hello,
See attached workbook.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de C.G.Kumar
Envoyé : vendredi 26 août 2011 06:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Conditional Lookup or data validation
Dear All
Have a look at the page :
http://support.microsoft.com/kb/106359/en-us
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Robert Jacobs
Envoyé : jeudi 25 août 2011 16:35
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-M
= Tabl(i, 5)
Next i
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bhargava Raju
Envoyé : lundi 22 août 2011 11:32
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Help ASAP
Dear experts,
I need help in excel
You forgot the attachment ;-)
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shrinivas Shevde
Envoyé : mercredi 17 août 2011 11:04
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ From Word to Excel
Dear Daniel
Can you please send the word document which provoked the error (the one
which is opened) ? apparently, there are some merged cells in it.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shrinivas Shevde
Envoyé : mardi 16 août 2011
HI,
Paste this macro in the sheet module :
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Or Target.Count <> 1 Then Exit Sub
With Sheets("Sheet1")
.Shapes(1).Width = .[B1].Offset(, .[A1].Value - 1).Left
En
WordApp = CreateObject("Word.application")
WordApp.Visible = True
strRootFolder =
"C:\Users\Daniel\Documents\Donnees\Daniel\mpfe\Shrinivas"
Set FSO = CreateObject("Scripting.FileSystemObject")
For Each F In FSO.GetFolder(strRootFolder).SubFolders
So what ?
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de ChilExcel
Envoyé : jeudi 11 août 2011 20:00
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$
--
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.
Have a look at the attached workbook.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vickey
Envoyé : mercredi 10 août 2011 18:53
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ VB Code Require for Data Compilation
= .Cells(i - 1, 5)
End If
.Cells(i, 4) = Tabl(i, 4)
.Cells(i, 6).FormulaR1C1 = "=ROUND((NOW()-RC[-2])/365,0)"
.Cells(i, 7) = Tabl(i, 6)
.Cells(i, 8) = Ctr
.Cells(i, 9) = Fam
Next i
End With
End Sub
Regards.
Daniel
De :
. I didn’t to it cause
incompability of dates system.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Brajesh Kumar Porwal
Envoyé : jeudi 11 août 2011 11:43
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Split data order wise
Hi,
Can you explain a bit more ? there are 2 workbooks in your archive.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Brajesh Kumar Porwal
Envoyé : jeudi 11 août 2011 08:50
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros
Select February – July data
First rule :
=(C2-B2)/B2>0.05 è Red
Second rule :
=AND((C2-B2)/B2>0,(C2-B2)/B2<=0.05) è yellow
Third rule :
=C2mailto:excel-macros@googlegroups.com] De
la part de Jagadeesh B S
Envoyé : jeudi 4 août 2011 13:00
À : excel-macros@googlegroups.com
Objet : $$Excel-Mac
HI,
Sometimes, you have no choice.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de muralidhar e
Envoyé : lundi 1 août 2011 13:32
À : excel-macros@googlegroups.com
Objet : Fwd: $$Excel-Macros$$ Entered data should be locked
Hi,
See attached workbook
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : lundi 1 août 2011 12:02
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Dynamic Chart
Hi,
I needed data
HI,
True enough ! Sorry, I just tested the first cell;-(
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Viswanathan M
Envoyé : dimanche 31 juillet 2011 19:05
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ How
Can you attach a sample file such as issued from SAP ? The next point to
discuss is the detail sheets from the pivot. Do you want all of them or only
the ones you double clicked on the value field
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part
.Locked = True
Next c
ActiveSheet.Protect "excel"
End Sub
Have a look at the attached workbook.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de muralidhar e
Envoyé : dimanche 31 juillet 2011 14:25
À : excel-macros@goo
teger
Application.ScreenUpdating = False
inCalculationMode = Application.Calculation
Application.Calculation = xlCalculationManual
Const strPath As String = _
"C:\Users\Daniel\Documents\Donnees\Daniel\mpfe\" 'change the path
Dim strFile As String,
Sorry, it should have more correct to write "SUMPRODUCT" IS an array
function.
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Daniel
Envoyé : dimanche 31 juillet 2011 15:31
À : excel-macros@googlegroups.com
Obje
Yes, that's true. However, do not forget that "SUMPRODUCT" IS an array
formula, just designed to be entered as a standard formula by MS.
Best regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part d
Hi,
In AF2 (array formula, validate with Ctrl+Shift+Enter) :
=INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="P",COLUMN($B$2:$AE$2
Copy down.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de maulik desai
Envoyé : d
Hi,
Do you want to add the rows of each sheet below the preceding ones, or do
you intend to consolidate the sheets like you'll do it with Data,
Consolidate menus ?
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
It will be very difficult to move the code to the personal.xlsb workbook
without the initial file retaining some code. Can you explain why you want
to do so ? Maybe there should be alternative solutions.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros
I am sorry, I don’t know how to do it. Maybe it is possible to achieve it
with a class module, but evenso, I’m not able to do it so far.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : samedi 30 juillet 2011 17:00
Hello, Ayush,
Thanks for the translation. It’s a quite nice poem, although, sadly, the
essence of a poem cannot be translated.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la
part de Ayush Jain
Envoyé : samedi 30 juillet 2011 16:54
À
Means “for each value of r beginning =with 9 and ending to 1”
That is 9, 8, 7, 6, 5, … 1.
You generally use “step -1” when you have to delete rows.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vijayajith VA
Envoyé : samedi 30
Hello, Noorain,
I am really sad not to understand the meaning of your poem (is it
Hindi ? I failed to learn it a few years ago) I shall really enjoy to
get a translation from it. If you have time enough to do it.
Regards.
Daniel
On 30 juil, 04:20, NOORAIN ANSARI wrote:
> Dear Experts,
&g
… each tim you double click on a value of the pivot, the worksheet will be
created with the desired name.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : vendredi 29 juillet 2011 16:25
À : excel macro forum
Objet : Fwd
ue
If Target.Value <> "" Then
Target.ShowDetail = True
ActiveSheet.Name = Target.Offset(, -1).Value
End If
End Sub
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : vendredi 29 ju
I think the simplest way to do it is to split the window, freeze panes and
add a textbox or label and maybe a command button in the frozen part.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bob
Envoyé : jeudi 28 ju
HI,
Can you explain a bit more ?
Thanks.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : vendredi 29 juillet 2011 00:37
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Help needed to comine VBA
Just to precise that the « col » parameter should be a positive number, the
rightmost column being column 1.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Anil Bhange
Envoyé : jeudi 28 juillet 2011 14:23
À : excel-macros@googlegroups.com
Function
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Anil Bhange
Envoyé : jeudi 28 juillet 2011 14:23
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Reverse Vlookup
Thanks XlS S, Venkat and other members, I
et rgRange = rgRange.SpecialCells(xlCellTypeVisible)
rgRange.EntireRow.Delete
.AutoFilter.Range.AutoFilter
End With
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de arpit rajput
Envoyé : jeudi 28 juillet 2011 11:20
À : ex
Hi,
You should indicate the file name before the function :
Eg. Personal.xlsb! SpellNumber...
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : jeudi 28 juillet 2011 06:10
À : excel-m
Hello,
Have a look at the attached workbook.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nikhil Shah
Envoyé : lundi 25 juillet 2011 20:58
À : excel-macros@googlegroups.com
Cc : Maries waran
Objet : $$Excel-Macros$$ Date
Hi,
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de KAUSHIK SAVLA
Envoyé : mardi 26 juillet 2011 06:07
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Help Requ
uot; Then
c.Value = ""
c.Offset(, 2).Value = "Total Login Hrs"
c.Offset(, 2).Resize(, 2).NumberFormat = "[h]:mm:ss"
c.Offset(, 2).Resize(, 2).Font.Bold = True
End If
Next c
End Sub
Regards.
Daniel
Hi,
You can’t do it with a formula (a formula only changes the value of the cell
which contains it). Either you use the replace command (Ctrl+H) or you have
to use a macro.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé
"=AND(F1<>"""",D1>F1)"
.FormatConditions(1).Interior.Color = RGB(255, 0, 0)
End With
End Sub
Note that the formula has to be written in your local version of Excel. As
far as I am concerned, I have to translate it in French.
Regards.
Daniel
-Message d'orig
End With
End Sub
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Natron
Envoyé : jeudi 21 juillet 2011 04:15
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ VBA Conditional Format Offset
I have multiple columns (a
HI,
Sub ABCReplace()
[A1].Replace "ABC", "#"
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé : jeudi 21 juillet 2011 17:26
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$
There is incompatibility in the way both versions are handling pivots. If
you are to design pivots with Excel 2007 for Excel 2003 users, you should
run Excel 2007 in compatibility mode.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de
Target.Column = 7 And Target.Row > 6 Then
‘if cell being on the same row in column A <> ””
If Cells(Target.Row, 1).Value <> "" Then
‘change target value to “X”
Target.Value = "X"
‘macro ?
MoveRow
'MsgBox "Row has been copied"
End If
E
Note that in some cases, there is a difference between “Target” and
“ActiveCell”, when the active cell moves downwards or sidewards after you
hit the “Enter” key.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Daniel
Envoyé : vendredi 15
activecell or current selection.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de neil johnson
Envoyé : vendredi 15 juillet 2011 13:45
À : excel-macros
Objet : $$Excel-Macros$$ Hi I need your help , Please explain it with
example
Hello,
Have a look at the attached file.
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vishwa
Envoyé : jeudi 14 juillet 2011 03:09
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Providing mul
Hello,
Try :
Sub test()
Dim Wb As Workbook, Sh As Worksheet
For Each Wb In Workbooks
For Each Sh In Wb.Sheets
Sh.Cells.Replace "asdfghjkl", "lkjhgfdsa"
Next Sh
Next Wb
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com
Can you mail the sheet password back ?
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bob
Envoyé : dimanche 10 juillet 2011 20:57
À : excel-macros@googlegroups.com
Objet : Re: RE: $$Excel-Macros$$ Help with formula
Here is the file. On the Quote work
If
Next Sh
If Worksheets.Count = 2 Then
ActiveSheet.Name = [Sheet1!A2]
Else
Var = Application.Max(Tabl())
Var = Application.Match(Var, [Sheet1!A:A], 0) + 1
ActiveSheet.Name = Application.Index([Sheet1!A:A], Var, 1)
End If
End Sub
Regards.
Daniel
De : excel-macros
There is no « TB17 » textbox and that’s why you get an error.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : samedi 9 juillet 2011 13:01
À : excel-macros@googlegroups.com; dcolarde...@free.fr
Objet : Re: $$Excel
“Me” represents the object containing the code ; so, in this case, « me » is
equivalent to “Userform2”. Can you post your workbook ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : samedi 9 juillet 2011 00:32
À : excel
Didn’t you say the textboxes were in a userform ? if they are on a
worksheet, the syntax should be :
With ActiveSheet
For i = 1 To 22
txtbox_val = .OLEObjects("TB" & i).Object.Value
Next i
End With
Daniel
De : excel-macros@googlegroups.com [mailt
Which line gets the error ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : vendredi 8 juillet 2011 13:11
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by
Hello,
Maybe, use « SaveAs » instead of « Save » ?
Anyway, can you post your code ?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Stilgar
Envoyé : vendredi 8 juillet 2011 11:10
À : excel-macros@googlegroups.com
Objet : $$Excel
Hi,
Try :
For num = 1 To 22
txtbox_val = Me.Controls("TB" & num).Value
txtbox_num = num
Next num
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : vendredi 8 juillet 2011 11:00
À
End With
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : jeudi 7 juillet 2011 08:56
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ VBA Comment Box - Copy of
Hi
Have a photo in a comments box
Hello,
Can you explain a bit more ?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jai
Envoyé : mercredi 6 juillet 2011 13:07
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Vlookup Query-2
Hello Experts
I
Hello,
Consider the NETWORKDAYS function. If you are using an older version than
Excel 2007, you’ll have to install the Analysis Tool Pack.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : vendredi 1 juillet
Hi,
worksheets("sheet1").range(cells(x,1):cells(x,6).copy
worksheets("sheet2").range(cells(y,1),cells(y,6))
is one same line so you have to add an underscore mark :
worksheets("sheet1").range(cells(x,1):cells(x,6).copy _
worksheets("sheet2").range
dd 1
ActiveSheet.Paste
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\" & Item & ".xls"
ActiveWorkbook.SendMail strRecip, "Subject"
Next Item
End With
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.c
quot; And
Mid(sh.Name, 2, 1) < "5" And _
Mid(sh.Name, 4, 1) > "0" And Mid(sh.Name, 4, 1) < "5" And
Mid(sh.Name, 3, 1) = "C" And _
Len(sh.Name) = 4 Then
sh.DrawingObject.Enabled = False
End If
End
Charts are quite different with Excel2007, so you have to resize the plot
area, change the series colors in order to get something similar. I use
Excel 2010 which is still different from Excel 2007.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part
<>
Hi,
Can you ell which macro is involved and which result is different ?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : lundi 20 juin 2011 10:19
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros
Hello,
This one works for me :
Selection.FormulaArray = _
"=RC[-4]:R[" & Z & "]C[-4]&RC[-3]:R[" & Z & "]C[-3]&RC[-2]:R[" & Z &
"]C[-2]"
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:e
Hello,
Try :
Sub test1()
Dim Enrgt As String
Close #1
Close #2
mypath = "d:\donnees\daniel\mpfe\" 'files path, please change
Open mypath & "RPTbamCommon Maintenance201106061432493.txt" For Input As #1
Open mypath & "Output.txt" For Output As
Hello,
Is the comma your decimal symbol ?
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de F4b10cut3r
Envoyé : dimanche 19 juin 2011 16:43
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ My first cal
I need a 0 in A1, data starting in A2:B2. Starting date in D1 (calendar one
eg. 12/1/2008), end date in D2.
Formula for a is (array formula, validate with Ctrl+Shift+Enter) :
=SUMPRODUCT((A2:A1001>=D1)*(A2:A1001<=D2)*IF(DAY(A2:A1001)=D1)*(A2:A1001<=D2)*IF(DAY(A2:A1001)=D1)*(A2:A1001<=D2)*(IF(DAY(A
Hi,
I don’t think there are tool to automate the processbecause the syntax is
very similar. Can you post your code and tell which line produces the error
?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé
See attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3
attached once again for some correction and explanation
See attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3
attached once again for some correction and explanation
I have trouble understanding ; can you post which result is expected ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : vendredi 17 juin 2011 08:28
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry 3
See attached file.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : jeudi 16 juin 2011 13:02
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry-3
Dear Members,
i need the formula please
Maybe this file ?
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : mercredi 15 juin 2011 08:44
À : MS EXCEL AND VBA MACROS
Objet : Re: $$Excel-Macros$$ querry new
Thank you Daniel, but when i
Have a look at the attached file.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : mardi 14 juin 2011 13:47
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry new
file is attached. i need formula please
Works for me. Put a break point onto the last line and check the array data.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Richard
Envoyé : lundi 13 juin 2011 22:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ List Box
I am
1 - 100 of 267 matches
Mail list logo