Paul,
Thank for your reply. You answer is acceptable up to some extend. But I
don't wan't to open the book every day, I just want to execute the macro
only.
** **
I have a data base of Insurance expiring dates. I wan't to get a message
before the insurance expired.
See the attached
Hi All,
I want to Portable Excel 2007.I had already portable Excel 2007 but one
time it is delete by me.when I have XSLM file then cant open it & its
formula.In my PC I used excel 2003 but when I required excel 2007 I also
open it to see file But now it is so hard to look XSLM file .So Pls Send me
Dear Don & Prince
Thanks so much and its working perfectly !!!
Thanks to Rajan too :-)
cheers
Jp
On Tue, Aug 7, 2012 at 7:38 PM, dguillett1 wrote:
> Option Explicit
> Sub ChangeShapeColorsSAS()
> Dim i As Long
> Dim ms As String
>
> On Error Resume Next
> For i = 2 To 5
> ActiveSheet.Shapes(i
Please visit here for more details
http://www.functionx.com/vbaccess/
On Thu, Aug 2, 2012 at 6:59 PM, wirelesscellularguy <
wirelesscellular...@gmail.com> wrote:
> Hi All,
>
> I am trying to relate Access data & queries to excel. The excel will be
> the user interface. This excel will contain th
I've just send you.
Thanks
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Tuesday, August 7, 2012 7:49 PM
Subject: Re: $$Excel-Macros$$ Re: Auto Filling of Color - Need Help
Or, if you do not know the name ON the shape and you don’t ha
Or, if you do not know the name ON the shape and you don’t have the row in
column C
This gets the name and finds it in col c and uses the col d value in that row.
Sub fillcolorSAS()
Dim shp As Shape
Dim mn As String
Dim mr As Long
With ThisWorkbook.Worksheets("sheet1")
On Error Resume Next
For
Formula was tested using the defined names I created. Perhaps you tried
somewhere where you didn’t have the defined names.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Tuesday, August 07, 2012 12:57 PM
To: excel-macros@googlegroups.com
Also this formula is giving incorrect output.. :(
On Tue, Aug 7, 2012 at 9:16 PM, dguillett1 wrote:
> See attached where I added defined names for sumproduct formulas
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Secret Shot
> *Sent:* Tu
Hi Amar,
I think it depends on the creativity of a person you should search on
google for this.
regards
prince
On Tuesday, August 7, 2012 7:26:56 PM UTC+5:30, amar takale wrote:
>
> All Experts
> Can anybody give me index sheet example where index sheet is fantastic
> presentation view In spre
Hi JP
Please see the attachment.
regards
prince
On Tuesday, August 7, 2012 2:30:26 PM UTC+5:30, Jayaprakash S wrote:
>
> Dear Experts,
>
> Good Noon.
>
> Need help in auto filling of Colours to the shapes as well
> attached excel sheet for more information.
>
> Kindly Help & advise.
>
>
Rajan - can you please define how shape color is changing.
Aamir Shahzad
On Tue, Aug 7, 2012 at 7:08 PM, dguillett1 wrote:
> Option Explicit
> Sub ChangeShapeColorsSAS()
> Dim i As Long
> Dim ms As String
>
> On Error Resume Next
> For i = 2 To 5
> ActiveSheet.Shapes(i - 1).Fill.ForeColor.RGB
thanks Don,
Great Help, but is there any other way to do it without Sumproduct.
Regards
Pankaj k Pandey
On Tue, Aug 7, 2012 at 9:16 PM, dguillett1 wrote:
> See attached where I added defined names for sumproduct formulas
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dg
result on google search
http://www.youtube.com/watch?v=dBTkl1tnXao
http://www.pcreview.co.uk/forums/scrolling-marquee-t917395.html
http://officeone.mvps.org/powershow/powershow_ticker_show.html ( check
ticker)
http://www.dailymotion.com/video/xfeurt_create-the-scrolling-text-animation-effect-in-po
Hi Rajan,
Thank you for providing me the VBA code, now i got the accurate result.
Once again thanks for resolving the query. Have wonderful day ahead.
Regards
Lokesh.M
On Tue, Aug 7, 2012 at 9:05 PM, Rajan_Verma wrote:
> *Replace this one:*
>
> * *
>
> *.Offset(lngCellLoop, 1).Value =
> Worksh
See attached where I added defined names for sumproduct formulas
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Tuesday, August 07, 2012 6:13 AM
To: excel-macros@googlegroups.com
Cc: pankaj. pandey
Subject: $$Excel-Macros$$ Excel Challang
Also use this format
[h]:mm:ss
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 07 August 2012 9:06
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Run-time error popup message
Replace this one:
Replace this one:
.Offset(lngCellLoop, 1).Value =
WorksheetFunction.Text(TimeSerial(Hour(.Offset(lngCellLoop, -1).Value) + (4
* objDic.Count) + 24, Minute(.Offset(lngCellLoop, -1).Value),
Second(.Offset(lngCellLoop, -1).Value)), "[h]:mm:ss")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk
Right click sheet tab>view code>copy/paste both of these. Now,if you have sheet
name or workbook name typed into a cell and double click that cell you will go
there. (if open it will activate, if not, it will open))
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolea
All Experts
Can anybody give me index sheet example where index sheet is fantastic
presentation view In spreadsheets Example like Company name, stock
price,worksheet name, & Other information.
If any look that index sheet they will say O this is Fantastic Presentation
Thanks everyone
Amar
--
Joi
See the attached sheet
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jayaprakash S
Sent: 07 August 2012 2:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Auto Filling
Another way without hyperlink using a doubleclick event in the worksheet module
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
Dim ms As String
Dim mc As String
With Target
ms = Mid(.Formula, 2, InStr(.Formula, "!") - 2)
mc = Mid(.Formula, InStr(.Formula, "!")
=MID(A1&B1&C1,SEARCH("(",A1&B1&C1),SEARCH(")",A1&B1&C1)-SEARCH("(",A1&B1&C1)+1)
On 7 August 2012 21:45, RAJA SEKAR wrote:
> Try This
>
> =RIGHT(A1,LEN(A1)-FIND("(",A1,2)) & B1 & IF(LEN(C1)<>FIND(")",C1,1),
> LEFT(C1,FIND(")",C1,1)-1),"")
>
>
>
> On 7 August 2012 16:48, Shekhar Sharma wrote:
>
>
Hi Jayendra,
You Save file Save as type: - Excel 97-2003 Workwook.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Tue, Aug 7, 2012 at 5:36 PM,
Team,
I am using excel 2007.
I have one file .i need one icon for all excel work book where i click and
that file need to open.
--
J.Gaurav
Call-7838594954
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Try This
=RIGHT(A1,LEN(A1)-FIND("(",A1,2)) & B1 & IF(LEN(C1)<>FIND(")",C1,1),
LEFT(C1,FIND(")",C1,1)-1),"")
On 7 August 2012 16:48, Shekhar Sharma wrote:
> Hi Friends
>
> I am struggling with one problem and need your help.
>
> I have three columns available like:
> *Column A* *Column B*
Team,
I wan to maintain a log for pivot table.
example - when I click on refresh button that time old data save in log
file.
--
J.Gaurav
Call-7838594954
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for viola
THank you so much Paul.
On Tue, Aug 7, 2012 at 4:41 PM, Paul Schreiner wrote:
> try this macro:
> Sub Make_FolderList()
> Dim R, nRows, BaseFldr, fso
> Set fso = CreateObject("Scripting.FileSystemObject")
> BaseFldr = "C:\"
> nRows = Application.WorksheetFunction.CountA(Range("A1:
Hi Friends
I am struggling with one problem and need your help.
I have three columns available like:
*Column A* *Column B* *Column C* 92683 (1 18067.0 1) (8625.11)
1) Now I would like to have a formula in Column D where it will check the
destination of "(" (if exist) and merge the data
I would set up the macro as either a Workbook_open event or name the macro
Auto_Open.
then, create a Scheduled Task in Windows to open the workbook at 9:00am daily.
I do this with several very large macros (and have them run at 11:00pm or
4:00am
so they are complete before I come in)
and they h
try this macro:
Sub Make_FolderList()
Dim R, nRows, BaseFldr, fso
Set fso = CreateObject("Scripting.FileSystemObject")
BaseFldr = "C:\"
nRows = Application.WorksheetFunction.CountA(Range("A1:A65000"))
For R = 2 To nRows
If (Not fso.folderexists(BaseFldr & Cells(R, "A").V
Hi Friends.
Please tell me how to create the folder by the names which I have entered
in the sheet.
For more information, please refer the attached sheet.
Please provide me solution.
--
With regards,
MaNgEsH
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
Friends,
I want to run a macro* every day in a give time(say 9.00AM)* when the work
book not open. Then open the work book and show a message if the given
conditions(say two cells have same value) fulfil. see the below written
macro for further explanation.
But the given below macro not working at
Thanks Kuldeep.
On Monday, 6 August 2012 11:13:45 UTC+5:30, Kuldeep Singh wrote:
>
> Hi,
>
> Please See it.
>
> http://www.wallst-training.com/WST_Financial_Modeling_Steps.pdf
> http://www.freefmt.com/
>
> http://api.ning.com/files/8fQTDF096XOzHDjo-Ea1729Rwe9JmHgjmEnXoTi*5dQkCyK2Q-NCnfVaMetc*XQ96
Dear Experts,
Good Noon.
Need help in auto filling of Colours to the shapes as well
attached excel sheet for more information.
Kindly Help & advise.
Thank you.
JP.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BAN
ok
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Tuesday, August 7, 2012 11:53 AM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
C the attached file. ? u r missing.
From
35 matches
Mail list logo
