Search results for query: *

Thanks PH that was a simple miss on my part. Tim

I am trying to write code that will check only certain cell dependent on row. In this case certain cells that are below a given number are red and rest are green. How ever I am getting an error: Run-time error '1004': Unable to set the ColorIndex property of the Interior class Here is the...

Okay, lets say that the data you see is the first time that data will be sent to access. The same report will be ran again in 4 hours or in 48 hours but now the first line or first 12 lines will be new data, not already in the database. At this point the new data is the only information I want...

Okay here is what would show up in the excel spreedsheet when I ran it on 8/25 Shift A at end of shift. Well the report would be ran again for 8/25 Shift B and T would be M. You would only have one new line or after the weekend you may have 12 new lines and 36 old due to no one here to run the...

I am working with data that has to be pulled by way of txt file due to the database is propriatary. The information goes into a excel spreedsheet first from the txt file so that I can cut it up and grap only what I need. The next step is sending it to an access database. The only thing is that...

I think that V BA and Macros for Microsoft Excel by Bill Jelen was not to bad on its chapter about vba and pivot tables. You even get examples when you get the book. Timely

I am bringing in data that is setup with date and time but once in I need to get rid of the time. I am not sure what vba function I can use to change the format to only have the date and the time be totally erased so that I can line things up by date in a pivot table without the issue of time...

Skip, I did not explain very well. I know that one has to be showing and I want to have two certain ones show. I just do not know all the ones that will be needed to be hidden. So I was looking for a way to show what I want seen in the item list without having to know the other ones but I all...

I am working on vba to setup a pivot table but only what values of certain things to show. Currently I have: With ActiveSheet.PivotTables("PivotTable4").PivotFields("Pkg") .PivotItems("AUTO03F").Visible = False .PivotItems("AUTO20F").Visible = False...

Thanks... I will give it a go.

I was not trying to be sarcastic, sorry if it sounded that way. I was just wanting to put the data and times on another sheet to then compare to other data that I have collected. I was not wanting to have to cut and past due to I am trying to make it so that people can run it by just pushing a...

Yes, good for pivot tables, but is there a way to do that with vba and place in a report. Pivot tables take tomuch room on some of the older systems.

Oh, bye the way this is in excel.

I am trying to get it so that if I have multiple entries for products I just want the last time for each of the products. An example of the data is: Date Customer Date/Time 29-Sep-04 1594301 9/29/2004 23:00 29-Sep-04 1100501 9/29/2004 23:00 29-Sep-04 1594201 9/29/2004 23:00 29-Sep-04 919101...

I just want to do something that I would think is easy but it is not not just pasting and I do not have any of my outlook books here. I am wanting to take a graph off a excel spreadsheet and place it on an email in outlook.

Okay, I felt stupid on that one....I misspelled "default"! Thank You :) A star for you since it was my own fault.

I have a vesion of htm, html, asp and an shtml but none are appearing. I also tried to run an ASP and it worked fine. I think it has something to do with permissions or how it setup to see them.

Also the error was a 403 error

I had the IIS 5.1 setup working on an XP earlier with help a few weeks ago. Today I was trying to change the defualt but was not sure at what level to do it and deleted and reput on several defualt types but now no defualt page is coming up just a (You are not authorized to view this page)...

Yes, and thank you that worked. Sorry if not clear but what you said worked.