$$Excel-Macros$$ Macro to extract data from Access database

2008-09-14 Thread dev t
Hi All, Can any one please help me in below query... Let me tell you what I normally do :- 1. I take out 2 excel files from our online database. 2. I run a macro in MS Access to make 1 combined raw data file.(since these files are huge it can not be done in excel) 3. I extract the out put again

$$Excel-Macros$$ PIVOT

2008-09-14 Thread Sabyasachi Mishra
I want to learn about PIVOT. what is the beifit of PIVOT & how it is done? -- Thanx n Regards Sabyasachi Mishra 09337144554/09776018832 Poor Mind Think People,Average Mind Think Event,Great Mind Think Ideas!!! --~--~-~--~~~---~--~~ Visit the blog to download Exc

$$Excel-Macros$$ Re: Pls Help

2008-09-14 Thread Sleek
Yes it possible, but there is macro for it. the numbers can go into billions to. But there is NO formula for it. Let me find the macro and give it to you. On Sep 13, 12:54 pm, "ankit varshney" <[EMAIL PROTECTED]> wrote: > Is it possible to convert any number in text. > > For Example if i ente

$$Excel-Macros$$ URL User name password

2008-09-14 Thread [EMAIL PROTECTED]
Hi I need some code that will open a url, enter user neme & password , then once page has loaded click on two buttons in seperate tables (selects dates) which have javascript using numeric date format then hit download button. a text file opens which i want to save as download.txt even better wo

$$Excel-Macros$$ Re: Pls Help

2008-09-14 Thread Balachander S
Try this Link http://www.meadinkent.co.uk/xlnumberstext.htm Baloo On Sat, Sep 13, 2008 at 3:24 PM, ankit varshney <[EMAIL PROTECTED] > wrote: > Is it possible to convert any number in text. > > For Example if i entered 500 then by any folmula can excel can give output > of five thousend. > > --

$$Excel-Macros$$ Re: Pls Help

2008-09-14 Thread ashok jain
I also require this formula. On Sat, Sep 13, 2008 at 3:24 PM, ankit varshney <[EMAIL PROTECTED] > wrote: > Is it possible to convert any number in text. > > For Example if i entered 500 then by any folmula can excel can give output > of five thousend. > > -- > Ankit Varshney > 9210639227 > > > >