|
VBA/Excel question At work I have to deal with a file which is generated by a till which to the untrained eye is just a jumble of meaningless numbers, but actually contains product numbers, transaction numbers, cashier id, credit card numbers, etc. I need to check that this file is correct. I've come up with the idea of using a VBA script which parses this data, puts things in different colors so they become more human readable. This works pretty well. But the problem I have is, the file is essentially a text file. To open it and run a parsing script and I need to open it in Excel, convert it into an XLS spreadsheet, then import VBA code before it does it's magic. Essentially my VBA script is almost a way of allowing Excel to open and display a new file format. It would be great if I just could click File | Open and it would automatically parse the file. Is there any way to do this?
|
# ¿ Aug 18, 2010 19:48 |
|
|
# ¿ May 6, 2024 11:00 |