Recent content by phil009

Skip-Once again you come through in the clutch. You are a life saver. Thank you so much, Phil

I guess I probably should mention that I tried to use your formula Skip, just with an IF statement like ...

Skip-Thanks for your reply that really helped. Not to further rub this question into the ground, but I have one final part to do (I promise this is the last question on this thread!). So I can currently bring up both the current week and the year to date total but now I need to get a quarter...

Ok-now I have finished one part, but I have one more question. Using INDEX(export.xls!Database,4,CurrentWeek) I have been able to get the current week's data but now I need the year-to-date total. So since this is week 26 I would somehow need to get weeks 1 through 26 added together (and then...

Zathras-That is exactly what I needed. Thank you so much. You get a star for that one!! Thanks to both of you, Phil

Skip\Zathras-Thanks for the quick replies. Skip- The problem with normalizing the table is that There are ten companies and 23 categories that must be recorded for each week for each company. And, the table was already set up like this when I got it and it seems like a huge job to normalize...

Hi, sorry I don't know what forum to put this question in so it might not belong here but here goes...I have 2 excel workbooks (one with all my data and the other which I would like to link the data to). My excel workbook with all my data (export.xls) has data dating from 1996 to 2004 and is...

Good idea, I hadn't thought about it that way. Thanks for your help, Phil

I guess a better question would be, is there any way to set a password for one specific table instead of the whole database? Thanks for the quick reply KenReay, Phil

Hi everybody, In ms excel you can have it so that when a file is opened a message pops up that says something along the lines of "This file should be viewed in Read-only mode unless you need to edit it." And it is then followed by buttons to choose from such as "Read-only" and "Edit"...

I was just quickly wondering why when I use an OutputTo function in my macro it moves very slowly, but then if I change it to a TransferSpreadsheet it works in the blink of an eye. What happens during the OutPutTo function that makes it go so slow? Thanks, Phil

Try looking at thread700-866385 this may help you out. Hope this helps, Phil

You could go with your idea of adding 7 days to the SQL but instead of adding 7, add 9 days, that will then give you seven working days. Hope this helps, Phil

I figured it out, I had let excel record this for me and the scrolling was just unnecessary. Thanks for your help guys, Phil

Hi everybody. I currently have a code that will work but only on the active window. I would like it to work on a select worksheet so that you don't have to be looking at the worksheet for the macro to run correctly. My code looks like this: ChDir "G:\All\Phil" Workbooks.Open...