$$Excel-Macros$$ Embed Picture in particular cell

2013-08-28 Thread Waseem Saifi
Dear Experts, Is it possible to embed picture as background in specific cell in Excel? Regards, Waseem Saifi -- 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 forum @ https://www.facebook.com/discussexcel

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread Zibraan
Yes sir, This what exactly what I wanted thanks a lot sirji, one more help needed. How can we conditional format the row on which we have national holidays. Thanks Once again. On Wed, Aug 28, 2013 at 11:07 PM, Deepak Barnwal wrote: > Dear Zibran > > PFA solution. > > Deepak > > > On Wed, Aug

Re: $$Excel-Macros$$ Re: Delete File Contents

2013-08-28 Thread pankajinfo
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 contents and automa

Re: $$Excel-Macros$$ Output Requier in Vertical

2013-08-28 Thread Prafull Jadhav
Got it Sir. Thanks a lot. On 29-Aug-2013 9:56 AM, "xlstime" wrote: > Firstly try your self to run one by one line using F8(function key) > > Range("a2:a15").Cells(K, 1) > > cells(k,1) - "K" count no of active cells in row > > "K" value remains same till "K" count = count no of active cells in r

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

2013-08-28 Thread xlstime
can try please try little two or three steps Just press Alt+T+I for Add-ins in "Add-in available list" check your installed add-in is exist or not if yes exist then try to remove and reinstall For remove or delete add-in just double click on add-in . Enjoy Team XLS

Re: $$Excel-Macros$$ Output Requier in Vertical

2013-08-28 Thread xlstime
Firstly try your self to run one by one line using F8(function key) Range("a2:a15").Cells(K, 1) cells(k,1) - "K" count no of active cells in row "K" value remains same till "K" count = count no of active cells in row and its hold range("a2:a15")'s value . Enjoy Team

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

2013-08-28 Thread Lalit Mohan Pandey
Please check hope this is what you are looking for: Option Explicit Sub RemoveData() Dim wbkFile As Workbook Dim vararrDataToRemove()As Variant Dim lngLoop As Long Dim rngData As R

Re: $$Excel-Macros$$ Output Requier in Vertical

2013-08-28 Thread Prafull Jadhav
Dear Sir, Plesae explain the for my information. Range("a2:a15").Cells(K, 1) out would be like ABDE.continue but how it come AABCCDDDEEFHHHIIJKLLMN Please explain. It working very fine as per my desire output On Wed, Aug 28, 2013 at 10:53 AM, Prafull Jadhav wrot

$$Excel-Macros$$ Re: VBA getting data from web site

2013-08-28 Thread Lalit Mohan Pandey
Yes you can download data but only thing you need to do is to arrange data in excel file by using excel vba. :) On Wednesday, 28 August 2013 18:59:19 UTC+5:30, Mithun Dhar wrote: > > I am trying to import data from IE sharepoint web site. The sharepoint > website just contains one table with hea

Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

2013-08-28 Thread svenyarl
I have done a little work on my own and have a portion of it done. I can now automatically perform a vlookup against the parts listing by selecting the column the parts are located in and starting my macro. The code I used to do this is as follows: Selection.Insert Shift:=xlToRight, CopyOri

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

2013-08-28 Thread Divaker Pandey
Sorry I can't send original file, but i am sending you a sample. On Wed, Aug 28, 2013 at 10:40 PM, xlstime wrote: > I > think it's not possible, can u please share addin if possible? > > you can protect you code > > . > > Enjoy > Team XLS > > > > On Wed, Aug 28, 2013 a

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

2013-08-28 Thread xlstime
I think it's not possible, can u please share addin if possible? you can protect you code . Enjoy Team XLS On Wed, Aug 28, 2013 at 9:53 PM, Divaker Pandey wrote: > thanks for reply, > > if user machine had installed and used same add in. then why this problem > re

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

2013-08-28 Thread Divaker Pandey
thanks for reply, if user machine had installed and used same add in. then why this problem remains.? I can't send code with excel file. is there another way to solve out this problem? Thanks Divaker On Wed, Aug 28, 2013 at 9:21 PM, xlstime wrote: > because the addin is installed in your sy

Re: $$Excel-Macros$$ VBA getting data from web site

2013-08-28 Thread xlstime
you can try "data import from web" j ust press alt+a+fw . Enjoy Team XLS On Wed, Aug 28, 2013 at 6:59 PM, Mithun Dhar wrote: > I am trying to import data from IE sharepoint web site. The sharepoint > website just contains one table with headings and data. If I go

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

2013-08-28 Thread xlstime
because the addin is installed in your system.. thats why another user get convert formula to addin path suggestion/solution :- you can paste your addin code in your workbook so thats no need for addin . Enjoy Team XLS On Wed, Aug 28, 2013 at 9:13 PM, Divaker Pandey w

$$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

2013-08-28 Thread Divaker Pandey
I have created some functions and created an excel addin(This addin is extracting data from other applications). This create a problem as , if one user send the file to other users ,the formula that I have written gets converted and include the path where I had saved the addin. they have to redef

$$Excel-Macros$$ VBA getting data from web site

2013-08-28 Thread Mithun Dhar
I am trying to import data from IE sharepoint web site. The sharepoint website just contains one table with headings and data. If I go to the developers tools, I can see the contents of data under the Class Name. Is it possible to download those data into excel? -- Are you =EXP(E:RT) or =NOT(E

$$Excel-Macros$$ Open Attached XL Files directly from Email

2013-08-28 Thread noodnutt
Hi all Someone asked me an interesting question ( Subject Header ). I know and use Excel to send emails but have never considered if, at all possible pointing to a specific email and automatically opening, copying and pasting a range of data then close said email attachment without ever havi

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread Zibraan
Actually I want to show L whichever dates I have taken leave. But it should be automated by formula so that I just need to enter the dates in the sheet named "Database" and it will automatically highlights those dates in red in sheet "Summary" and the previous leave dates would be available with m

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread ravinder negi
pls advise where you want answer and what exactly. From: Zibraan To: excel-macros@googlegroups.com Sent: Wednesday, August 28, 2013 11:41 AM Subject: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating Hi Team, Awaited for y

$$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-28 Thread Rajender Soni
Dear Chaya Try Alt + F11 to view the code screen. Regards, Rajender Soni | +91 750 322 55 50 -- 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 forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Us