$$Excel-Macros$$ Delete File Contents

2013-08-25 Thread pankajinfo
Dear Gurus, I want to create a excel file with Date limit. Like in a file there are some contents(Graphs, Dashboards Etc) with 3 sheets. What i wants is after a time period like 31-Aug13 it gets expired and no one can open it or if someone opens after 31-Aug-13 it will delete all the file conten

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-25 Thread Chaya Cooper
bé trần văn - Unfortunately that didn't work because when I tried sorting the rows the images aren't moving accordingly :-( On Sunday, August 25, 2013 11:28:17 AM UTC-4, bé trần văn wrote: > > *You try this. > * > 2013/8/25 Prince > > >> No Chaya i dont think there is any way to do this with hype

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2013-08-25 Thread vba
Hey Welcome !!! Keep rokinnn.. Cheerz. On 25 Aug 2013 23:36, "Ishani Rajpal" wrote: > > Hello Everybody, > > This is Ishani here. I am a commerce graduate with an MBA in finance. I > have joined this forum to participate in excel discussions and also to > learn from it. > > > On Saturday, June

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-08-25 Thread Ishani Rajpal
Hello Everybody, This is Ishani here. I am a commerce graduate with an MBA in finance. I have joined this forum to participate in excel discussions and also to learn from it. On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome t

Re: $$Excel-Macros$$ listbox issue

2013-08-25 Thread Bé Trần Văn
*Please Upload the file. * 2013/8/25 xlstime > can u please share the example workbooks > > for better understanding > > . > > Enjoy > Team XLS > > > > On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski wrote: > >> Hi All, >> >> I have quite serious problem with the list b

$$Excel-Macros$$ Forecasting Methods using Excel

2013-08-25 Thread Prabhu Pinky
Hi Experts, Please share if you have any file for calls forecasting. Below are some methods in Forecasting which we use in daily basis. 1. Single Exponentioal method 2. Double Exponential Method 3. Winters Additive method 4. Winters Multiplicative method Am working in WFM Team, currently we do f

Re: $$Excel-Macros$$ listbox issue

2013-08-25 Thread xlstime
can u please share the example workbooks for better understanding . Enjoy Team XLS On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski wrote: > Hi All, > > I have quite serious problem with the list box (ActiveX). when I use it on > the sheet where is placed is fine, but

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-25 Thread prkhan56
Hello De Premor, It shows only blanks. No data at all. Please check Thanks for your time once again. Rashid On Sunday, August 25, 2013 1:29:34 PM UTC+4, De Premor wrote: > Try this code > > Function LookForCode(Str As String, Data As Range, _ > Colx As Integer, Optional Delim

$$Excel-Macros$$ listbox issue

2013-08-25 Thread pawel lupinski
Hi All,   I have quite serious problem with the list box (ActiveX). when I use it on the sheet where is placed is fine, but when I run any macro that is going to different sheets suddenly is becoming disable. in order to activate it I need to switch design mode click on list box and switch off d

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-25 Thread De Premor
Try this code Function LookForCode(Str As String, Data As Range, _ Colx As Integer, Optional Delim As String = "]", _ Optional RemoveDelimiter As Boolean = False) Dim Kode, Tmp As String For Each Kode In Split(Str, Delim) If Kode <> "" The

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-25 Thread Prince
No Chaya i dont think there is any way to do this with hyperlinks. On Wednesday, August 21, 2013 12:33:39 PM UTC+5:30, Chaya Cooper wrote: > > Eugene, > > I need to display the images inline. Is there a way to do that with > hyperlinks? > > > On Wed, Aug 21, 2013 at 12:18 AM, Eugene Bernard > >

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-25 Thread prkhan56
Dear De Premor, One small request please Is it possible to amend your code to retain the ] in the output. Thanks for your time. Regards Rashid On Wednesday, August 21, 2013 11:14:57 PM UTC+4, prkhan56 wrote: > Thanks De Premor, > Your code works on any sheet. > Regards > Rashid Khan > > On Wednes