$$Excel-Macros$$ Re: VBA Macro Excel Add Text In Cell

Use the format function as in, Format("f123456789","@.@@@.@@@.@@@") Let me know if this was what you ere looking for Ajit On Wed, Oct 1, 2008 at 3:53 AM, <[EMAIL PROTECTED]> wrote: > > I need a macro that will add periods at specific locations in a cell > of text in Excel. My example is an

$$Excel-Macros$$ Excel Vista VBA Problem

Excel Vista VBA Problem Trying to set a value for an OLAP Cube, but don't know enough about the syntax to work with the quotes? ActiveSheet.PivotTables("PivotTable1").PivotFields("[Date].[WM Week].[WM Week]" _ ).VisibleItemsList = Array("[Date].[WM Week].&[200832]", _ "[Date]

$$Excel-Macros$$ Re: I am new to Excel VBA Macros.

you can search in www.*4shared*.com On Mon, Sep 29, 2008 at 3:19 PM, ASD <[EMAIL PROTECTED]> wrote: > > Wiley - Excel 2003 Power Programming With Vba - John Walkenbach > > On Sep 29, 7:26 am, HomeRun <[EMAIL PROTECTED]> wrote: > > Could some good programmers mail books o

$$Excel-Macros$$ Share your professional knowledge on TooStep

You are invited to join personal knowledge network of Darshan Amreliya on TooStep - I value your professional knowledge and therefore request you to join my knowledge network on TooStep. -- Darshan Amreliya Material Mgm

$$Excel-Macros$$ How to externalise strings in VBA

Hi, I have some VBA macros in Excel that builds very long SQL strings and the code is very difficult to read because of all the string concatenations. I was thinking to build the SQL query in a Worksheet and then read it into a VBA string. This way my code would be easier to read and also I coul

$$Excel-Macros$$ Re: VBA Macro Excel Add Text In Cell

=LEFT(A1,1)&"."&MID(A1,2,3)&"."&MID(A1,5,3)&"."&MID(A1,8,3) can do the job if your text if A1 Regards Rahul On Tue, Sep 30, 2008 at 4:23 PM, <[EMAIL PROTECTED]> wrote: > > I need a macro that will add periods at specific locations in a cell > of text in Excel. My example is an item number f12345

$$Excel-Macros$$ Re: Excel Macros Book?

Hi All, if you want Macros book in PDF format you can search them in following website. www.*4shared*.com On Wed, Sep 24, 2008 at 8:56 PM, kalpesh velinkar <[EMAIL PROTECTED] > wrote: > Dear John. > > Even I would like to learn. In case you find some solution without VBA. > Please let me know.