I have tried to invoke a macro or even VBA code, but nothing changes. I suspect that is being there is “no third column” as it’s reading the file as a tab delimited “text” file. I saw this when I ran the use case in debug mode.
I am able to “start process” opening this file with the tab delimited columns separated and then I can manually change the date formats, but I need it to be automated and you can’t (so it seems) invoke VBA unless it’s within an excel process scope, which would negate the “start process”.
I have also checked my system settings and my short date DOES NOT include that stupid time stamp thing.
So I am really at a loss here. Anyone have any experience with this? Been a real pain to work on this one part.
So I did try that with a “write to CSV” and it was slow as molasses in Winter. So I just did the “export” to csv as you have here, much better performance but coming up comma delimited. Perhaps I will now take that csv file and make it pipe? Trouble is I wonder if that time stamp will return. Worth a chance, nothing else has worked.
Actually, what I did was follow what Irtetala noted, this is the exact thing I did to get it
Use Excel file and read formatting as “display value” (as the suggestion called for)
EXPORT this foundation file to csv
It produces a comma delimited so all i do after that is I read the previous csv file I created and then write it to the final file with the pipe delimited.
