VBA Code-csv file into excel- from general to text

[michelcr7]

I have a “.csv” file. Now we would like to copy data from this file into another Excel file. Doing this with my simple macro, I encounter a problem in some columns as I have numbers which are stored there in the format: “0000” and “01234567890”. Pasting the data makes then a “0” or “E09” out of the former source.

If I did that manually, I would do the following:

1.Copy from .csv file
2.Paste > “use text import wizard” > changing the respective fields (LFNR_... and EXTERNAL_ID) from “general” to “text”.
3.Would be happy – everything looks fine

This is current macro:

Please Login or Register  to view this content.

Do you know a trick how to paste csv-data into an excel spreadsheet keeping the data okay?

[JLGWhiz]

You could try

Please Login or Register  to view this content.

[6StringJazzer]

michelcr7 Please take the time to review our rules. There aren't many, and they are all important.

Your post does not comply with Rule 8 of our Forum Rules: Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you must provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (most other forums have the same rule).

This thread should have no further posts until links to the cross-posts are provided.