Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following:
1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a ":". There has to be some way to automate this process via macro or otherwise.
2. Change each cell/row/column that has the access color value into its corresponding color.
Example: Color value "13619151" changes the cell to the corresponding access color. Is there anyway that excel can see this particular translation?
So far I haven't been able to find a program that can do this for me, nor could I get any tips as to automate the process via Macro or whatever.
April 2, 2008 3:14 PM
April 3, 2008 1:42 PM