Re: $$Excel-Macros$$ Need to count blank cells with CountIF formula

2011-04-01 Thread Harpreet Singh Gujral
Hi Guys, I dont know if this would be a good enough suggestion to be considered by all the members of the Group. According to my experience, most of the users still use Excel 2003 and they are not able to open files made in Excel 2007. Would it be a good idea to share files of the Excel 2003 vers

Re: $$Excel-Macros$$ LIFE TIME DIARY

2010-09-13 Thread Harpreet Singh Gujral
This looks like an amasing piece of work Harpreet Gujral -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

$$Excel-Macros$$ Re: vba programming

2010-06-13 Thread Harpreet Singh Gujral
Hi Airen, Would you be able to explain the following, so that the group can help you out: 1) Is there a criteria, you want to use, on the table on Sheet1. Because this criteria, will be embeded in the check box...or please tell us, what do you want to achieve with the checkbox, that you have

Re: $$Excel-Macros$$ Re: popup on s sheet ?

2010-06-11 Thread Harpreet Singh Gujral
Swapnil, One more thing, is it possible to know the cordinates, of where the chart is located on the sheet and is it also possible to place the chart according to our needs on the sheet? Cheers Harry On Jun 12, 8:23 am, Harpreet Singh Gujral wrote: > Swapnil, > > Thanks alot for th

$$Excel-Macros$$ Re: Deleting Empty Rows

2010-06-11 Thread Harpreet Singh Gujral
Hi Iqbal, I hope the following would be helpful, i have copied the code from the internet: (Before running the macro select the range of rows, you want the macro to evaluate) Sub DeleteBlankRows1() 'Deletes the entire row within the selection if the ENTIRE row contains no data. 'We use Long i

Re: $$Excel-Macros$$ Re: popup on s sheet ?

2010-06-11 Thread Harpreet Singh Gujral
from list. > > I know my English is poor. But I hope you got the answer to your questions. > > Regards, > > Swapnil. > > On Fri, Jun 11, 2010 at 7:43 AM, Harpreet Singh Gujral < > > > > harpreetguj...@gmail.com> wrote: > > Hi Swapnil, > > > M

Re: $$Excel-Macros$$ Re: popup on s sheet ?

2010-06-10 Thread Harpreet Singh Gujral
; Thats it. > > > > On Wed, Jun 9, 2010 at 10:11 AM, L.K. Modi wrote: > > Dear Sir > > May i know how u do this step by step.I am a great fan of this group. > > because in the sample sheet i m unable to know the process.Hope i will get > > answer shortly > >

$$Excel-Macros$$ Re: Delete rows based on duplicate and cell color

2010-06-08 Thread Harpreet Singh Gujral
Jason, There can be a way to automate end-to-end, of what the employees are doing or may be to some extent atleast Can you send a sample sheet to the group People will be able to help you a bit faster by looking at it Cheers Harry On Jun 8, 4:59 pm, JsinSk wrote: > Hello All, > > At my workp

Re: $$Excel-Macros$$ Re: popup on s sheet ?

2010-06-08 Thread Harpreet Singh Gujral
Swapnil, Your post is an amsing one. Thanks Alfred, There are two things to the solution provided by Swapnil, 1) There is a label on the sheet1 2) There is data on the sheet which makes the graph If you go into design mode of excel and click over the data, you will be able to select a invisib

Re: $$Excel-Macros$$ Reminder in Excel

2010-06-07 Thread Harpreet Singh Gujral
Kuldeep, Can you attach the file, with the data, then may be somebody will be able to help you soon Harry :) On Jun 7, 9:22 am, "Kuldeep Vashishtha" wrote: > Hello Group, > > I am looking for a Macro / Option / Command, Whenever open a particular file > then excel show me long pending Document

$$Excel-Macros$$ Re: merging worksheet.

2010-06-06 Thread Harpreet Singh Gujral
Prashant, Thanks for sharing this, i must say its an amasing post.. Harry On Jun 5, 10:53 pm, Prashant Pednekar wrote: > Hi all > > received the macro on below link..giving this for your referance. > > http://www.mrexcel.com/archive/VBA/17846.html > > Posted by Damon Ostrander on January 25

Re: $$Excel-Macros$$ Damage Files

2010-06-06 Thread Harpreet Singh Gujral
Nand Kumar, Would you like to share with the group, "How one can retrieve a damaged file?" Harry On May 31, 9:24 am, Nandkumar kakvipure wrote: > On Sun, May 30, 2010 at 12:25 PM, Harpreet Singh Gujral < > > > > harpreetguj...@gmail.com> wrote: > > Siv

