talkinggoat
New Member
- Joined
- Feb 1, 2022
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
I need to export a spreadsheet to CSV, but:
I was thinking of using a for loop with a nested if statement, something like:
for row
if row is in column1
change the delimiter to value & space(16)
else
output as tilde
next
I've only been using VBA for about 6 days, so I'm not sure how to do it and combine that to a file. I can do it in PowerShell and I have created a working script, but I'd like to cut out that step.
- The import application needs exactly 16 spaces as the delimiter between the first column and the second column.
- The commas need to be tilde.
I was thinking of using a for loop with a nested if statement, something like:
for row
if row is in column1
change the delimiter to value & space(16)
else
output as tilde
next
I've only been using VBA for about 6 days, so I'm not sure how to do it and combine that to a file. I can do it in PowerShell and I have created a working script, but I'd like to cut out that step.