Jul 23, 2003 #1 Russie Programmer Dec 24, 2000 104 US Hi. I can do practically anything with a CSV file from VBA apart from to simply open it for viewing. Does anyone know how to view a CSV file from VBA code? A star for a correct answer. Thanks. Russie
Hi. I can do practically anything with a CSV file from VBA apart from to simply open it for viewing. Does anyone know how to view a CSV file from VBA code? A star for a correct answer. Thanks. Russie
Jul 23, 2003 1 #2 oharab Programmer May 21, 2002 2,152 GB Have a look at the code in my FAQ:faq705-1971 Just pass the name of the csv file & it will open in whatever file you usually view csv files in! hth B ---------------------------------------------- Ben O'Hara http://www.RobotParade.co.uk "Where are all the stupid people from... ...And how'd they get so dumb?" NoFX-The Decline ---------------------------------------------- Upvote 0 Downvote
Have a look at the code in my FAQ:faq705-1971 Just pass the name of the csv file & it will open in whatever file you usually view csv files in! hth B ---------------------------------------------- Ben O'Hara http://www.RobotParade.co.uk "Where are all the stupid people from... ...And how'd they get so dumb?" NoFX-The Decline ----------------------------------------------
Jul 23, 2003 Thread starter #3 Russie Programmer Dec 24, 2000 104 US Excellent. Many thanks. Upvote 0 Downvote