$$Excel-Macros$$ Re: Dashboard designs

2010-06-06 Thread Harpreet Singh Gujral
Group, Any suggestions with regards to this Harry On Jun 1, 5:27 pm, Harpreet Singh Gujral wrote: > Hi Group, > > I am a novice in VBA, is there ne source or website from where i can get an > idea of dashboard designsi.e., if i can have a look at some of the > dashboar

$$Excel-Macros$$ Re: Is it possible to prevent a user changing the name of a sheet?

2010-06-06 Thread Harpreet Singh Gujral
wrote: > Thanks, Harry. I'll have a look into that. Actually I've discovered > that if you protect the workbook, renaming of the sheets becomes > disabled. > > On Jun 6, 6:13 am, Harpreet Singh Gujral > wrote: > > > > > Jerry, > > > Two ways, if

$$Excel-Macros$$ Re: Excel Macro Help : Ambiguous name detected :

2010-06-05 Thread Harpreet Singh Gujral
Hi, Could be a case, that you may not have created W028M macro in the modules Regards Harry On Jun 2, 12:54 pm, Sundarvelan N wrote: > Hi Friends, > > Please help me to solve the below issue. > > While i try to use the below code it says "Ambiguous name detected :W028M" > > Private Sub Command

$$Excel-Macros$$ Re: Is it possible to prevent a user changing the name of a sheet?

2010-06-05 Thread Harpreet Singh Gujral
Jerry, Two ways, if adopted can help protect the sheet the way you want to: 1) Code should be used to hide, Renaming sheet option on the worksheet menu bar i.e. going to Format ---> Sheets-> Rename 2) On worksheet_deactivate event can be used to rename the sheet back to the same name it was

$$Excel-Macros$$ Dashboard designs

2010-06-01 Thread Harpreet Singh Gujral
Hi Group, I am a novice in VBA, is there ne source or website from where i can get an idea of dashboard designsi.e., if i can have a look at some of the dashboards, it helps to design one Harry -- -- Some import

$$Excel-Macros$$ Re: How to lock a worksheet based on the date?

2010-05-31 Thread Harpreet Singh Gujral
Hugo, Using, Auto_open() sub will be helpful in this regard, If you save the date in a cell on the wroksheet, and create a if condition in Auto_open procedure, that will help to validate your condition IT would be something like: 1) Save a date in Cell A1 2) Create a sub procedure in the module

$$Excel-Macros$$ Re: Automatic Detail Summary

2010-05-31 Thread Harpreet Singh Gujral
I think, using advance filter to filter data and then making use of it would be useful Harry On May 31, 10:14 am, SLF wrote: > Hello all! > > I am building a complex spreadsheet to track 2 weeks of payroll and > projects.  It needs to be a completely automatic document that can > calculate every

$$Excel-Macros$$ Re: Excel Group Survey : Please participate.

2010-05-31 Thread Harpreet Singh Gujral
My question is the same, I only check the mails i receive from the group.. I have cheked the first option in ques no 8, as there was no other option, if someone is not visiting other communities Harry On May 31, 10:53 am, Stuart Redmann wrote: > On 30 Mai, 17:55, ayush jain wrote: > > > >

$$Excel-Macros$$ Re: Excel Date Pass/Fail problem

2010-05-31 Thread Harpreet Singh Gujral
Jon, I hope the following will be helpful Assuming, data is in row 5 of the sheet, with Received date in Column A and Delivery date in Column B, you can paste the following formula in Column C i.e. C5 =IF(WEEKDAY(A5,2)<5,IF(B5-A5<=1,"Pass","Fail"),IF(B5- A5-2<1,"Pass","Fail")) I have taken the

Re: $$Excel-Macros$$ Damage Files

2010-05-29 Thread Harpreet Singh Gujral
Siva, Would you like to share your knowledge on how to recover a damaged file wit the group Thanks in advance Harry On May 28, 10:34 am, Siva Kumar Vemula wrote: > hi, > > please find attached recovered file with some data lost. > > regards, > siva > > On 5/27/10, Parag Dafal wrote: > > > > >

$$Excel-Macros$$ Convert 2007 to 2003

2010-05-29 Thread Harpreet Singh Gujral
Hi Group, Please suggest a software to convert an excel 2007 file to excel 2003 version Alternative which is free to use :) Thanks Harry -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ Re: Hi!!!!!!!!! to all Member

