Re: $$Excel-Macros$$ Best? Ms Excel vs Ms Access?

depends on requirement... Access best as Database and Excel best as BI tool . Enjoy Team XLS On Sat, May 17, 2014 at 11:43 AM, Kannan Excel wrote: > *Dear Friends,* > > *Please tell which is the best one, Ms Excel or Ms Access?* > > -- > Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Multiple value to be picked up

what do you mean by multiple.. . Enjoy Team XLS On Sat, May 17, 2014 at 12:49 PM, Pravin Gunjal wrote: > Hello, > > I have attached an excel file. The data is already entered in this file. > > > The "Qty" column must be multiple of "Pack" column. If it is correct th

Re: $$Excel-Macros$$ Password protected work sheet

try below add in http://www.straxx.com/excel/password.xla . Enjoy Team XLS On Sat, May 17, 2014 at 7:04 PM, Robert Lynch wrote: > We have a form we use at work to report client income/expenses which we > would like to modify, We have been able to make some modificatio

$$Excel-Macros$$ Password protected work sheet

We have a form we use at work to report client income/expenses which we would like to modify, We have been able to make some modifications, but other changes prompt a message indicating that the sheet is protected. When we try to unprotect the sheet, we are prompted for a password. Unfortunatel

Re: $$Excel-Macros$$ ODS TO EXCEL CONVERSION PROBLEM

Cheers!! On Fri, May 16, 2014 at 11:53 PM, renuka chari wrote: > super sir > > > thanks > > > On Friday, 16 May 2014 13:47:00 UTC+5:30, Vabz wrote: > >> Hi >> >> Try this code.. >> >> Sub SaveODSToXLSX() >> >> Dim StrFilename As String >> Dim StrDocName As String >> Dim StrPath As S

$$Excel-Macros$$ Multiple value to be picked up

Hello, I have attached an excel file. The data is already entered in this file. The "Qty" column must be multiple of "Pack" column. If it is correct then it should display: "Correct" otherwise "Incorrect" in "Result" column. Hope you would help me. Thank you. Regards Pravin Gunjal. -- Are