#1
|
|||
|
|||
macros to excel
Hi I use vba macros in excel to do certain data formatting. I am looking to convert vba macros to excel formulas so that anyone without vba knowledge can use it.
Part of macro statements are as below - strOut = Format(108, "0000000000") ' form id strOut = strOut & Format(n + 1000, "0000000000") ' sequence strOut = strOut & Format (strId,"000000000000000000000000000000") ' prim key strOut = strOut & "A" ' add new entry strOut = strOut & Space(65) & vbTab I have converetd all the statements using autofill for sequence and text function for rest. For example replace Space(65) with "" and placing 65 spaces between quotations. But I am not sure how i can print tab space in excel. Any help plesae ? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macros | nore | Outlook | 0 | 06-01-2011 04:39 PM |
Oulook Deletes Emails Attached with Excel Files That Have Macros | Slacker | Outlook | 4 | 01-24-2011 03:17 PM |
Macros | Desertwrangler | Word VBA | 6 | 06-25-2010 07:06 AM |
Macros | krdzal | Excel | 1 | 04-06-2010 07:43 AM |
Excel 2003 SP3 bug when running Macros | EnricoVenturi | Excel | 0 | 09-06-2009 08:11 AM |