Importing a csv File to a range

[Rick Rothstein]

Rick,

I got the file extension incorrect because I have been to the CVS drug store 1 too many times.
One item of note, is that I need to programmatically place the contents of your CSV file into Workbook B but done in the 67 milliseconds it took for your original code to create the file. I was assuming that the code would appear similar in structure. In other words, to programmatically open the file and do a copy and paste, like i would probably do, would take too long.

How about something like this...

Sub OpenPicassoPg()
  Workbooks.Open "c:\Temp\PicassoPg.csv", Format:=2
End Sub

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA