excel 2003

Hello everyone, I am after a little help in creating a Macro to change my existing data in Excel 2003 from this; <TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128 x:str><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR...

Hello, Ran through your forums - found it very interesting, found few similar problems but cannot do it - somehow doesnt work please see this formula =SUMIFS('CS Feedback'!I$5:I$100,'CS Feedback'!F$5:F$100,A4,'CS Feedback'!R$5:R$100,E$3) no problems in 2010 cant use in 2003 any ideas? how to...

Hi there I've searched everywhere and cannot find an answer. Is it possible to insert an html link with attributes into an Excel sheet? e.g. <a href="https://plus.google.com/101122920555397820958" rel="author">Laurence O'Toole's Google+ profile</a> I want to upload an Excel 2003 sheet to...

Hi, I have a Excel/VBA script written 5-6 years ago on a Mac running Excel -- probably 2003. (It is not an option to go back and work on that Mac and software version.) I need to get this to run in Excel 2007 on a PC. This is my first time debugging VBA scripts. I've been able to remove some...

I am working on a large spreadsheet for my company and I have come up with a very complicated formula that looks at two columns of data and then counts if both criteria are met. However, the department I am doing this spreadsheet for wants it as automatically generated as possible and one of...

sunny boy data. I have a macro to show maximum daily output but I am failing with the time of that max output. Here is the debugging dialogue: Sub maxtime() ' ' maxtime Macro ' Macro recorded 23/04/2012 by mcd ' ' Keyboard Shortcut: Ctrl+q ' Range("D154").Select ActiveCell.FormulaR1C1...

I have been developing a form to enter data into a spreadsheet, it has been working fine, i havent changed any code recently but i have started to get a runtime 13 mismatch error. This code is in a module that is called from the cmd button: Sub Button1_Click() Worksheets("Daily...

I have a macro that, in one test, finished in under a minute with Excel 2007 and took 13 minutes in Excel 2003. I have narrowed it down to one section of code that takes all the time. Any thoughts? On Error GoTo ErrHandler For x = myRow To lRow Application.CutCopyMode = False...

Hello, This is kind of a half excel issue and half excel so hopefully someone can help. Im trying to do a mail merge from excel into word and I can get a page per person, however the excel contains the same person multiple times. For Example the excel contains "The recipient" and then the...

Hi all, I have a problem which has me a bit stumped.. I have written a macro in excel 2010 which seems to work fine but when I use it in excel 2003 it all works except the csv produced is not right. The macro writes the data into a csv which needs to have a comma at the end of each row. eg...

I have an Excel Add-in written in VBA that works in Excel 2003, 2007 and 2010. It contains two forms that are essentially progress windows. The forms have their ShowModal property set to False and receive updates as long-running macro processes continue to execute while the forms remain on the...

I'm doing vLookups from one file to another, and would like to bring in the formatting of the cell in addition to the value. Is this possible in Excel 2003? If so - can you give me the formula to use? Thank you!

Hello Folks, I'm having issues trying to copy an oracle table column which has Japanese characters into an excel 2003 sheet, the code it's copying the columns inside the sheet but instead of having japanese chars I'm having "???????", I tried installing asian packs for windows xp but this not...

I have some macros in Excel 2003 that have problems in Excel 2007. Someone said I should copy over my object library to 2007 but I have no idea what this means. Can anyone help?

I have an active sheet where any of the columns maybe hidden, but I don't know what columns are hidden. How to search the columns which are hidden in the active sheet using VBA. Also I want to unhide the columns whichever hidden, at the same time i want to store the no of columns which are...

I am having several problems with the mscomct2.ocx for weeks now... See details below of the issue... Details: - No problem in inserting the DTPicker on the VBA environment / Form. - Error message "Cannot Load Object" when I am trying to embed the DTPicker on a worksheet. - I am currently...

Hopefully someone out there can help me with this; it's been years since I touched Excel. It may be important to note that I'm doing most of the creation of this spreadsheet on Office 2010 (on my home computer) but I need to make the spreadsheet compatible with Excel 2003 (on my computer and...

Right, what I'm attempting to do here is work out the cost incurred to each individual of a number of people who went on a trip. Basically, I paid for everything and now want to split the cost between appropriate people so I made a table (food down the side and people along the top). The...

I am using Excel 2003 with Win XP Pro. Many times I have copied worksheets from one workbook to another by right-clicking on the tab etc. However, all of a sudden, it's no longer possible. When I try to copy a worksheet from one workbook to another open workbook, the drop down destination list...

I'm having problems using variables with filenames. I have a selection of .html files stored on my hard drive, I want to be able to write a macro that allows me to browse to and select these files (either individually or as a multiple selection), and then have the macro store the filepath(s)...