$$Excel-Macros$$ Re: foget password

2009-01-18 Thread shay shay
please mail ur file. On Sat, Jan 17, 2009 at 8:08 PM, Rabindra Thapa wrote: > i protected by password on my working files but after long time when i > try to open it , i can't please advise me how to open my files. > > > > -- Shay A Thinker tends to use reason and logic A feeler tends to us

$$Excel-Macros$$ how to create macro in excel which can speak the cell content...

2009-01-18 Thread Bakul Patel
G'day guys,   I am trying to get a macro in excel which can speak the cell content.   I tried SPEAK & SAYIT function but it is not working in my computer...I have got windows XP Prof. & also i lost SAYIT function from my function list. How to get it back?   Please share your ideas.   Thanks.

$$Excel-Macros$$ Re: Need an option to select any text file when importing into a worksheet

2009-01-18 Thread Steven Cordovano
i am new to the blog so maybe everyone gets these, but i didn't ask this question. Actually, i have a different one if you perhaps know. I have been working on a project that has real time stock prices on one worksheet and i wanted to tak a snap shot every 15 minutes starting at 9:30 am til 4pm.

$$Excel-Macros$$ Re: Need an option to select any text file when importing into a worksheet

2009-01-18 Thread Steve
Thanks Dave, I'll give it a try when I get back to work tomorrow. Regards, Steve On Jan 18, 3:46 am, Dave Bonallack wrote: > Hi Steve, > Ignore the first email. It was incomplete. > Try this. Remember the extra End With near the end. > Regards - Dave. > >     Dim myFileName As Variant >     myFi

$$Excel-Macros$$ Re: Need an option to select any text file when importing into a worksheet

2009-01-18 Thread Dave Bonallack
Hi Steve, Ignore the first email. It was incomplete. Try this. Remember the extra End With near the end. Regards - Dave. Dim myFileName As Variant myFileName = Application.GetOpenFilename(filefilter:="Text Files, *.txt") If myFileName = False Then Exit Sub 'user hits cancel W

$$Excel-Macros$$ Re: Need an option to select any text file when importing into a worksheet

2009-01-18 Thread Dave Bonallack
Hi Steve, Dim myFileName As Variant myFileName = Application.GetOpenFilename(filefilter:="Text Files, *.txt") If myFileName = False Then Exit Sub 'user hits cancel With ActiveSheet With .QueryTables.Add(Connection:="TEXT;" & myFileName, Destination:=.Range("AA2")) > .

$$Excel-Macros$$ Please Help : How to convert xlam into xla??

2009-01-18 Thread jagjeet singh
Can Somebody help with this aspect. This is desperately needed. Regards From: jagjeet singh [mailto:jagjeetgul...@gmail.com] Sent: Saturday, January 03, 2009 11:07 AM To: 'excel-macros@googlegroups.com' Subject: How to convert xlam into xla Dear All Help required as to how t

$$Excel-Macros$$ learning of VBA

2009-01-18 Thread vinay keni
hi friends to have a good knowledge in excel is that necessary 2 learn VBA.. if yes in wat sense. can u explain -- Regards, Vinay Keni --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post

$$Excel-Macros$$ foget password

2009-01-18 Thread Rabindra Thapa
i protected by password on my working files but after long time when i try to open it , i can't please advise me how to open my files. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, s

$$Excel-Macros$$ Create a file that linked with excel sheet

2009-01-18 Thread VIRAL PANDYA
Dear All, I have a excel sheet contains 128 Sheets and daily i have to take print out only for 5 Sheet (record sheets). Is there any way by which i can create a linked excel file for only this 5 sheets? Please help. Regards, Viral Pandya --~--~-~--~~~---~--~~ Vi