2010-05-29 Thread Harpreet Singh Gujral
I also faced the same issue, As of now, if i need to reply to a post, i copy the subject of the post and then set it as a subject of my email to the group, and within that email i attach the files(if any) If there is any other way to attach files to the replies, please let us know Harry On May

$$Excel-Macros$$ Re: New to the group - basic question

2010-05-29 Thread Harpreet Singh Gujral
Hi, What it is doing is, mathmatically it may look like as follows: = 18.25/(1-.65) which is again equal to =18.25/0.35 Oh, i think your formula wants to achieve this 1) Lets assume a figure as X, while the figure 18.25 is 35% of X, in order to know what the figure X is, you will apply the form

$$Excel-Macros$$ Re: SendTo

2010-05-27 Thread Harpreet Singh Gujral
PWS, Can you share, how we can not allow the user to save the workbook and not even allow him to email the workbook Please advise Harry On May 26, 8:04 pm, PWS wrote: > I have a workbook which I have written code which will not allow the > user to save the workbook unless they have provided sp

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-24 Thread Harpreet Singh Gujral
I have a mixed feeling about posting Job openings to this group, on one hand i would agree with Paul that, the core idea of the group may be defeated in the long run. I think a related group can be started, where in those who are core VBA programmers or simply programmers can join and post job ope

Re: $$Excel-Macros$$ Excel Daily Tip : Save Workspace

2010-05-18 Thread Harpreet Singh Gujral
Thanks Ayush, Looks like an excellent idea, will try it today and post my reviews about the TIP Harry On May 18, 8:36 am, Ayush Jain wrote: > Ayush Jain has sent you a link to a blog: > > Dear group, Here is a wonderful tip: One can open a group of workbooks > in a single step by creating a wor

$$Excel-Macros$$ Ms-Excel Bible by john walkenbach

2010-05-14 Thread Harpreet Singh Gujral
Mr excel, Can you send the link for 2003 version Thanks Harry -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

Re: $$Excel-Macros$$-Macro to Prepare Letters

2010-05-11 Thread Harpreet Singh Gujral
Atul, So you mean, that you need to use different format of a letter, basis on some condition. Is that correct? If the answer is yes, please provide a condition on how you want to select a particular letter and mail it Harry On May 11, 3:54 pm, Atul Kesaria wrote: > Hello Team, > > Can some on

Re: $$Excel-Macros$$ Lookup problem

2010-05-11 Thread Harpreet Singh Gujral
Chandra, Please provide a excel 2003 version. I want to learn the solution for this problem Harry On May 11, 5:27 pm, Chandra Gupta wrote: > Hi > > Please find your attached solution. > > Thanks > > > > > > On Tue, May 11, 2010 at 4:04 PM, vinu wrote: > > Hello, > > > I have a data in two colu

Re: $$Excel-Macros$$ Ebook on Excel 2003 VBA

2010-05-07 Thread Harpreet Singh Gujral
Jaao Matoso, The link doesnt work Harry On May 7, 2:35 am, João Matoso wrote: > www.tudosobrexcell.com > > 2010/5/6 nagendra baral > > > > > > > Hi There > > > Please send some website links which can be helpful in learning Excel > > VBA and downloading Ebooks. > > > Thanks and Regards > > Nag

Re: $$Excel-Macros$$ Excel Bug ?

2010-05-07 Thread Harpreet Singh Gujral
Shyam: Good Catch OSA: Good Solution... Thanks to both, for sharing this Harry On May 7, 1:14 pm, OSA wrote: > Hi,  Because "?" is a special character set in computer, if you want to find > it you must prefix it with tilde in the find. ( ~?) > > http://support.microsoft.com/kb/214138 > > -

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

2010-05-06 Thread Harpreet Singh Gujral
Dvpetta, Can you upload a 2003 version, i may be able to give a thought on it CC me in, so that i know that you have uploaded the sheet Cheers Harry On May 4, 8:27 pm, dza7 wrote: > Hello, > > I have a challenging pivot table issue that I hope I can get some help > on. > > Here is the spreads

Re: $$Excel-Macros$$ Please help me

2010-05-04 Thread Harpreet Singh Gujral
Sidhantha, Is it possible for you to provide Excel 2003 version Harry On May 3, 4:33 pm, sidhantha suchit wrote: > hi > > attach one of the sheet and thereis 1000 of such kind of sheet were i have > to do this wrk please help me. > On Mon, May 3, 2010 at 9:36 AM, Rahul Gandhi. wrote: > > > > >

Re: $$Excel-Macros$$ Urgent Help

2010-05-04 Thread Harpreet Singh Gujral
older > *  rename protect folder name aaa  *and double click key.bat > file,,, > > On Sun, May 2, 2010 at 8:19 PM, Harpreet Singh Gujral < > > > > > > harpreetguj...@gmail.com> wrote: > > Hi Ashish/Jai/Group, > > > I am also looking fo

Re: $$Excel-Macros$$ Urgent Help

2010-05-02 Thread Harpreet Singh Gujral
Hi Ashish/Jai/Group, I am also looking for some kind of Folder protection program.. Please advise Cheers! Harry On May 2, 12:15 pm, ashish koul wrote: > try this it may help you > > 1. Go to the directory where your folder is in. > 2. Create a new notepad file and paste this without t

Re: $$Excel-Macros$$ Please help me

2010-05-02 Thread Harpreet Singh Gujral
Sidhantha, I can give it a try, as i am also studying some things related to Stock Market... Let me know Harry On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know it

$$Excel-Macros$$ Do No copy excel file or data from that file

2010-05-02 Thread Harpreet Singh Gujral
Hi Vijay, I think the following code will help to some extent. Private Sub Workbook_Open() Application.DisplayAlerts = False If Range("A1").Value <> "C:\Desktop\[Book2.xls]Sheet1" Then 'In the inverted please insert the location to chck MsgBox "Workbook was moved from the Original Location. Hence

Re: $$Excel-Macros$$ How to compare two Excel sheets

2010-05-01 Thread Harpreet Singh Gujral
Sudhir, I am sorry, but i did not get your point. Even if you add a row in between the data, it will analyse data upto Row 200/ or more if you plan to do so One presumption is that the data will not be repeated i.e. Compartment Name will not repeat. Let me know, if you face further problems Ha

Re: $$Excel-Macros$$ How to compare two Excel sheets

2010-04-30 Thread Harpreet Singh Gujral
Hi Sudhir, I hope the following code will help you out: "Public Sub Test() Dim W1 As Worksheet Dim W2 As Worksheet 'Change the filw name accordingly Set W1 = Workbooks("Old File.xls").Worksheets("Sheet1") Set W2 = Workbooks("Latest File.xls").Worksheets("Sheet1") For I = 2 To 200 Val1 = W2.Ce

Re: $$Excel-Macros$$ Help with Median Formula

2010-04-29 Thread Harpreet Singh Gujral
Hi Dilip/Group, Would you be able to throw some more light on "Array Functionality"? I was surprised how solution worked for Gopi. If you can tell us, what is the use of this functionality or which are the areas where we can use this type of functionality It would be a great learning for me Tha

Re: $$Excel-Macros$$ about change to range

2010-04-29 Thread Harpreet Singh Gujral
Thanks Paul Its a learning for me Harry On Apr 29, 8:39 pm, Paul Schreiner wrote: > Excel has special macros called "Event" macros. > > as the name implies, the macro runs whenever the "event" takes place. > > What you're looking for is the SelectionChange event. > > Now, depending on of you

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

2010-04-27 Thread Harpreet Singh Gujral
e is added, and which one is > changed. plz help me. > > Thanks. > > On Sun, Apr 25, 2010 at 9:58 AM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wrote: > >> Hi Sudhir, >> >> I think you are looking for "How to group rows and columns

Re: $$Excel-Macros$$ Finding cell address of a formula referred to in a cell

2010-04-26 Thread Harpreet Singh Gujral
tached Workbook have a solution,Regarding your Problem. > > Hope It Will Help > > On Sat, Apr 24, 2010 at 10:43 PM, Harpreet Singh Gujral > > > > > > wrote: > > > Hi Group, > > > I have a weird query today, i hope i am able to present the case and a > &

$$Excel-Macros$$ Re: Need help to complete a Excel Model.. Options

2010-04-26 Thread Harpreet Singh Gujral
this code. ie., before closing > workbook, it shd be protect the workbook by giving password"a" and save it > in desktop. So no one can access this without having password. > > > how do I attach this statemetn pls let me know. > > once again thanks a lot..!! >

$$Excel-Macros$$ Need help to complete a Excel Model.. Options

2010-04-25 Thread Harpreet Singh Gujral
(0, 0, 10), "CloseMe" End Sub -- Forwarded message -- From: Harpreet Singh Gujral Date: Sat, Apr 24, 2010 at 10:27 PM Subject: Need help to complete a Excel Model.. Options To: excel-macros@googlegroups.com Cc: vinu1sm...@gmail.com Hi Vinu, I looked at the link provided by you.

