Re: $$Excel-Macros$$ Re: copy file via vba

2014-01-18 Thread Peter Konijn
Dear pmyk Thanks a lot. The code works fine Kind Regards Peter 2014/1/18 pmyk > Try this : > [code] > Private Sub cmdCopyTextFileToAnotherTextFile_Click() > FileCopy "D:\data\sample1.txt", "D:\data\sample2.txt" > End Sub > [/code] > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ define sort range

2013-08-22 Thread Peter Konijn
> For some reason I cannot use a refer to cell G4 (with the range of the > table to be sorted) in the macro. > > Who can give me the right code? > > > Kind Regards > > Peter Konijn > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d

Re: $$Excel-Macros$$Help with macros automatic formulas.

2011-02-02 Thread Peter Konijn
Hi, Coild the problem be the fact that the calculation option is on manual? Greets Peter 2011/2/2 Hector Ruiz > Hi all, I made a macro to do a consultation with automatic cell ranges, > with letters running but when the result is number does not work, I have > to double click to run the Forumu

Re: $$Excel-Macros$$ Importing data into excel

2010-10-04 Thread Peter Konijn
Hi, It works, thanks a lot for your support. I am still curious for the macro of Deepak Rai. Regards Peter 2010/10/3 P.VIJAYKUMAR > Dear Peter, > > You can Import Data From Data Menu.In DATA Menu Go to Get External Data, > then select Existing Connections,then you will get a dialog box,in t

Re: $$Excel-Macros$$ Importing data into excel

2010-10-01 Thread Peter Konijn
Dear Vijay, In the DATA menu of Excel I have options for Web, Text, Acess, and other source, I do not have a button for excel-files. I already tried several option in the menupath but I couldn't let it work . In the attachment an example. In practice there are several 100's of datafiles. The prob