$$Excel-Macros$$ DATA>IMPORT >XML Missing in excel 2003 standard edition

2009-10-06 Thread Manoj Kukrej
Hi, I want to know how I can add xml in it I have checked in tools > commands>xml is also missing Regards Manoj This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, pl

$$Excel-Macros$$ Looking for most effecient way to convert lots of data

2009-10-06 Thread bruce
I am creating a program that does daily QA of our products. I work for a phone company and we sell differnt lines, with differnt options What I need to do is to convert one speadsheet where the features of the phone lines are in a list, one feature per row Simplified input file PhoneNum 555-

$$Excel-Macros$$ Best Way to Mimic Relational Data?

2009-10-06 Thread HumanJHawkins
I have a list of 15000 rows of response data about questions that showed up on a series of tests. There is often more than one row for each test question, because each question was used in more than one event. So the data may be like: 1 A 3.33 1 B 2.99 2 A 1.11 2 C 1.13 etc. Unfo

$$Excel-Macros$$ Opening Program with command line args

2009-10-06 Thread Mirosta
Hi I have a .net program that I have written which I have set up to take some command line inputs, I need to know how to open this with the arguments but with VBA, help is greatfully recieved! Mirosta --~--~-~--~~~---~--~~

$$Excel-Macros$$ excel + vba + html

2009-10-06 Thread Ane
Hello everyone, I am from Brazil and I am developing a document in excel with a lot of vba codes (buttons, combobox, hyperlinks) and it has arount 150sheets (some are hidden, and I only have access to it if I select on a combobox) I am thinking about to post this document on a webpage, but not a

$$Excel-Macros$$ Excel macro-Help

2009-10-06 Thread Umesh Matkar
Dear Friends, I have one query regarding macro. i want to record a macro for goal seek. Attached reference sheet says following Column A - my goal starts from 2009 for 16 years till 2024. B - Accumulated amount equal to one row up for column E C - goal seek result i.e investment amount, please ref

$$Excel-Macros$$ Re: Macro to split a master list into three lists

2009-10-06 Thread Chechu
So no suggestions On Oct 4, 1:37 pm, Chechu wrote: > Easier!! Given a sheet with the format I sent, I need to create an > output sheet opened by resource location. > > On Oct 3, 3:33 pm, jamesdavey wrote: > > > > > so you mean, for example, you want to add a new resource manually, > > then