Hello All!!!
I built a macro to process CSV data sets. A website generates the data set and the macro processes them. I'd love to store a copy of the client's logo in macro file and move it to the data set after it is processed. I've found ways to do this if the file name is known but I'll be dealing with a different file name every time a data set is generated. The macro obviously knows which file it is acting on. Is there a way to copy and paste the image from the macro file to the target file without knowing the exact file name? Thanks!!
I built a macro to process CSV data sets. A website generates the data set and the macro processes them. I'd love to store a copy of the client's logo in macro file and move it to the data set after it is processed. I've found ways to do this if the file name is known but I'll be dealing with a different file name every time a data set is generated. The macro obviously knows which file it is acting on. Is there a way to copy and paste the image from the macro file to the target file without knowing the exact file name? Thanks!!