$$Excel-Macros$$ Re: support

2012-08-13 Thread jayendra gaurav
pls support me On Tue, Aug 7, 2012 at 5:36 PM, jayendra gaurav jayendra.gau...@gmail.comwrote: 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 -- J.Gaurav

Re: $$Excel-Macros$$ Re: support

2012-08-13 Thread David Grugeon
I do not understand the question. Are you saying you want one icon on your desktop and all your excel files will open? Or are you saying you want all the icons for excel workbooks to look the same? Where do you want the icon or icons to be? How is what you have at the moment different from what

$$Excel-Macros$$ FW: Join request for MS EXCEL AND VBA MACROS [{ENLaooEF--yUGE3Irl00}]

2012-08-13 Thread Azeem Quraishi (HAB5)
From: MS EXCEL AND VBA MACROS [mailto:excel-macros+subconf...@googlegroups.com] Sent: Monday, August 13, 2012 11:32 AM To: Azeem Quraishi (HAB5) Subject: Join request for MS EXCEL AND VBA MACROS [{ENLaooEF--yUGE3Irl00}] We received your request to join excel-macros

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

2012-08-13 Thread Shekhar Sharma
Hi David, A sample file has been shared with you Regards Shekhar Sharma On Wed, Aug 8, 2012 at 4:45 PM, David Grugeon da...@grugeon.com.au wrote: Post a sheet with a sample of the data (at least 20 rows). then we can test our formulae. On 8 August 2012 20:35, Shekhar Sharma

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

2012-08-13 Thread Sundarvelan N
Hello Friends, Some how i finished my project. Last one help to finish my project. My task is after i passedcorssed the cell C17 the cursor should go to update button, please help me as soon as possible. Thanks N.Sundarvelan 9600160150 On Sat, Aug 11, 2012 at 4:02 PM, David Grugeon

Re: $$Excel-Macros$$ Re: Sorting v-look up issue - reg.

2012-08-13 Thread Ashish Pradhan
Hi Very Limited Knowledge of Excel as compared to most others. I use Excel 2003. What I did was to add another column with the formula =text(C2,) C2 is the date column. (I converted 05.04.2012 into a proper date format first). The above formula gave me a month like April. Then used the

Re: $$Excel-Macros$$ Re: Sorting v-look up issue - reg.

2012-08-13 Thread Ashish Pradhan
Hi Very Limited Knowledge of Excel as compared to most others. I use Excel 2003. What I did was to add another column with the formula =text(C2,) C2 is the date column. (I converted 05.04.2012 into a proper date format first). The above formula gave me a month like April. Then used the

Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button

2012-08-13 Thread Sundarvelan N
Dear Friends, Please help me, after i updated the cell C17 the cursor should go to the update button so that i dont use mouse to update please please help me Thanks N.Sundarvelan 9600160150 On Mon, Aug 13, 2012 at 3:46 PM, Sundarvelan N nsund...@gmail.com wrote: Hello Friends, Some how i

$$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay
Hi Friends, Please help me on issue below. *Issue :-* I need such excel file which can automatically stored login time with date and logout time so that I could able to analysis for how much time my computer was switched on/in use. For example, If I login by the time *7:00:00 AM* and logout on

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
This is going to be a tough one. It involves access to the Windows environment. I REALLY hope someone has an alternative, but I think you're going to have to write some  VBscript files that run at Windows Login and Logout that will make entries to a log file.   Paul

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread David Grugeon
Magnesh and Paul I think you could put an excel file (or a shortcut to one), in the startup folder. have an on open macro in the sheet to record the opening time. Then have a before close macro to record the time and save itself. My only concern would be whether Windows kills excel before the

$$Excel-Macros$$ Power pivot

2012-08-13 Thread rekha siri
hi Team, Please share if anyone is having PPT tutorial on Power pivot, usuage of sparklines/slicer in Excel 2010. Thanks, Rekha -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

