Fw: $$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule *

2012-12-01 Thread respuzy
Hello Gurus i am trying to develop a very dynamic Fixed Asset depreciation schedule but facing a slight formula or logic challenge and as usual seeking your expert advice. Basically what this current schedule does is assuming you want to depreciate your asset for say 5 years, starting from 2013 yo

$$Excel-Macros$$ outline 1 = dropdown in col A, based on this selection, dropdown in col b= outline2

2012-12-01 Thread Blue J
Hi All, I have a sheet named "fruit-sheet" in the attached excel, i have 4 outlines (1 to 4) in it. i need a macro code i need a macro code which does the below: 1) it should get the values which can be seen when outline is 1 (in this case fruits & veg can be seen.) & these values sho

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

2012-12-01 Thread ashish koul
Sub emailstest() Dim i As Long Sheets("list").Select For i = 2 To Range("a65356").End(xlUp).Row Call send_emails(Range("a" & i).Text, Range("b" & i).Text, Range("c" & i).Text, Range("d" & i)) Next End Sub Sub send_emails(nm As String, to1 As String, cc1 As String, rng As

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

2012-12-01 Thread ashish koul
whts in cc email On Sun, Dec 2, 2012 at 10:55 AM, Satendra kumar wrote: > Thank you so much sir, > > but cc email is pick up > > thankx > satendra > > > On Sun, Dec 2, 2012 at 10:46 AM, ashish koul wrote: > >> >> Hi >> >> Try the attached file >> >> - change the folder path in code. >> >>

Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK

2012-12-01 Thread ashish koul
Hi Try the attached file - change the folder path in code. Regards, Ashish Koul On Fri, Nov 30, 2012 at 10:15 AM, Satendra kumar wrote: > Dear Sir, > > I am not expert in vba, i am beginner vba so please me suggest me where is > add loop?? > > > thankx > satendra > > > > > On Thu, Nov 29, 201

$$Excel-Macros$$ Excel & Google Map Integration

2012-12-01 Thread ashish
Hi Group, If anybody wants to create Google Geo Charts in Excel visit below links and download the working files to try them. To know more about Google Charts Visit https://developers.google.com/chart/interactive/docs/gallery/geochart. (*Snapshot of Google Geo chart below*)

Re: $$Excel-Macros$$ Scraping data from image

2012-12-01 Thread XLS S
Asa, Useful information for us Thanks Sent from my iPhone On Dec 1, 2012, at 9:06 AM, "Asa Rossoff" wrote: > P.S., Hanumant, here is a link with detailed instructions for using OneNote > for OCR: > > http://www.howtogeek.com/howto/14595/ocr-anything-with-onenote-2007-and-2010/ > > Asa >

Re: $$Excel-Macros$$ credit card due date formula

2012-12-01 Thread XLS S
Use Text formula for month like =text(d2,"") and u can use text with iferror formula Sent from my iPhone On Dec 2, 2012, at 12:43 AM, Hemantpokharkar wrote: > Dear All > > Kindly help me to solve the problem > > I have a excel sheet were i have required a formula which will show me the

$$Excel-Macros$$ credit card due date formula

2012-12-01 Thread Hemantpokharkar
Dear All Kindly help me to solve the problem I have a excel sheet were i have required a formula which will show me the credit card month or the cycle or the due date. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate t

Re: $$Excel-Macros$$ Heplp Required

2012-12-01 Thread Eugene Bernard
Hi Neeraj, Try these rwo statements. =TODAY()+RANDBETWEEN(1,31) =TIME(RANDBETWEEN(1,12),RANDBETWEEN(0,60),RANDBETWEEN(0,60)) Regards Eugene On Sat, Dec 1, 2012 at 10:48 AM, neeraj chauhan wrote: > Dear Experts, > > i want randomly time and date like > > > 10:43 AM 10:50 AM 10:05 AM 11:10

$$Excel-Macros$$ Need help atpvbaen.xlam and eurotool.xlam suddenly show up in vba ide why?

2012-12-01 Thread bpascal123
Hi there Does anyone know the reason .xlam files suddenly show up in the vba ide? I understand these are files from genuine microsoft office addins pack, I don't recall any action with addins lately and until then I only had current workbook and personal showing up as object with or without mod

$$Excel-Macros$$ IF Query

2012-12-01 Thread nm
hi, pls find the file attached and solve my query thank you in advance Nik -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Fwd: $$Excel-Macros$$ Heplp Required

2012-12-01 Thread neeraj chauhan
Dear Experts, i want randomly time and date like 10:43 AM 10:50 AM 10:05 AM 11:10 AM 1:07 PM 20-Nov-12 19-Nov-12 2-Nov-12 11-Nov-12 6-Nov-12 24-Nov-12 18-Nov-12 27-Nov-12 4-Nov-12 1-Nov-12 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM