$$Excel-Macros$$ Data-Import External Data-New web query

2014-04-08 Thread amar takale
Dear Experts, I want to below link attach in excel for data import (Data-Import External Data-New web query).I will try it but not working.After Import data in excel Then automatic refresh in excel. http://www.investing.com/indices/major-indices Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Data Import

2010-04-01 Thread Dipika Mallya
On.Count >1l goto next worksheet. On Thu, Apr 1, 2010 at 11:44 AM, Mahesh wrote: > Dear All, > > Need ur expat advise... > > I got around 20 text files in a day,which had 13 to 15 columns separated by > "|" this sign. each file contains around 15 lacs or more line items. > > when i import that

$$Excel-Macros$$ Data Import

2010-04-01 Thread Mahesh
Dear All, Need ur expat advise... I got around 20 text files in a day,which had 13 to 15 columns separated by "|" this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to

$$Excel-Macros$$ Data Import

2010-03-30 Thread Mahesh
Dear Champs, Need ur expat advise... I got around 20 text files in a day,which had 13 to 15 columns separated by "|" this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help

$$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