2012-08-13 Thread dguillett1
Sub namechart() For Each c In ActiveSheet.ChartObjects c.Name = InputBox(Change the chart name c.Name) Next c End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Monday, August 13, 2012 1:58 AM To: excel-macros@googlegroups.com

$$Excel-Macros$$ Re: What is the future of VBA?

2012-08-13 Thread Kishan Reddy, K
Comparing to Programming languages, application packages do have a long life. Still, why do you worry, about the future of VBA. Softwares are born, evolve become obsolete over a period of time. But software concepts, which have deep foundation in physical sciences mathematics do have a long

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
I've worked through quite a bit of this. Spent MANY hours trying to work it out. There's LOTS of things to consider. #1.. is this for personal use, or for many people in an office? 1a)  If it is an office, is there an I.T. department that controls PC and Windows configuration? Windows has a

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

2012-08-13 Thread Kishan Reddy, K
One way is to display every value on x axis. But this will work only for limited values on x. Means your date range is below 20 or 30. Here you have to format the x axis. Select the scale tab. set the minor unit = 1 and major unit = 1. Another way is to display the max date above or some

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay
Hi Paul/Friends, I would like to use this concept for my personal computer. I knew very well that It is going to be tough job but as many experts are part of this group, I hope someone would definitely try to get answer. Let me know if you need more information on same. Please find the attached

Re: $$Excel-Macros$$ Need your help

2012-08-13 Thread Paul Schreiner
I have a solution that I use. I place most of the files in network locations, so they are backed up regularly. Where necessary, SHORCUTS are created to utilize these files. It has some limitations, since I could not use the Group Policy approach (thank you I.T.) It consists of (4) files.

$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis

2012-08-13 Thread Prince Dubey
Hi Divaker, Can you plz share ur work book with group. regards prince On Thursday, 9 August 2012 19:17:50 UTC+5:30, Divaker Pandey wrote: Hi Expert, can any one help me to show last available date in chart -xaxis range. Divaker -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ Power pivot

2012-08-13 Thread ashish koul
http://msdn.microsoft.com/en-us/library/office/gg619397.aspx http://www.gaelduhamel.com/tag/power-pivot/ http://msdn.microsoft.com/en-us/LIBRary/gg670985 On Mon, Aug 13, 2012 at 6:55 PM, rekha siri rekha.siri2...@gmail.comwrote: hi Team, Please share if anyone is having PPT tutorial on

RE: $$Excel-Macros$$ Power pivot

2012-08-13 Thread Rajan_Verma
Noorain bhai, She is asking about Power pivot. Not power point. If you have some material on Power pivot , would be helpful . Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 13

$$Excel-Macros$$ Re: Rek : Need CRM Administrator (Salesforce)

2012-08-13 Thread Prince Dubey
Hi Ayush Pls ban this user. On Monday, 13 August 2012 21:48:23 UTC+5:30, sudheer sudheer wrote: *Hi* *Need* *Role: CRM Administrator (Sales force)* *Duration: 1 Year* *Location: Austin, TX* *Job Specific * *Job Specific Required education experience* · High School diploma

$$Excel-Macros$$ macro for detecting date in row

2012-08-13 Thread pawel lupinski
Hi All, I'd like to have a macro that will detect curent date (eg in column H) then copy all all columns from A to column H (column H excuded so range A:G) and paste all these column as value Thanks Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

$$Excel-Macros$$ I need help on a macro which extracts rows which have a 7 digit number in a column.

2012-08-13 Thread Radhika
For ex i have thousands of records in which one col has 7 digit number in many rows. I need to extract only rows having that 7 digit number. That number has digits 0-9. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

2012-08-13 Thread amar takale
Dear Guillett Sir I am confused about this code,I put this code but what changes in sheet,I am not under stand.Pls in attached sheet solved problem if possible.I think in to cell from date Last date input through data validation when I change range date then update chart between that date range.