$$Excel-Macros$$ Finding cell address of a formula referred to in a cell

2010-04-24 Thread Harpreet Singh Gujral
Hi Group, I have a weird query today, i hope i am able to present the case and a solution is possible for it. I need to achieve the following: 1) A macro that will search the whole sheet for those cells which consists of formulas 2) And if a cell is found meeting criteria one, It needs to be ab

$$Excel-Macros$$ Need help to complete a Excel Model.. Options

2010-04-24 Thread Harpreet Singh Gujral
Hi Vinu, I looked at the link provided by you. I have attached a workbook with this email, i hope this resolves your problem. I have used the following code: Private Sub Workbook_Open() 'Advise the user the workbook will close if inactive for 10 seconds. 'To adjust the time, such as if you want

Re: $$Excel-Macros$$ Data mapping from one excel workbook to another excel workbook

2010-04-22 Thread Harpreet Singh Gujral
Hi Ramesh, I think it would be good idea to attach a sample file, Harry On Apr 22, 7:39 pm, Ramesh Katta wrote: > Hi Friends, > > I need to map data from one excel workbook to another excel workbook. > I need to open the source workbook then need to create new workbook > and some cells of data

Re: $$Excel-Macros$$ Re: Something is missing

2010-04-16 Thread Harpreet Singh Gujral
Totally agree, If excel has the feature, that it automatically checks, whichever cell has been changed, should be spell checked. But at the same time, it should have the feature to also disable it, because, Excel is used for a wide variety of Data Mining things, and if the feature cannot be diable

Re: $$Excel-Macros$$ Understanding & Implementation

2010-04-16 Thread Harpreet Singh Gujral
Hi Admins' ( I mean all the people who are running the show), I think its a great thought to formulise or standardise a way question is asked. As i have also experienced, and reading the thoughts of Paul, Ayush and Surya.etc, i also vet a similar thought that it becomes increasingly difficult

Re: $$Excel-Macros$$ Calling a Macro

2010-04-12 Thread Harpreet Singh Gujral
tton from Visual Basic Toolbar and not > from Forms Toolbar. Yes! both are different. :-) > > > Cheers! > > AJ > > > On Mon, Apr 12, 2010 at 8:16 AM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wrote: > >> Thanks everybody for your responses

Re: $$Excel-Macros$$ Calling a Macro

2010-04-11 Thread Harpreet Singh Gujral
Thanks everybody for your responses. The trouble is the most, when the subroutine is defined as Private Sub. Any solutions to this: Example2: Module1 has "test1" stored as a Private sub and i want to call this Sub in a Commandbutton created on Sheet1 Thanks Harry On Apr 11, 6:43 pm, rf123

$$Excel-Macros$$ Re: Modifying input data

2010-04-06 Thread Harpreet Singh Gujral
Paul, This is simply amasing...Thanks a ton Cheers!!! Harry On Apr 6, 10:54 pm, paulwillekens wrote: > Hi Harpreet, > > Here it comes... I made a new sheet "test" to test it, but you can > change that statement in > cCooked = "MODIFIED DATA" > after testing, of course. > > Feedback is

$$Excel-Macros$$ Re: Modifying input data

2010-04-06 Thread Harpreet Singh Gujral
Thanks Seema and Paul, for posting your reply to my problem. I am aware of the fuctionality to import data from text files. Seema: the file you have attached is the exact point from where i have my problem, i need to modify the input data from here. If you see at Column A: you will find the foll

$$Excel-Macros$$ VBA to detect drive

2010-04-04 Thread Harpreet Singh Gujral
Hi Gurus, *Would it be possible to have VBA code to detect, whether a drive is attached to the computer or not?* ** The idea is to achieve the following objectives: 1) To detect, removable Pen Drive/Hard drive has been attached with the computer or not? Eg: When i attach a pen drive on m

$$Excel-Macros$$ Re: 12 secret shortcuts of Excel

2010-04-02 Thread Harpreet Singh Gujral
ution provided. So i would say, "No doubt its the people who initiate, make the MOVEMENT, but its the participants who keep the MOVEMENT alive" -Harpreet Singh Gujral Only one word for the Group "Superb!" Thanks Harry [Proud member of the group] On Apr 2, 8:26 pm,

$$Excel-Macros$$ Re: Tip of The day:Extract Number FROM Alphanumeric String

2010-03-31 Thread Harpreet Singh Gujral
Shyam, "You are super hit", and this comment is something, which i am sure i can give on your every solution Keep posting such tips :) Harpreet Gujral On Mar 30, 5:23 pm, rf1234 rf1234 wrote: > Dear All, > Attached is the macro to extracting the numeric value from alphanumeric > string. >

