Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Excel Formula to Macro
Bob - Let me try to clarify what is currently being done. The process ma sound clunky but works fairly well. The Process: 1. Someone on my team is enters data into an predefined exce spreadsheet (template) Data entry begins at row 5. 2. When the data entry is complete, a pre-written formula is copied t each row/ record into column L. The formula is stored in Cell L1 as a string using an apostrophe. The formul looks at columns AN - AV to build a formated pricelist. (Yes the template is large). 3. After the formulas is copied, a macro is run against the sheet t prep and save the the data. By prep, I mean certain characters -- commas, quotation marks, trademar symbols, among others -- are converted to numeric equivalents -- &#<ASCIIValue;. 4. The sheet saved as a CSV file and run through an XML generator t format the data into a valid XML file. I would like to do is be able to automate the part where the formula i being copied. Better yet, if I would prefer to replace the formula altogether with the formula result. *** What I meant by "n" is the number of rows that contain data. Thi number can vary on any given day. Does this make more sense -- mjm91 ----------------------------------------------------------------------- mjm917's Profile: http://www.excelforum.com/member.php...fo&userid=1471 View this thread: http://www.excelforum.com/showthread.php?threadid=26335 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for converting excel to adobe pdf | Excel Discussion (Misc queries) | |||
Converting a Access routine into an Excel macro? | Excel Discussion (Misc queries) | |||
Converting Excel Formula to Macro | Excel Programming | |||
Assist in converting Lotus Macro to Excel? | Excel Programming | |||
macro for converting text file to excel | Excel Programming |