Hello everybody
My Problem is this:
On an excel sheet I created a function that creates and exports the file in Csv format to my sub-folder called (attachments)
And so far everything is ok
Now what I would like to know and be able to solve would be to insert in the (Csv) also the image that is in the excel sheet; As it gives me everything except the image
Therefore I ask you if there was a way to upload this image as well. Thanks
Greetings from A.Maurizio
(P.s)
My code is the following:
Sub Crea_Formato_In_Csv() On Error GoTo 1 Dim NomeFile As String Dim Estensione As String Dim shapes As Shape NomeFile = Foglio1.Range("M1").Value Estensione = Foglio1.Range("M2").Value Last_Row = Foglio1.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Last_Col = Foglio1.Cells.Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column Call ExportRangeAsDelimitedText(ThisWorkbook.Name, _ "Foglio1", Range("A1:D25"), ThisWorkbook.Path & "Allegati" & NomeFile & Estensione, ";", True, True, False) Call ExportRangeAsDelimitedText(ThisWorkbook.Name, Sheets("1.Csv"), shapes("Rettangolo 1").Picture, _ LoadPicture(ThisWorkbook.Path & "Base_ImageImage_Base.jpg", ";", True, True, False)) MsgBox "Fatto!" 1: End Sub
A CSV is a text file: you cannot have anything else except text in a csv, no images, no formatting, no objects.
Hi Catalin Bombea how are you?
Everything good.
Thanks for your clarification and professionalism
Maq not only imagined it, but last night I did not have direct confirmation, as after having perfected my project in all its parts.
I tried to do the most trivial thing that could be done, which was to manually put that image and then save it that way.
And I made them the discovery that in the moment in here I pressed the save as button.
Punctually I got a writing that explained in broad outline what you just said.
With two Options: If I pressed yes, I kept the Original Format.
What if I pressed No; Which I then did.
I could have saved everything in another format with image.
What is basically an Excel sheet and no longer Csv that's all.
But it doesn't matter, that's fine!
The important thing is not only to have understood everything; But also how to create all the various formats in a single project.
Thanks for your interest. Sali da A.Maurizio
Punctually I got a writing that explained in broad outline what you just said.
What do you mean? Where do you got the writing from?
Nothing important
the message comes out due to the error evaluator.
So when I tried to manually insert the image into the newly created Csv File, and then I tried to save everything again.
This office error check explained to me that it was not possible to save a csv with an embedded image; As he was just a text file.
Pero 'Pressing yes: I could have saved the file without image
While if I had pressed the No key I could have saved everything with the embedded image; But doing so would have changed the Format from Csv to Excel
That's all