$$Excel-Macros$$ Re: E Book "Excel 2007 Macros Made Easy by Gail Parry"

2010-03-28 Thread Harpreet Singh Gujral
Hemant, You can try uploading the file on Sendspace.com, its easy to use website and allows you to upload files and share it with other people Let me know when you upload the files on an alternate source, i will be happy to download them. Harry On Mar 26, 5:21 pm, Hemant K wrote: > Hi All, > >

$$Excel-Macros$$ Re: E Book "Excel 2007 Macros Made Easy by Gail Parry"

2010-03-27 Thread Harpreet Singh Gujral
Hi Hemant, Thanks for providing the source But i am unable to download the file, the download stops in between. Tried many times, would you be able to make available the file through some other source. Thanks Harry On Mar 26, 5:21 pm, Hemant K wrote: > Hi All, > > Here is the link for the fol

$$Excel-Macros$$ How to seaprate contents

2010-03-24 Thread Harpreet Singh Gujral
Hi Group, I have a cell that contains more than one email address, the idea is to seaprate them from one another through a loop. Example: Cell A1 has the following contents "xx...@yahoo.com, yy...@ymail.com, tt...@gmail.com" I want to make a loop which will seaprate each of the email address int

$$Excel-Macros$$ Re: VBA code to capture System time

2010-03-24 Thread Harpreet Singh Gujral
Hi Paul, I had once seen a sheet, which used forms to take input from the user, Plus: it also use to record the System lock time i.e. it would record it as breaks automatically. I am not sure, what was the macro using to feed itself with that data. Shyam: The person who submited the query, wants

$$Excel-Macros$$ Re: Share Tips and Tricks

2010-03-23 Thread Harpreet Singh Gujral
Hi Ayush, Looking at Sudhir's idea, i think it would be great to consolidate all the tips and tricks. But, i also buy in your point, that it would be difficult to keep the file updated. I have a suggestion, Would it be possible for you or the members of the group to follow a pattern for forwardin

$$Excel-Macros$$ Re: VBA code to capture System time

2010-03-23 Thread Harpreet Singh Gujral
Paul, I think SPS, wants to know, is there a way through which one can capture system time, at the time when the user locks his/her system i.e. in a networking environment, people usually press "Windows Key+L" in order to lock there workstations, before they leave there seat. I think SPS wants to

Re: $$Excel-Macros$$ Need macro to create a command button and also write the script of it

2010-03-21 Thread Harpreet Singh Gujral
Aj, Looks like a great solution for simran's problem. I have a question regarding a part of the code Sheets("Sample").Visible = True Sheets("Sample").Select Sheets("Sample").Copy After:=Worksheets(Worksheets.Count) Sheets("Sample (2)").Select Sheets("Sample (2)").Name = TextBo

Re: $$Excel-Macros$$ Re: Finding a diff b/w two time

2010-03-11 Thread Harpreet Singh Gujral
AJ, Thanks, this is exactly what i was looking for Thanks Harry On Mar 7, 10:53 pm, Abhishek Jain wrote: > Dear Harpreet, > > Check the sample file attached. Format used is - "[h]:mm" (without quotes). > > Cheers! > > AJ > > On Sun, Mar 7, 20

Re: $$Excel-Macros$$ A macro that closes and saves the open excel project

2010-03-11 Thread Harpreet Singh Gujral
Aj, I read the below attached code I have some questions about it, as i am keen to learn application.ontime event Why did we repeat the following line of code Application.OnTime TimeValue("20:20:00"), "Close_and_Save" in both Workbook_Open event and the Close_And_SAve sub? Is it important to do

$$Excel-Macros$$ Re: Need Help

2010-03-11 Thread Harpreet Singh Gujral
Hi Imran, I have followed the following logic: In Column G, i have entered a IF Statement, which will seek for Text in columns H to M, as soon as it finds and text in any of the first columns, that will be imitated in Column G Please see the attached file Thanks Harpreet Gujral On Mar 10, 12:5

Re: $$Excel-Macros$$ How to copy a range from another sheet

2010-03-08 Thread Harpreet Singh Gujral
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''&

$$Excel-Macros$$ Re: Make my code work continously

2010-03-07 Thread Harpreet Singh Gujral
Hi David, I think placing the code in the Worksheet change event would help. The event would be trigered as and when any cell on the sheet is changed, and in the event it would revisit all your conditions that are present in the code. Your code would look something like this. Private Sub Workshe

