Re: $$Excel-Macros$$ Importing Excel Files

2013-12-30 Thread Linda C
Thanks Ashish & Anoop! On Monday, 30 December 2013 09:44:29 UTC-5, ashish wrote: > > please find updated file attached > > Regards > Ashish > > > On Mon, Dec 30, 2013 at 10:47 AM, Anoop K Sharma > > > wrote: > >> just use below line >> >> Application.GetOpenFilename ("All Excel File (*.xls*),*.x

$$Excel-Macros$$ Re: I have a problem adding two columuns and subtracting a 3rd from the first two.

2013-12-30 Thread Basole
share your spreadsheet, indicating the result you need with regards Mr. Basole Em segunda-feira, 30 de dezembro de 2013 20h33min59s UTC-2, JJ escreveu: > > > I have a spreadsheet, to keep my Craps game activity straight. > I've used it from the very beginning of my play. The only columns I have

$$Excel-Macros$$ Re: I have a problem adding two columuns and subtracting a 3rd from the first two.

2013-12-30 Thread JJ
On Monday, December 30, 2013 5:59:53 PM UTC-5, Basole wrote: > > Hi JJ, pls. share an example highlighting the results you need. > > > > regards, > > Basole. > > Mr./Ms. Basole, > Please tell me what I can provide in addition to my post. JJ > > Em segunda-feira, 30 de dezembro de 2013 20h33m

$$Excel-Macros$$ Re: Listbox data adding problem

2013-12-30 Thread Basole
Hi renuka chari, solve your problem? Basole Em domingo, 29 de dezembro de 2013 13h46min05s UTC-2, renuka chari escreveu: > > Dear Experts, > > Please provide the solution for the attached worksheet. > > problem was written in the excel please go through that. > > thanks > > -- Are you =EXP(E:RT

$$Excel-Macros$$ Re: I have a problem adding two columuns and subtracting a 3rd from the first two.

2013-12-30 Thread Basole
Hi JJ, pls. share an example highlighting the results you need. regards, Basole. Em segunda-feira, 30 de dezembro de 2013 20h33min59s UTC-2, JJ escreveu: > > > I have a spreadsheet, to keep my Craps game activity straight. > I've used it from the very beginning of my play. The only columns

$$Excel-Macros$$ I have a problem adding two columuns and subtracting a 3rd from the first two.

2013-12-30 Thread JJ
I have a spreadsheet, to keep my Craps game activity straight. I've used it from the very beginning of my play. The only columns I have so far are these: Date, Buy-in amount, Cash-out amount, WINS, LOSSES, table minimum, fuel expense, lunch expense So, now I'm needing to add two new columns

Re: $$Excel-Macros$$ I appreciate your help for building a macro

2013-12-30 Thread ashish koul
Sub write_to_notepad() Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") Dim oFile As Object Set oFile = fso.CreateTextFile("C:\Users\admin\Desktop\fb page problem\" & Range("a1").Value & VBA.Format(Range("a2").Value, "_dd_mm__hh_mm_ss") & ".txt") For i = 10 To 45 oF

$$Excel-Macros$$ I appreciate your help for building a macro

2013-12-30 Thread Gopalakrishnan Manikandan
Hello experts, I need an another macro, a keypad shortcut triggered macro (Ctrl+j), which will copy ranges "A10:A45", create a new text file on the desktop, paste the ranges, save the file taking ranges A1 &A2 as the file name. A2 will contain this formula "=now()" I appreciate the help pr