Open, Copy, and Paste Excel Data from Desktop File: 1.xls, Macro, A:N Columns, First Sheet

Question

Hello
I have a 1.xls file. How to write code to a macro that would open a file from the desktop (indicated by me), copy everything from the first sheet from the A: N columns and paste everything into the Data sheet to the A: N columns in the 1.xls file?

adamas_nt · Answer

1. Record the macro that performs the above actions, analyze. 2. Take a look here , next here 3. Connect, remove excess code 4. If something does not work, please describe in the forum.

zbysiomysio · Answer

Thanks for pointing. I recorded and converted the jn macro. I have only one question, i.e. the source file with the macro will be run on different computers. Is it possible for every computer to show a default window to indicate a file from the desktop (so that users do not have to look for the file to be copied, and have a preview of the desktop where the file will be copied from)?

Log in, to see the code

Moderated By adamas_nt:
Please put the code between the Syntax tags

adamas_nt · Answer

FileDialog has many properties. for example: . InitialFileName = Environ (HOMEPATH) & \ Desktop \

zbysiomysio · Answer

Thanks for the help Can anyone else help me what procedure should be given in the above macro so that after copying the columns the file from which the columns were copied is closed and the file to which the columns have been pasted remains open?

clubs · Answer

Hello I just don't understand what a workbook is Windows (Za + Annex 2 to the order.xls contract bill). Activate? Do you have a macro in one, open the second and copy to the third file?

zbysiomysio · Answer

Sorry, it is not understandable but I try by trial and error. Below is the partial code of my macro that looks like this: Code: VBScriptLog in, to see the code Ultimately, this macro is to copy the A: N columns from the file I specified and paste it into the IL worksheet in the gas workbook. The point now is that after copying and pasting these columns the file from which the columns were copied is closed, while the gas application file remains open

clubs · Answer

So in the gaz.xls application you have this macro above?

zbysiomysio · Answer

Yes

clubs · Answer

Code: VB.netLog in, to see the code

zbysiomysio · Answer

Thanks . I haven't mastered it yet, but I understand that if it is to paste into worksheet 3, then after wkb1.Sheets should I put (3)? And what else to add and in which place to clean sheet 3 before pasting? I had it: Sheets ("Sheet3"). Select Cells.Clear
[quote] wkb2.Sheets (1) .Columns ("A: N"). Copy wkb1.Sheets (1) .Columns ("A: A") [quote]

Added after 13 [minutes]:

I already know that you need to improve on Sheets (3), but whether in this code can still be pasted cleaning this sheet3 before pasting

clubs · Answer

Code: VB.netLog in, to see the code

zbysiomysio · Answer

cool Thanks so much for your help. I'm closing the topic.

Open, Copy, and Paste Excel Data from Desktop File: 1.xls, Macro, A:N Columns, First Sheet

Post #1

Post #2

Post #3

Post #4

Post #5

Post #6

Post #7

Post #8

Post #9

Post #10

Post #11

Post #12

Post #13

Topic summary