Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load Vb Functions
Hiw do you load VB functions into a VBA EXCEL program. I
specifically want to use the replace function to remove unwanted characters in .csv file that I am opening and using the value to make comparisons. Thanks maurice |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load Vb Functions
Maurice,
You didn't mention what version that you're using. Copied from an earlier post by Chip Pearson: <snip Replace was added to VBA in version 6, or Excel 2000, so it is not available in earlier versions. In its place, you can use Result = Application.WorksheetFunction.Substitute(...) to call the SUBSTITUTE worksheet function from within VBA. See help in Excel for SUBSTITUTE for syntax details. <snip John Maurice wrote: Hiw do you load VB functions into a VBA EXCEL program. I specifically want to use the replace function to remove unwanted characters in .csv file that I am opening and using the value to make comparisons. Thanks maurice |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I load an Add-ins | Excel Discussion (Misc queries) | |||
Cannot load | Excel Discussion (Misc queries) | |||
Excel XP will not load | Setting up and Configuration of Excel | |||
"Problems during load" | Excel Discussion (Misc queries) | |||
How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions |