$$Excel-Macros$$ Need help in creating macro

2014-07-24 Thread Jocky Beta
Hi team, I need some help in creating macro for an excel sheet. I have worksheet in which 18 nos of in and out transaction are reflected. I need macro for any one of transaction out of these 18 is missed it shuld show a popup message stating that transaction Your help on the same will be apprecia

Re: $$Excel-Macros$$ Getting syntax error for a basic vba code

2014-07-24 Thread Rohan Kapuria
Thanks Paul...I guess that must have been the issue... I had copy pasted this code in the vba editor from a pdf...when I erased it and typed it myself the errors went away... Thanks for the reply! On Friday, 25 July 2014 00:07:40 UTC+5:30, Paul Schreiner wrote: > > It looks like the code you

Re: $$Excel-Macros$$ Getting syntax error for a basic vba code

2014-07-24 Thread Paul Schreiner
 It looks like the code you copied was modified by an editor. Some editors use what is called "smart quotes"   The instead of simple double-quotes (") they use an "opening quote" (“) and a "closing quote" (”) so your quoted string looks like: “Is your name ” These quote are not allowed in VBA. s

$$Excel-Macros$$ Getting syntax error for a basic vba code

2014-07-24 Thread Rohan Kapuria
Hi all, I am new to excel VBA and I copied this peace of code from excel vba for dummies and i am getting a compile error (syntax error) The option to declare variables explicitly is off. Error statements marked in RED Need help! Sub GuessName() Msg = “Is your name “ & Application.UserName & “

$$Excel-Macros$$ Urgent required Java Developer - Dublin, OH

2014-07-24 Thread Gary .
Please respond to *gurjant.si...@damcosoft.com * *Position: Java DeveloperLocation: Dublin, OH Duration: 6+ Months* positions: 5 *Need Photo ID Proof at the time of Submission* Technical Skills: •*Core Java*, REST Webservices, Maven, Servlets •Good to have – Exposure to messaging (Rab

Re: $$Excel-Macros$$ need macro

2014-07-24 Thread Vaibhav Joshi
Hi Check this file. In sheet 1 Cell A1 put begining date, in cell B1 put date put formula =A1+10 so that on the tenth date after date mentioned in cell A1 macro will work. You need to hide row 1 & also hide sheet1 & set property very hidden. after that lock macro. When file is opened macro will

$$Excel-Macros$$ need macro

2014-07-24 Thread SUDHIR VERMA
Dear Experts, I need macro, which can encrypt with password after defined no of days. Example- i make file today, after 20 days it will password protect automatically. So someone couldn't open in my absence. Thanking You Regard Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do