VBA: Pasting data into excel that may contain an "

Morning - hoping someone can point me in the right direction.

I have a very simple vba script that takes 2 worksheets and compares them, looks for differences, all is good.

The data is coming from an SQL database.

The problem i have, is sometimes one of the cells in SQL contains just a "

If this happens, as expected the rest of the cells all get pasted in wrongly into 1 cell as its expecting a string i guess.

I have the cells set as Text in the cell formatting, this doesn't help.

Any idea, or is this just not possible?

Cheers!

Kev

I can, but the issue isn't running any code (not sure why it was moved into this section), the issue is a simple pasting of data into a sheet, at this point there is no code running at all

There isnt really anything to upload, if you take a blank workbook and paste data which contains " in the cells, it happens.

It was moved to this section because of the Title - VBA: Pasting data into excel that may contain an " and that you say you're using a VBA Script.

The problem is, we don't / can't see the data being pasted in - We can't recreate your data because we don't know anything about other than it comes from an SQL Query.

We can't just pick a random sample of data that we use and expect it to in anyway correlate to your problem

You need to provide some kind of example of the Data and how it is being pasted in.

What part does the VBA Script you mention play in any of this?

What does the data look like in it's raw form?

Are you just copying and pasting from some database program?

Are you exporting it as CSV (or some other kind of file) and then copying and pasting?

Are you using the Text Import Wizard to get the data into Excel?