Log In
Register
Home
June 26, 2016
Offline
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_Image\Image_Base.jpg", ";", True, True, False)) MsgBox "Fatto!" 1: End Sub
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
A CSV is a text file: you cannot have anything else except text in a csv, no images, no formatting, no objects.
June 26, 2016
Offline
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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?
June 26, 2016
Offline
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
1 Guest(s)
