Re: $$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-03 Thread ashwani agnihotri
Thanks Ravinder. This works perfect for me. :-) Also, can you guide me with material/ website from which i can learn dashboard from scratch to end. Regards, Ashwani On Thu, Oct 3, 2013 at 12:40 PM, Ravinder wrote: > PFA, I think u r looking for this. > > ** ** > > *From:* excel-macros@goo

Bls: Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread De Premor
You're welcome, With that code you can customize the image to fit with cell width or cell height -Original Message- From: Bill Q Sender: excel-macros@googlegroups.com Date: Thu, 3 Oct 2013 19:52:50 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Inserting BMP

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread Bill Q
Hi De Premor, Yes this pretty much close to what I am looking for. Many thanks. On Thursday, October 3, 2013 10:44:12 PM UTC-4, De Premor wrote: > try this attached file, i hope you can find something there > > On 03-10-2013 7:22, Bill Q wrote: > > Hi Ashish, > > I put the macro in

$$Excel-Macros$$ Re: Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread Bill Q
Hi Besole, This kind of work, but there are a couple of issues. A. I would much prefer inserting the graphic file as opposed to having to manually enter the whole directory. Unfortunately, the files are being stored in different directories and sub-directories for classification purposes a

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread Bill Q
Hi Ashish, Unfortunately, it has failed again. The message I get indicates... Run Time error '1004' "Insert method of pictures class failed". Not certain if it matters, but I am inserting bitmaps (.bmp). I am also using Excel 2007. On Thursday, October 3, 2013 9:54:51 AM UTC-4, ashish

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 11:01:36 PM UTC+8, ashish wrote: > > check the attached file see if it helps > > still not working > > On Thu, Oct 3, 2013 at 8:24 PM, > wrote: > >> >> >> On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: >>> >>> try something like this >>> >>>"URL;ht

$$Excel-Macros$$ Re: Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread Basole
Hi Bill, see this example attached... Em quarta-feira, 2 de outubro de 2013 10h24min32s UTC-3, Bill Q escreveu: > > Hi, > > I know how to insert the image. The thing is I want the cell to always be > always the same size. > > Any advice ? > > Thanks. > -- Are you =EXP(E:RT) or =NOT(

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-10-03 Thread Nasir Khan
Yes I did. But as mentioned in my reply I need the code to 1) run on all the files in the given Path = Your code run a single folder at a time...there are several folder in the given path. 2) Each table should come on a separate sheet - Your code bring in the table one below other 3) The sheet nam

Re: $$Excel-Macros$$ Unique sorted drop down lists based on multiple selections and other table

2013-10-03 Thread jasmucrai
Sure, I'm attaching a new spreadsheet to this post. I have been using dynamic range names (OFFSET), arrays (MATCH, INDEX, SMALL, etc) and the INDIRECT function to specify which contract numbers belong to a specific year for each one of the companies. However, I would like to have something more a

Re: $$Excel-Macros$$ Re: export table to Excel from a link

