Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filename Problems
I currently have a excel macro that pulls information from the excel columns
and adds it to the filename. Then, the macro will convert to csv file. A column exists in the file called EMPLOYER NAME. An individual will insert a company's name in this column. This will be pulled into the filename. However, if a company is ABC Company, Inc. - the comma in the filename throws our printing system into a loop. So, I use the equation =LEFT(A2,FIND(" ",A2))&MID(A2,FIND(" ",A2)+1,0) to only pull in the first portion of the name into another column and then insert the new name into the filename. Works good, but I am now running into the problem of the name being The ABC Company, Inc. The comma is not present, but the filename is The. Does anyone know an equation I could use that would only pick out ABC Company and leave The and the comma out? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
Converting a Variable Filename to a Constant Filename | Excel Programming | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
set excel <filename to <filename-date | Excel Programming | |||
Saving filename same as import filename | Excel Programming |