2003

I am attempting to calculate the start date when the desired end date is known (Column D), and the duration to complete the work is also known (50 days, Column C). I'm using Excel 2003, and this info will be broadcast to multiple users, so using the Analysis Tool Pack is not an option. Is...

Hi, I have a simple macro that was built in Excel 2003. The macro simply takes the value of a cell and output it in another sheet. This runs for about 1000 lines. This used to take 5 sec with Excel 2003 but now takes forever with Excel 2007. Anyone can suggest an idea? I tried setting the...

Hello All, I am an absolute n00b when it comes to VB. most of my code was written in MacroRecorder and edited to clean it up and make it more readable to a computer. This code works fine in 2007 but my store computers use 2003. Can someone please help me identify what I can change to make this...

I just converted from 2003 to 2007. When I refresh my pivots, the formatting drops out of the headers and they all turn black. Help!

Hi, Some years a go I wrote a Excel 2003 spreadsheet that produces CSV files every few seconds for someone else. They now want to use the same spreadsheet with Excel 2010. They say because 2010 is multi threaded not single threaded and it will put less pressure on the servers. I don't...

Hi all, We have an issue with a shared sheet causing one user's excel to hang and needing to be killed in task manager. the facts: Sheet created in Office 2003 Sheet is 6.5MB Sheet has external links to other workbooks It works for all other users (even on the same PC that the affected user logs...

Hello, I designed an employee expense report form in Excel 2003 using the list function. The form looks like a table, with 6 columns and 20 rows, and the user lists expenses in the last 3 columns. In the 20th row of the table/list, there’s an asterisk/insert row. This is handy if the user needs...

Hi, I am stuck on this particular situation.... Example : variable 1: Start date 9/26/2010 variable 2: end date 10/2/2010 constant : # days between startdate & enddate is always 7 days How can I determine ( using the above date range as an example ) that for the current week I had 5 days...

Hi, I have an ADO recordset whereby the data returned is all text. When I pass the recordset to my pivotCache object, the pivot table will be created but since the data is all text...the pivotfield type is set to "Count of.. ". Question : is there a way to convert the recordset data to the...

Hi, How would i go about ensuring that "WorkSheet_Change" event handler only occurs when a user manually updates a cell and not when a cell change is done by another macro/subroutine ??? thanks !

Hi, I am stuck on this particular problem... Scenario: I have a simple column in my activeworksheet Column A --------- 1 ( Cell 1,1 ) 2 ( Cell 2,1 ) 3 ( Cell 3,1 ) 4 ( Cell 4,1 ) 5 ( Cell 5,1 ) let us suppose the user changes the content in Cell(1,1) from 1 to 2 and now the column would...

Hi, I recently finished my vba code to import results from a database table. When the VBA macro imports the data onto the worksheet all my values are stored as text in excel and thus the green arrow error appears. The funny thing is that excel kept my dates as a date....( column A ) How...

I like to define keyboard shortcuts for several symbols I often use. My computer is currently running both Excel 2003 and 2007. I was able to save my list of shortcuts in the 2007 version, such that each time I open a new workbook all the shortcuts were in place, but I can't seem to save...

I have a formula that works fine in excel 2007, but contains too many levels of nesting to work in 2003. I don’t know if there is a solution or not, but if there is the people here will know it. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p>...

Hi. I love your vid :) Glad to found it. Ok, here it goes. I have little trickier question, that we didn't found an answer. Here it goes: If I have to put in one cell formula like that... if the value of the cell is from 0 up to 100, than is 1, if the value of the cell is from 100 to 200, then...

My computer has both the 2003 and 2007 versions of Excel loaded onto it. How do I set my default Excel program to the 2007 version so regardless of the Excel document, it will ALWAYS open up in the 2007 version? Thanks for any help!

I am currently working with vlookup and getting some very strange results in Excel 2003. The bottom row is a a vlookup to find information from a particular month listed above. This is eventually going to be built into a larger formula to show percentage change between 2 months. The formula...

Hi, all. I just got upgraded to MSOffice 2007 and mostly it's fine, with the usual bugs that come with such moves. However, one of my duties is to upload an .xls file to a website for display. The last time I did this with 2003 it worked just fine, but the first time I did it w/ 2007 it did...

I created a macro - with alot of help from people on this board... Thanks! The macro creates a report of certain data points in files that are saved on the computer's hard drive. It is a performance evaluation... and let's say you have 5 people - the macro creates a report showing you each...

Hi, I am using the OpenText method to open a .csv file. I have added a column that has values like "05" "05,06" "06" "" etc. I need excel to see the values as CHARACTER/STRING, not as numbers. When I look at the value, it has been converted to 5,0000000000 5,0599999999 6,0000000000 How can...