Log In
Register
Home
June 26, 2016
Offline
Hello everyone, my name is Maurizio and my problem is this:
On an Excel sheet I inserted two keys that have a function inside it written in VBA for:
1) Create a TXT File and transport the Data from Del Foglio on it.
2) On the contrary, the second key should retrieve the data from the TXT file and rewrite it on the Excel sheet; So far so good.
Except for a fact that I would like to avoid: That when I recover the data from the TXT file and I report it on the Excel sheet, I see the double quotes ("")
So I wish they were not there; How can I avoid this?
Where did I go wrong ?
This is the link to download my workbook:
https://app.box.com/s/56sx4f47.....1nnc6lxlj6
Thanks, Greetings Sinceri from A.Maurizio
October 5, 2010
Offline
Hi Maurizio,
You need to change this line
RigaF = Split(Replace(lineafile, Chr(34), ""), ",")
Your text file has each line wrapped in double quotes = Chr(34) , the Replace function removes these.
I've also modified the Split function so that it splits on the , rather than *,*
Read more on VBA String Functions
Regards
Phil
June 26, 2016
Offline
Hi Philip Treacy Thanks for the tip and true !!!!!
As without doing it on purpose I had not noticed that mistake, and to think that in another file I had done a long time ago; he worked very well.
Here is the reason for my question.
Anyway Thanks Infinite.
I take this opportunity to make you and to all your staff of this wonderful community: my most sincere wishes for good holidays Hoping that 2019 will bring you so much luck to you and your family.
Sincere Greetings from A.Maurizio
1 Guest(s)
