Automatically Update Delimited/Comma Seperated File Options
Hi,
I have an exported file saved which has all it's values in Column A, with each value seperated by ". If I open the file manually, I can go through the steps to seperated the values, which is fine. However, I have a sub which is going to open my delimited file overnight, so I would like to automatically amend the file, seperating the values. I have Application.Dialogs(xlDialogTextToColumns).Show, but it requires user input, which is a no-no. Cheers Tony |
Automatically Update Delimited/Comma Seperated File Options
Go to tools Menu - Macro - Record Macro. Then go through the steps manually.
Use this code in your subroutine. If there is problems post the code so it can be corrected as needed. "bony_tony" wrote: Hi, I have an exported file saved which has all it's values in Column A, with each value seperated by ". If I open the file manually, I can go through the steps to seperated the values, which is fine. However, I have a sub which is going to open my delimited file overnight, so I would like to automatically amend the file, seperating the values. I have Application.Dialogs(xlDialogTextToColumns).Show, but it requires user input, which is a no-no. Cheers Tony |
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com