$$Excel-Macros$$ copy file via vba

2014-01-15 Thread Pekon
Dear group, I have a only small question: Is it possible to make copy of a file via VBA eg make a copy of a file with name:*D:\data\sample1.txt* and name the new file *D:\data\sample2.txt * Kind regards, Peter -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ define sort range

2013-08-22 Thread Pekon
Dear experts I hope that you can help me. In the attachment you will find an example file. I try to to sort a part of the worksheet with a macro. 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

$$Excel-Macros$$ Importing data into excel

2010-10-01 Thread Pekon
Hi, I am quit new to excel. I like to know if it is possible to import data from one excel document into another. The most ideal solution would be that after starting up an excel file you can somehow specify another excel file and import the data from that file into the file you opened. The data