Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Excel on your phone?

Latest post Mon, Jun 14 2010 10:20 AM by Jim Cone. 2 replies.
  • Sat, Jun 12 2010 8:31 AM

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 233
    • Points 3,320

    Excel on your phone?

    In the news today...
    "Microsoft Windows Phone 7 Will Come With Office Pre-installed"
    News Article

    To ask/answer Excel questions, does this mean it may be necessary to provide/know the...
    Excel version / Computer operating system / Web version / Phone version
    Also, will/does the web and phone apps include VBA?

    And to digress:  Does anyone know whether the VBA BorderAround method works reliably in XL2010?  It didn't in the beta release.

    Jim Cone
    Portland, Oregon
    Excel apps

     

     

    • Post Points: 21
  • Mon, Jun 14 2010 1:53 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 543
    • Points 9,287
    • MVP

    Jim

    Windows phone devices have come with mobile Office loaded for some years. I think this is little different. I have a Windows 6.5 device and have just upgraded to the Office 2010 versions of the apps on that. I suspect from the article that they are more heavily leaning on the Sharepoint integration which currently does not really exist.

    The Office 2010 apps I have on my device do not have VBA and are light versions of the desktop apps. With screens so small they are also pretty difficult to sue and navigate even with touch screens.

    The integration with exchange however is a different story. That works superbly with appointments, contacts and email being able to be done on any device, the web, etc and everything just stays in sync automatically. I actually get emails quicker on my phone that my desktop and appointments buzz simultaneously

    Border around I have no experience with but do have just 2010 installed so if you had anything to test?

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK

    • Post Points: 21
  • Mon, Jun 14 2010 10:20 AM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 233
    • Points 3,320

    Nick,

    Thanks for the "phone" review.  Office on a phone just doen't make sense to me.
    The Exhange/Outlook capability sounds actually useful.

    As for BorderAround, in the 2010 tech preview, I got inconsistant results.
    Some of the borders would appear and others wouldn't.  For instance one or two of the borders would be missing while the others would be Ok.
    I replaced what BorderAround code I had with code to apply the four borders individually.
    This is an example of what I had, using an unshown sheet reference...

    With .Range(.Cells(N - 6, 2), .Cells(N - 5, 9)) 'B4:I5
    With .Font
    .Size = Application.WorksheetFunction.Min((Application.StandardFontSize + 2), 15)
    .Bold = True
    .Name = "Comic Sans MS"
    End With
    .Interior.Color = vbWhite
    .BorderAround Weight:=xlThin, Color:=vbBlack                 '<<<<<<<<<<<
    .HorizontalAlignment = xlHAlignCenterAcrossSelection
    .EntireRow.AutoFit
    End With

    I don't have the release to manufacturing version of Excel 2010.
    '--
    Jim Cone

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.