$$Excel-Macros$$ How to copy a range from another sheet

2010-03-07 Thread Harpreet Singh Gujral
Hi Group, I have to copy a range of cells from anotherworkbook to activeworkbook, without opening the workbook. Example: I have the activeworkbook present in C:\ Temp1\XXX\YYY\Book1.xls while the other workbook resides at the following C:\Temp2\XXX\YYY\Book2.xls I have to copy Contents of sheet2

$$Excel-Macros$$ Re: Finding a diff b/w two time

2010-03-07 Thread Harpreet Singh Gujral
, Ayush wrote: > Hi Harpreet, > > Simply you can use B1-A1 and change the time format to "1:00". It > should work. > Let us know if you have any further questions. > > Best regards, > Ayush Jain > > On Mar 6, 3:38 pm, Harpreet Singh Gujral > wrote: >

$$Excel-Macros$$ Finding a diff b/w two time

2010-03-06 Thread Harpreet Singh Gujral
Hi Group, I have the following question: I have two cells, both have the following formating. "DD/MM/ HH:MM". Suppose, CellA1 has time "11/12/2009 09:00" while cell B1 has the following value "11/12/2009 10:00". Can we find a diff in cell C1. The actual difference would be 1hr. Actually, wha

Re: $$Excel-Macros$$ Shell Object

2010-03-05 Thread Harpreet Singh Gujral
;> *Subject: *Re: $$Excel-Macros$$ Shell Object >> >> Dear Harpreet >> I have msdn and dump for VBA Shell Object Programming,but it is too large >> to send >> on gmail. >> and i don want to upload in any of file share site. >> hope my 1'st program

$$Excel-Macros$$ Problems with Add-ins

2010-03-04 Thread Harpreet Singh Gujral
I get the following error in the Tools - references in the VBA editor What is this all about Harpreet -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

Re: $$Excel-Macros$$ Help for understanding VBA

2010-03-04 Thread Harpreet Singh Gujral
Here is the link guys, http://groups.google.com/group/excel-macros/files cheers Harpreet Gujral On Mar 4, 12:45 am, rf1234 rf1234 wrote: > Dear Ankur > Please provide us link,so that we can perform better. > > happy to help > :) > shyam > > > > On Fri, Feb 26, 2010 at 11:27 AM, ankur wrote: >

Re: $$Excel-Macros$$ Shell Object

