Re: $$Excel-Macros$$ Clear cookies, cahce

2010-09-10 Thread ashish koul
check the link see if it helps* source*:http://www.vbforums.com/showthread.php?t=440508 Sub Clear_Temp_Files() Shell "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8 " End Sub Sub Clear_Cookies() Shell "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 2" End Sub Sub Clear_History() Shell

$$Excel-Macros$$ Clear cookies, cahce

2010-09-10 Thread Anju
How to clear Browser cookies & cache thru VBA code. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http:/

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-10 Thread Chandru
The final conclusion is text box gets locked during track changes. Thanks for the info. On Fri, Sep 10, 2010 at 9:50 AM, P.VIJAYKUMAR wrote: > Hello, > > You can use change tracking to log details about workbook changes every time > that you save a workbook. This change history (change history: I

Re: $$Excel-Macros$$ Macro to reshade every other row after column sort

2010-09-10 Thread Paul Schreiner
What has this got to do with shading rows? has someone hijacked another's post? P From: "Kishan Reddy, K" To: MS EXCEL AND VBA MACROS Sent: Fri, September 10, 2010 2:58:35 AM Subject: Re: $$Excel-Macros$$ Macro to reshade every other row after column sort Us

$$Excel-Macros$$ Re: How To Connect To Access Database Through VBA

2010-09-10 Thread Kishan Reddy, K
Deepak, Let me know, why you want to create the form in Excel and link it to access. You can directly create a form in access which is very simple. Regards, Kishan Reddy, K On Sep 9, 10:48 am, Deepak Pal Singh wrote: > Hi, > > I need a help to connect excel file to a database in Access, I've a

Re: $$Excel-Macros$$ Macro to reshade every other row after column sort

2010-09-10 Thread Kishan Reddy, K
Usha, This function is used mainly in finance. This can be better explained by an example. Let us assume, you are having Rs. 1,00,000/- which you want to invest. You got two proposals. 1. Fixed deposit at 10% interest for five years. 2. an annuity plan : end of 1st year you wi

Fwd: $$Excel-Macros$$ How to copy the list of autofilter selection?

2010-09-10 Thread neil johnson
-- Forwarded message -- From: Meimei Date: Fri, Sep 10, 2010 at 6:55 AM Subject: $$Excel-Macros$$ How to copy the list of autofilter selection? To: MS EXCEL AND VBA MACROS Hi all, I have a question about copy the list of unique values generated by autofiltering in VBA. For exam

$$Excel-Macros$$ Re: Lookup from date series

2010-09-10 Thread Kal xcel
Thank a looot kumar. Keep this attitude for ever Thnanks once again Kalyan On Fri, Sep 10, 2010 at 10:58 AM, C.G.Kumar wrote: > Hi Kalyan, > > Please find enclosed file as modified to suit your requirement. > > Hope it serve the purpose. > > > Regards, > > > C.G.Kumar > > > > On Thu,

$$Excel-Macros$$ Re: Lookup from date series

2010-09-10 Thread C.G.Kumar
Hi Kalyan, Please find enclosed file as modified to suit your requirement. Hope it serve the purpose. Regards, C.G.Kumar On Thu, Sep 9, 2010 at 3:21 PM, Kal xcel wrote: > Hi Kumar, > > Please find the attached file. > > Thanks in advance > > Kalyan > --