$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

Dear Ashish I too have similar problem as Mr. Upendra had. Let me tell you how i installed. The mistake i did, i guess, is i ran the setup without unzipping the zip file. some message like runtime error, load not complete appeared. Am trying to unload and load it afresh but i am not able to

$$Excel-Macros$$ Re: Sorting Values

Hi Ashish Thanks Unfortunatily i got this formula from you thanks from 3-4 days i try to finding this formula once again thanks. i appreciate you will be help me in future thanks On Tue, Apr 28, 2009 at 8:43 PM, Ashish Jain 26may.1...@gmail.com wrote: Hi Savant, Try this

$$Excel-Macros$$ Re: Use VBA to determine Windows Groups permissions for a folder

Hi, Take a look at the following links... http://www.15seconds.com/issue/020130.htm http://www.computerperformance.co.uk/vbscript/wmi.htm I am still not very clear about what exactly your are trying to do. That is may be because I personally haven't done this before. Still I would like to

$$Excel-Macros$$ Regarding Open Xl

Dear All, I have successfully installed open xl in my system but it is not showing in my excel 2007. i am facing the same problem like exactly like satish. Please guide us for how to solve the issue. Regards, Abdul Hakim Khan --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

Hi Satish, I think you have not installed .Net Framework 3.5 and VSTO 3.0 Runtime. I have installed these Pre-requisites and my installation completes. Regards, Upendra Singh 9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of

$$Excel-Macros$$ Re: Help with creating a unique set of numbers

Hi Grunta, The result will change every time you do an activity in excel like. typing in data, or inserting rows / columns etc. Best way to avoid it would be do copy - paste - special - values on the cells / numbers which are used up. Further to this, if you want that the data which is used

$$Excel-Macros$$ Re: Help with creating a unique set of numbers

Because I use VBA for just about everything, my approach is a bit more involved... What I would suggest is to create a Worksheet_Change event: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range)     Dim I, Col_Name, Col_Pin     Col_Name = 1 'Column to monitor for content    

$$Excel-Macros$$ Re: Use VBA to determine Windows Groups permissions for a folder

I'd be glad to elaborate. I have several network shared folders (over 500) IN ALL CASES, SUB-FOLDERS INHERIT ATTRIBUTES FROM THE TOP-LEVEL FOLDER Each folder is owned by someone (over 150 separate owners) Every 6 months, each owner is presented with a list of users that have access to their

$$Excel-Macros$$ Display of Time in Pacific Standard Time (PST) and Central Standard Time (CST)

Hello Everyone, I have a problem while displaying Time in Pacific Standard Time and Central Standard Time. I get the data in PST. Can anyone wirte a VBA Code, so that in the same box, i should get the Time for both PST and CST? Please help. For reference, CST = PST + 2 hrs. Below is the

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

Hi Upendra How to install these .Net Framework 3.5 and VSTO 3.0 runtime ? On Wed, Apr 29, 2009 at 12:37 PM, Upendra Singh upendrasinghsen...@gmail.com wrote: Hi Satish, I think you have not installed .Net Framework 3.5 and VSTO 3.0 Runtime. I have installed these Pre-requisites and my

$$Excel-Macros$$ Re: Display of Time in Pacific Standard Time (PST) and Central Standard Time (CST)

Hi, I'm new to this group and trying my hand at Excel VBA. Do you really need a macro for the below, i.e., to depict CST PST? According to me a simpler work around would be, say, Column A Column B Row 1PST CST

$$Excel-Macros$$ VBA Trading Spreadsheet

Dear all: I am working on a stock trading project. The spreadsheet downloads data and makes buy or sell orders based on prices. I receive the following data from Reuters directly into an excel worksheet called Data.xls: 1. Symbol 2. Date 3. Time 4. Volume 5. Tick 6. Open Price 7. High Price 8.

$$Excel-Macros$$ Re: Use VBA to determine Windows Groups permissions for a folder

Thanks, This is great. Give me a couple of days to work on this. Regards Ajit From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Paul Schreiner Sent: Wednesday, April 29, 2009 5:49 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

$$Excel-Macros$$ Code Reuse - Logging Actions When a Cell Changes

Hi all, I am trying to use following codes for a add-in utility so that user can enable or disable logging activity for a given workbook. My problem is to how to add the following code to a new workbook so that Loginfo function could be activated. I have tried some application... based commands

$$Excel-Macros$$ Dynamic range for pivot table

I am trying to create a pivot table on a new sheet names as 4x4 I am getting following error: Error : 1004 Reference Not Valid I am not sure where is the problem. I have genererated this code by using macro recorder and just changed the source and destination of the pivot generation code. Need

$$Excel-Macros$$ Consolidate Macro

Hi group. Could someone help me with shortening the below Macro. Basically I want to hide rows that start with the number 3 and goes to 18 or higher, and you can see below how I did it the long way. Is there a way I could have an input box popup that would ask me the # of rows that I want

$$Excel-Macros$$ Re: Consolidate Macro

I'm not sure if I understand how you're determining rows that start with the number 3 and goes to 18 or higher What does start with number 3 mean? is the cell in column A a number? Is it always the same as the row number? or are you saying you want to hide rows that have the number 3,

$$Excel-Macros$$ Re: Dynamic range for pivot table

Hi I think the problem is that you are enclosing rng within quotes as your Source data. Try removing the quotes and it should work. ActiveWorkbook.PivotCaches. Create(SourceType:=xlDatabase, SourceData:= rng, Regards Roger Govier Microsoft Excel MVP 2009/4/29 Govind Kedia webbu...@gmail.com

$$Excel-Macros$$ Re: Consolidate Macro

Paul, Thanks for the response. In the spreadsheet, there is a number holder for a name to be added later. It's because we have so many linked files and we add rows for future additions to the model. So, there are probably 20 instances where I have rows that go from 3 to 18 and instead of going

$$Excel-Macros$$ Re: Reminder workbook

Hi All, Reminder in xl a popup message box appear on a particular date was really a good idea but if i had more than 1 reminder on the same day than i am not able to view the other reminder in that message box or in popup window. Please Help Thanks Regards, Sudhir. On Mar 17, 8:56 pm, Ajay

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

Hi The formula is saying If the value in cell C8 is not equal to the value in cell C7, then return the value of 1, otherwise, return the value of 0. Regards Roger Govier Microsoft Excel MVP 2009/4/27 Ahmedhonest ahmedhon...@gmail.com Dear Fabio Lemos, I appreciate your solution to the Query

$$Excel-Macros$$ Re: Reminder workbook

Hi All, Reminder in xl a popup message box appear on a particular date was really a good idea but if i had more than 1 reminder on the same day than i am not able to view the other reminder in that message box or in popup window. Please Help Thanks Regards, Sudhir. On Tue, Mar 17, 2009 at

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

Hi Ahmed An IF statement has the following: Firstly, the condition. Secondly, the result if the condition is met. Thirdly, the result if the condition is not met. Each of the above is separated by commas, so it looks like this: IF(Condition, Result if met, Result if not met) In your