Problems with Pasting data from an .csv-file into an .xlsm-file

Hi all,

I have a problem that I cannot understand:

1. First I manually copy either the whole sheet, or only whole columns A:C from a .csv-file (don't think it matters if I copy from a .csv-file or .xlsm-file here, I probably get the same problem)

2. I go to an already open .xlsm-file and press a button to run some code;
The code first creates a new sheet and gives it the name “tempSheet”.
Then, in this new sheet the code are supposed to paste the copied data, starting from cell “A1”, but I get an error doing just that!

I’ve tried using Activesheet.Paste, Sheets("tempSheet").Range("A1").PasteSpecial xlPasteValues and other combinations, but I don’t get it to work.

How do I paste this, so that it really works every time?

Please, help!

Hi,

The "tempSheet" is in the file containing the code!

Please Login or Register  to view this content.

1. First I manually copy either the whole sheet, or only whole columns A:C from a .csv-file (don't think it matters if I copy from a .csv-file or .xlsm-file here, I probably get the same problem)

I copy the data (3 columns or whole sheet) from another file and via code want to paste it in the main file.
Why isn't it possible? Is it because I first create a new sheet ("tempSheet") to paste it in?

I hope this is as per the understanding issue....
It will refresh the data too.

Please Login or Register  to view this content.

Good Luck
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember......Mark Thread as Solved.
Excel Forum Rocks!!!

I’m sure this is a good way to do it, if the .csv-file was saved to begin with.
(The .csv-file is genererated from a program as a temporary report, i.e. not saved,just open.)

Can anyone explain why it doesn’t work in my simple way?

How come I cannot just copy columns/sheet from an open (not saved) .csv-file and easily paste the data into an .xlsm-fil?

Perhaps a segment of this video, beginning at the 24:15 mark, will help to explain as well as provide a possible solution (since you have the subscription version of Excel).
https://www.bing.com/videos/search?q...5411&FORM=VIRE
Let us know if you have any questions.

Hi JeteMc,

Thanks for the tip.
As I understand this video I would need to install “Power Query” which I’m not at all familiar with …

The .csv-file is a report downloaded from another system, and it’s just open, not saved, when I copy data (columns A:C or whole sheet) from it.
I would first need to save the .csv-file, to be able to import it, but that’s is a step I’d rather avoid.

But, would importing the .csv-file, instead of copy/pasting it, be the solution?
What I still don’t understand is that if I copy/paste manually it works great, but if I manually copy data from .csv-file and then start the code to paste it, it doesn’t work at all?!


(I’m doing this in Excel 2010, at work (Excel 365 is at home), which means some difficulties installing things only on just my version.

The 365 version should already have Power Query at the left end of the Data tab ribbon (it is called Get & Transform Data), however I don't think that you can use it with the 2010 version. VBA is not something that I have enough experience with to be able to help further. I wish you the best.

JeteMc:
Ok, I'll look into that about Power Query/Get & Transform Data.

Thank you!