2013-10-03 Thread ashish koul
check attached file see if it helps On Thu, Oct 3, 2013 at 8:20 PM, wrote: > > > On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote: >> >> With ActiveSheet.QueryTables.Add(Co**nnection:= _ >> "URL;https://secure.**fundsupermart.com/main/** >> fundinfo/dailyPricesHisto

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread ashish koul
check the attached file see if it helps On Thu, Oct 3, 2013 at 8:24 PM, wrote: > > > On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: >> >> try something like this >> >>"URL;https://secure.**fundsupermart.com/main/** >> fundinfo/dailyPricesHistory.**tpl?id=

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: > > try something like this > >"URL; > https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id="; > & Sheet1.Range("H1").Value, Destination:=Range( > "A1") > *not working* > > On Thu, Oct 3, 2013 at 2:20

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: > > try something like this > >"URL; > https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id="; > & Sheet1.Range("H1").Value, Destination:=Range( > "A1") > not working > > On Thu, Oct 3, 2013 at 2:20 PM

$$Excel-Macros$$ Re: export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote: > > With ActiveSheet.QueryTables.Add(Connection:= _ > > "URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=FI3039"; > , Destination:=Range( _ > "$A$1")) > .FieldNames = True

$$Excel-Macros$$ Re: export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote: > > With ActiveSheet.QueryTables.Add(Connection:= _ > > "URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=FI3039"; > , Destination:=Range( _ > "$A$1")) > .FieldNames = True

Re: $$Excel-Macros$$ Re: total Fridays in a range

2013-10-03 Thread ashish koul
do you want to sum all the values of Fridays of each month On Wed, Oct 2, 2013 at 6:09 PM, wrote: > > > On Tuesday, October 1, 2013 10:18:15 PM UTC+8, asd...@gmail.com wrote: >> >> vba returns total Fridays in A2:A6. If A2:A6 all are Fridays. The value >> should be 5. >> > > Plse refer to the

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread ashish koul
try something like this "URL; https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id="; & Sheet1.Range("H1").Value, Destination:=Range( "A1") On Thu, Oct 3, 2013 at 2:20 PM, wrote: > original link : > https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistor

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-10-03 Thread ashish koul
have you tried the code which i shared On Thu, Oct 3, 2013 at 1:34 PM, Nasir Khan wrote: > Dear Ashish, > Thanks for the code. > My requirement is to import all the word tables from all the sub-folder in > the given path. > I got the following code from the net which obviously is not working. >

Re: $$Excel-Macros$$ Min based on condtions

2013-10-03 Thread ashish koul
if data is sorted then u can use index match On Thu, Oct 3, 2013 at 5:51 PM, Chandra Shekar wrote: > Hello, > > Is there any other way to get this other than Min & If conditions. > > Regards, > > Chandra > > On Thu, Oct 3, 2013 at 3:14 PM, Ravinder wrote: > >> =MIN(IF($B$2:$B$10=C2,$A$2:$A$10)

Re: $$Excel-Macros$$ Using Userform as Navigation Pane to move between worksheets

2013-10-03 Thread ashish koul
to avoid typing in combobox On Thu, Oct 3, 2013 at 12:27 AM, Bipin Singh wrote: > Hello Ashish, > > May I ask you the use of ComboBox1_KeyDown and ComboBox1_KeyPress event in > provided solution if *Userform.show* is already inside worksheet change > event.. > > Thanks in advance. > > Thanks, >

Re: $$Excel-Macros$$ Inserting BMP (Bitmap) Images Into A Predefined Cell Size

2013-10-03 Thread ashish koul
try this Sub test() ActiveSheet.Pictures.Insert ("C:\Users\admin\Desktop\Excel Tips & Tricks\01.jpg") With ActiveSheet.Shapes(ActiveSheet.Shapes.Count) .LockAspectRatio = False .Left = Range("a1").Left .Top = Range("a1").Left .Width = 180 .Height = 180 End With End Sub On

Re: $$Excel-Macros$$ Min based on condtions

2013-10-03 Thread Chandra Shekar
Hello, Is there any other way to get this other than Min & If conditions. Regards, Chandra On Thu, Oct 3, 2013 at 3:14 PM, Ravinder wrote: > =MIN(IF($B$2:$B$10=C2,$A$2:$A$10)) > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chan

RE: $$Excel-Macros$$ Min based on condtions

2013-10-03 Thread Ravinder
=MIN(IF($B$2:$B$10=C2,$A$2:$A$10)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Tuesday, October 01, 2013 7:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Min based on condtions Hello, am trying to get lo

$$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
original link : https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id= FI3039 With ActiveSheet.QueryTables.Add(Connection:= _ "URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=Sheet1.Range("H1").Value", Destination:=Range( "A1"))

Re: $$Excel-Macros$$ Help required in formula.....

2013-10-03 Thread Indrajit $nai
Hey, Ravinder it's really great, thanks bro. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby noti

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2013-10-03 Thread Nasir Khan
Dear Ashish, Thanks for the code. My requirement is to import all the word tables from all the sub-folder in the given path. I got the following code from the net which obviously is not working. Sub DoItNow() Dim file Dim path As String ' the path to the folder ' make SURE you include the terminat

RE: $$Excel-Macros$$ Help required in formula.....

2013-10-03 Thread Ravinder
Actullay its fuction u have to use as Excel formulas type =sumup(b2) and drag From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: Thursday, October 03, 2013 1:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help requi

Re: $$Excel-Macros$$ Help required in formula.....

2013-10-03 Thread Indrajit $nai
Unable to run the macro, kindly assist. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified th

$$Excel-Macros$$ Need Excel Test

2013-10-03 Thread sriram ji
Dear Excel Guru's, I need a excel test for interview purpose, anyone can provide the excel test.. Thanks in advance . Thanks & Regards, Sriram . G (Chennai) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

RE: $$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-03 Thread Ravinder
PFA, I think u r looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashwani agnihotri Sent: Wednesday, October 02, 2013 7:20 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query on Dashboard(urgent) Hi All, I have attac