drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
Is there any easy way of opening a CSV File from VBA once you know the FullName but in multiple columns
If I use:
I will Open the CSV File in a new Workbook but the CSV's Info is gonna be in a single Column, (Column A)
Is there a way to open the File From VBA in multiple Columns, the same way we do from DATA\Get External Data\From Text\...
Or the same way we see the File when opening directly from Windows Explorer
Is there any easy way of opening a CSV File from VBA once you know the FullName but in multiple columns
If I use:
VBA Code:
Sub OpenCSVFile()
Dim wFxFN As String: wFxFN = "C:\Users\HiHello\Desktop\GodSaveTheQueen\CSV Files\AAA_202007.csv"
Workbooks.Open Filename:=wFxFN
End Sub
Is there a way to open the File From VBA in multiple Columns, the same way we do from DATA\Get External Data\From Text\...
Or the same way we see the File when opening directly from Windows Explorer