Recent content by mosmas

What are you using this connection for? Pivottable, Table? If you refresh that object, what result do you get?

Hello: Here is my problem: I have a pivot table that I want to be able to search for a specific value. The problem is my code takes a long time. Is there any way this can be coded so that it run faster. Here is the code that I have: Sub UniqueItem() 'This routine, uniqueItem, selects the name...

Thanks all of you. I used Skip's solution. Yes, I can use the autosum but I wanted to see the sum as I change my autofilter "entries." Once again, thanks a lot. Moses

I need a formular that sums up the autofilter results. Can this be done using a formula or I need a macro or both?' I any ideas? I am running Office XP. Thanks... Moses

Thanks Zathras. I tried it but I couldn't get it to work. I will try it again. In any case, thanks a lot. You deserve a start, so I gave you one. :) Moses

I have a solution to this one but I want to know if there is a better solution: I have a spreadsheet with this format: Codes Amount 1004 10 1005 20 1005 30 1006 10 1006 15 1008 15 1009 20 As you can see the are duplicates. In onther sheet, I have a series of codes like...

Neenas19: Thanks I just figure out how. To calculate the months, I just need to subtract 12*the number of years from =datedif(a2,b2,"m"). Thanks for your input though. moses

I have user who wants to calculate the number of years and months someone has been employed. This is what I had in mind. we would have a col with Hire Date, Today's and two more columns, one for years and one for months. TO find years, I used this formular: datedif(a2,b2,"Y") and it...

Thanks a lot. That seemed to have worked for my customer. You deserve a star so I gave you one. God bless. Moses

Hello: I have a user who has a form and he wants to be able to search is databse by last name. Let's say he wants to find mmsenda. What he wants is, when he types in mmsenda, the record will come up and not changing the value of this field. Any ideas? Thanks Moses

Never mind... This is a bug that't not going to be fixed for r5. It is addressed in r6 though. The reason is because r5 uses frameset which is hard coded. Thanks anyway. Moses

Hello: I have a use who wants to set defaults in R5. He wants to set the way his preview window looks and the width of the section that has his folders. Any ideas? Thanks in advance for your assistance. Moses

Hello: I have a user who is being asked to save Book1.xls when he tries to copy and paste an Excel object in Word. He opens up an file, by going to File --> Open --> select the file that he wants. In this file, he selects a number of cells and copy them. Opens Word, then go to Edit -->...

Hello: I have a database that has two tables, one tblCurrent and the other tblPrevious. Each of these tables has 10 identical fields. What I need to do is to check if there is anything that has changed from the previous table. So, I need a query that will display a datasheet of those fields...

Nevermind... I figure it out. Just in case you are wondering how, here is how. Create a template and name it book.xlt and save it inthe XLStart Folder. That should take care it. Thanks anyway. Moses