Write cells from excel cells to notepad files

Hi,

Hope you can help.

I have used some VB to create a macro that places the contetnts of an excel cell into an existing notepad file called NewUser.txt. It is working well, however inverted commas apear before and after the contents of the cells after they have been written to notepad.
Is there anyhing I can do to stop the inverted commas appearing?

Also are there any risks with what I have written in terms of the system writting data and using #1 at the same time as my macro runs? A friend has suggested using 'Put' instead of 'Write' however I do not know how to do this.

The code I am using is as follows:

Please Login or Register  to view this content.

Thanks in advance for your help

Hello pacman76,

Welcome to the Forum!

I am not sure what you are referring to when you say inverted commas. Can you provide an example. In the mean time, here is some information about how the Write # statement saves data.

The Write # statement follows several universal assumptions so the data can always be read and correctly interpreted regardless of locale:

1. Numeric data is always written using the period as the decimal separator.
2. For Boolean data, either #TRUE# or #FALSE# is printed. The True and False keywords are not translated, regardless of locale.
3. Date data is written to the file using the universal date format. When either the date or the time component is missing or zero, only the part provided gets written to the file.
4. Nothing is written to the file if outputlist data is Empty. However, for Null data, #NULL# is written.
5. If outputlist data is Null data, #NULL# is written to the file.
6. For Error data, the output appears as #ERROR errorcode#. The Error keyword is not translated, regardless of locale.

Hi pacman76

What you need to do, is change 'Write' in your code to 'Print'. And that should solve your inverted comma/quotes problem.

Please Login or Register  to view this content.