2010-03-04 Thread Harpreet Singh Gujral
HAVE MENSION >> ''''''C:\WINDOWS\system32\notepad.exe >> >> RetVal = ShellExecute(0, "open", "C:\WINDOWS\system32\notepad.exe", >> "Open notepad Programme",_ &

$$Excel-Macros$$ Data in variables

2010-02-28 Thread Harpreet Singh Gujral
Hi, Is it possible to keep the value stored in the variable till the time the sheet is running or the code is running. Example: I have to a variable A and B, which i need to use to store information from a form, this information will be used in other modules or procedures. Is it possbile to keep

$$Excel-Macros$$ Shell Object

2010-02-28 Thread Harpreet Singh Gujral
Hi Group, Some of the VBA Macros use shell object in their codes. Can somebody help me understand what is it all about? Thanks Harpreet Gujral -- -- Some important links for excel users: 1. Follow us on TWITTER fo

Re: $$Excel-Macros$$ Need either excel formula or Macro

2010-02-26 Thread Harpreet Singh Gujral
Hi, I had a look at the file, i think there is some descrepancy between what data we have on sheet "Goods No1" and "Data Sheet", and similar is the case with Goods No.2 sheet and data sheet. The codes that you want to check in Data Sheet are mostly 6 digits while codes in Goodsno1 sheet and Goods

Re: $$Excel-Macros$$ Re: pdf converter software code needed (able2extract)

2010-02-26 Thread Harpreet Singh Gujral
Hi Guys, Can somebody post the link for able2extract software. I guess the software would be helpful in converting pdf to different forms i.e. .xls or .doc etc. Thanks Harpreet On Feb 26, 2:11 pm, ankur wrote: > hi anil > this is not a excel file > its a software to convert files > > able2extr

$$Excel-Macros$$ Named Ranges

2010-02-24 Thread Harpreet Singh Gujral
Hi Group, In order to name ranges i use the following code: ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:= _ Strshtname & "R1C1:R2C3" It uses R1C1 referrencing, can we use the other referrencing for this code Thanks Harpreet Gujral -- --

$$Excel-Macros$$ Re: Application.commandbars

2010-02-24 Thread Harpreet Singh Gujral
Does anybody have access to complete information on Commandbars, and all its properties. Please forward it to me Thanks Harpreet Gujral On Feb 21, 7:56 pm, Harpreet Singh Gujral wrote: > Hi, > > Can someboday help me with the commandbars? > > I am looking forward to

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

2010-02-22 Thread Harpreet Singh Gujral
This is a amasing solution. Works great, have tested a test file Will try it on a real life situation too. Thanks mate Harpreet On Feb 20, 10:27 pm, SHAM wrote: > To crack the password of an VBA Macro / coding first download an HEX > Editor > > its available from the > sitehttp://www.chmaas.h

$$Excel-Macros$$ Application.commandbars

2010-02-21 Thread Harpreet Singh Gujral
Hi, Can someboday help me with the commandbars? I am looking forward to create a custom commandbar with the help of VBA. Can you please suggest a source to understand what all sub properties that we need to specify to make the commandbar. Like position etc etc. Thanks Harpreet Gujral --

$$Excel-Macros$$ Re: Gift for you all...........

2010-02-13 Thread Harpreet Singh Gujral
I would say its a great piece of craftmanship! Kudos to the developer of this amsing tool Harpreet Gujral On Feb 11, 8:37 pm, Harmeet Singh wrote: > *Hi Guyzzz* > * > * > *I found a great tool on internet.* > *You can control Window Media Player using this Excel based tool.* > *If y

Re: $$Excel-Macros$$ Converting .xlsm to .xls

2010-02-09 Thread Harpreet Singh Gujral
spx > > Regards > > Yahya > > On Sat, Feb 6, 2010 at 9:19 PM, Harpreet Singh Gujral < > > > > harpreetguj...@gmail.com> wrote: > > Hi Dilip, > > > This is something which i am looking for. > > > I am already known of the fact that we can s

$$Excel-Macros$$ CDO Object[Variable Life span and scope]

2010-02-07 Thread Harpreet Singh Gujral
Hi Group, I want to seek help regarding CDO Object I have designed a sheet, which contains User Form, which allows a user to send an email. It has been programmed to send email through Gmail server. I am facing the following problem: 1) The variable storing the user name and passwrod supplied b

Re: $$Excel-Macros$$ Converting .xlsm to .xls

2010-02-06 Thread Harpreet Singh Gujral
03. > > Best Regards, > -- > DILIP KUMAR PANDEY >    MBA-HR,B Com(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > On 2/6/10, Harpreet Singh Gujral wrote: > > > > > > > > > Hi Group

$$Excel-Macros$$ Converting .xlsm to .xls

2010-02-05 Thread Harpreet Singh Gujral
Hi Group, I work on Office 2003, and it becomes a problem to work on a xls made in office 2007. Any ideas to convert into office 2003. Please suggest Harpreet Gujral -- -- Some important links for excel users: 1. Fo

$$Excel-Macros$$ Fwd: Help with Hyperion Addin!!!!

2010-01-27 Thread Harpreet Singh Gujral
Hello Group, Does anyone have a solution to this problem? Thanks Harpreet -- Forwarded message -- From: Harpreet Singh Gujral Date: Fri, Jan 15, 2010 at 10:53 PM Subject: Help with Hyperion Addin To: MS EXCEL AND VBA MACROS Hi, I have a Hyperion Addin installed in my

$$Excel-Macros$$ Workbook.Selection Change Event

2010-01-21 Thread Harpreet Singh Gujral
Hi, Need help regarding the following code: I have written a code which would help me to determine Which sheet is the user on, and if that matches the criteria, then the statement would be executed. I believe, that i am not able to make the macro identify which sheet is the User on. Code: Priva

$$Excel-Macros$$ Help with Hyperion Addin!!!!

2010-01-15 Thread Harpreet Singh Gujral
Hi, I have a Hyperion Addin installed in my system, To give a background about the system. Hyperion is a financial management software. Its Add- in helps the users to retrieve data of particular accounts on the excelsheet according to parameters set. Problem: The Add-in is like a menu on the Tol

Re: $$Excel-Macros$$ Reg : Help in excel macro

2010-01-09 Thread Harpreet Singh Gujral
Hi ruben, i dint know how to add the file to the posts, thats why i mailed you the file. Please check if that helped Harpreet Gujral On Jan 5, 2:30 pm, ruben dasan wrote: > pls help me its very urgent pls > > On Wed, Dec 16, 2009 at 3:58 PM, ruben dasan wrote: > > > > > pls help me out gurus >