Search results for query: *

Zathras, Right on man....Thanks a lot...this was a fairly simple fix for what I thought would be a mountain of work.... I had 2016 records....!!! Thanks a bunch....

Hello all, A problem for me probably easy for you folks. I have a list of names in Column A in an Excel file - several hundred names. I want to create a notepad file for each of those names. So in essence, create a notepad file and save it with value from cell A1 - create another one and...

I am trying to create histograms in Excel 97. I can analyze the data in Excel (Data Analysis tool) and create a pareto and data histogram. Therefore I tried to create a macro that does that - recording while I go through those steps of creating a histogram. Excel crashed !!! I tried it again...

Yes sirr !! Thank you very much

Hello, VBA pros help mee !! During the open sequence of an Excel file, I need to give the user a dialog box to choose a file to open. I was thinking I can handle this with Auto_Open by calling another subroutine. But I bring up the "File-Open" dialog box using a macro whereby the...

Hello, During the open sequence of an Excel file, I need to give the user a dialog box to choose a file to open. I was thinking I can handle this with Auto_Open by calling another subroutine. But I bring up the "File-Open" dialog box using a macro whereby the user can select the file...

Hey thanks joegz. I will try that. You are correct - I am not using Exchange server. As you have suggested, this will scan the PST file. But I am not having issues with the Mail Inbox. My mail works just fine. I have even use tasks, notes - just not the calendar. Touch the calendar and it...

Hey all... I am desperately in need of help. I use Outlook for everything except cooking !! Everything is working (tasks, mail, contacts) except the CALENDER. When I click on the calendar everything hangs. I cannot even open, click or do ANYTHING. The calendar opens and Outlook hangs. I tried...

Hey all, For Outlook 2000 I installed the security update today and restarted my computer. I am a single home user (not on network). After restarting the computer not Outlook 2000 starts and within a few seconds SHUTS DOWN AUTOMATICALLY...I try it again, it might stay a few seconds longer...

Sorry Hasit... I did realize that my question was a bit confusing. Here is what I want to do.... Look up Columns A and B and find the matching total from column Z to be entered in Column C <A> <B> <C> Week Year Total 1 2000 2 2000 3 2000 4 2000 5 2000 1 2001...

Hey folks, I have data in several columns and a gazillion rows... I want to lookup data from another sheet to match certain column pairs... Like - In column B i have &quot;week number&quot; and in C I have &quot;year&quot; - lets say in cell B6 I have &quot;Week 6&quot; and in cell C6 I have...

Being an Engineer, I have been looking into applying Excel into data collection from machines and such...In one of my recent applications, I needed to &quot;clip&quot; data from a cell - for example one cell contained &quot;2002-18&quot; (in the format year-week) and I wanted just the week...

now help me folks... excel file with sheet name &quot;data&quot; - 21 columns - 5000 rows each....one of the columns is for &quot;dates&quot; - in a different sheet, i am allowing the user to enter &quot;start&quot; and &quot;stop&quot; dates. I want to use these dates to filter the stuff in...

Hey Jeff, Thanks for your response. But I am looking to change the DEFAULT on the comment font and size....so that I dont have to change it everytime....it defaults to font size 8 always....i want to make it default to 12...

How can I change the DEFAULT for the font and font size for the comments that can be inserted in Excel cells. ???

I have 2 questions really - Once I draw a chart, how can I delete it thru the macro ? - a new one is drawn continuously and hence I need the old one to be deleted.... Second question.... I want to draw a line chart thru a macro - the data for the chart is sometimes 10 rows, sometimes 20...