Re: $$Excel-Macros$$ Excel VBA Project in Google Docs

2013-09-09 Thread Abhishek Jain
Friends,...any update? On Sat, Sep 7, 2013 at 11:21 AM, Abhishek Jain wrote: > Hello friends, > > Let's say I have an Excel File with VBA and an a Form that is used to make > entries in sheet. Is there a way I can make a Google Doc of it keeping the > Form and all the VBA? I searched and found t

$$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

2013-09-09 Thread Chih Hung Choo
Hi, I'm hoping to get some help here to automate the work that I have to do every 2 weeks. The work is repetitive and hopefully a VBA script will help shorten sometimes a day's work to minutes. I'm using Excel 2007. There are 2 files. File A: This file is generated every 2 weeks. The data I

Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-09 Thread ashish koul
Sub copy_sheet() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim fld As Object, fil As Object, fso As Object Dim wkb As Workbook Set fso = CreateObject("scripting.filesystemobject") Set fld = fso.getfolder("C:\Users\admin\Desktop\test") ' folder having files For Each f

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread ashish koul
have you tried datedif function http://www.techonthenet.com/excel/formulas/datedif.php On Mon, Sep 9, 2013 at 6:58 PM, sridher sharma wrote: > No One there to resolve my problem ??? > > > > On 9 September 2013 17:25, sridher sharma wrote: > >> Thanks for your response. >> >> I h

$$Excel-Macros$$ Macro needed to add worksheet

2013-09-09 Thread SG
Hi Experts, Once again I neeed your help.I have one excel worksheet which is common for all workbooks. However, that worksheet is not added in the workbooks. I have atleast 50 excel workbooks in a folder in which i have to add that single worksheet manually.The name of all worbooks are same o

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread sridher sharma
No One there to resolve my problem ??? On 9 September 2013 17:25, sridher sharma wrote: > Thanks for your response. > > I have a spreadsheet where there is a date range say 01-01-10 to 01-01-13. > Now, I need the difference in the date range expressed in terms of years. > So, l

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

2013-09-09 Thread Angel Araneta
everything works out fine with my original formula except for time-in is on or about 11:15 AM and time-out is 12:00 PM, this is the only range where i get a FALSE result.. On Mon, Sep 9, 2013 at 2:46 AM, Waseem Saifi wrote: > Please use ROUND function while subtract. > > Because while subtracti

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread sridher sharma
Thanks for your response. I have a spreadsheet where there is a date range say 01-01-10 to 01-01-13. Now, I need the difference in the date range expressed in terms of years. So, leap year should also be taken in to account for the same. Can you please refer me a function or a formulae for this?

$$Excel-Macros$$ Re: how to crack Excel VBA password

2013-09-09 Thread Brett Campbell
Public Sub AllInternalPasswords() ' Breaks worksheet and workbook structure passwords. Brett Campbell ' probably originator of base code algorithm modified for coverage ' of workbook structure / windows passwords and for multiple passwords ' ' Brett Campbe

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread Sandeep Kumar Chhajer
Dear sridhar, I did not get you how leap year or non leap year affecting your result. Can you send us example. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: sridher sharma Sender: excel-macros@googlegroups.com Date: Mon, 9 Sep 2013 16:22:16 To: Reply

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread sridher sharma
yes i used this formula but it is stands valid in case of Non- leap years, Please give me a formula for leap years. On 9 September 2013 16:18, Ravi Kumar wrote: > Did u try this formula… > > ** ** > > ** ** > > Principle(1+rate/100)^month > > ** ** > > Like > > ** ** > > 500(1+5/1

RE: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread Ravi Kumar
Did u try this formula. Principle(1+rate/100)^month Like 500(1+5/100)^5 Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sridher sharma Sent: Monday, September 09, 2013 4:08 PM To: excel-macros@googlegroups

$$Excel-Macros$$ EX-QUERY

2013-09-09 Thread sridher sharma
Dear member plz help me ** I am calculating compound interest on loan over a period where interest is compounded either Monthly, Quarterly, Semi- Annually and Annually. But it is stands valid in case of Non- leap years. Please give me a formulae for leap years. ** ** *Regards,* *SRID

Re: $$Excel-Macros$$ combined formula required.

2013-09-09 Thread Kenil Gala
I have explained it from start again, Hope if i have explain it properly this time. Thanks in Adv. From: xlstime To: excel-macros@googlegroups.com Sent: Monday, September 9, 2013 10:38 AM Subject: Re: $$Excel-Macros$$ combined formula required. still not

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

2013-09-09 Thread Waseem Saifi
Please use ROUND function while subtract. Because while subtracting answer is (In General Format) = 0.03472223 and when you determine in formula =timevalue("0:50:00"), it's value is (In General Format) = 0.0347 You can use =ROUND(E2-D2,15) or 14 or 13 in num_digits, But no mor

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

2013-09-09 Thread xlstime
Please add false statement =IF(AND(F2<=TIMEVALUE("0:50:00"),F2>TIMEVALUE("0:30:00")),"RV",IF(AND(F2<=TIMEVALUE("1:00:00"),F2>TIMEVALUE("0:51:00")),"IE",IF(F2=TIMEVALUE("0:00:00"),"MV", *"")*)) . Enjoy Team XLS On Mon, Sep 9, 2013 at 12:33 PM, Angel Araneta wrote: > >

$$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

2013-09-09 Thread Angel Araneta
why do i get a "FALSE" result with this formula in cell G2? cell G2 has the formula: =IF(AND(F2<=TIMEVALUE("0:50:00"),F2>TIMEVALUE("0:30:00")),"RV",IF(AND(F2<=TIMEVALUE("1:00:00"),F2>TIMEVALUE("0:51:00")),"IE",IF(F2=TIMEVALUE("0:00:00"),"MV"))) value of cell D2 is 11:30 AM value of cell E2 is