Results 1 to 8 of 8

Thread: Another Computer Question

  1. #1
    Vinegar Strokes
    Join Date
    Oct 2008
    Location
    New England
    Posts
    2,159

    Another Computer Question

    So, my current computer (Sony Vaio) is on it's last breath. I think I'll need to get a new one soon, I kind of want a MacBook. Will my Microsoft Office files be able to run on a Mac OS? And my music files? I have iTunes so all my music is converted over to that format, but I'd need to copy all of it anyways. Thoughts? Opinions? Suggestions?

  2. #2
    unofan's Avatar
    Join Date
    Jul 1999
    Location
    Omaha, NE, USA
    Posts
    19,484

    Re: Another Computer Question

    Quote Originally Posted by collegehcky2 View Post
    So, my current computer (Sony Vaio) is on it's last breath. I think I'll need to get a new one soon, I kind of want a MacBook. Will my Microsoft Office files be able to run on a Mac OS? And my music files? I have iTunes so all my music is converted over to that format, but I'd need to copy all of it anyways. Thoughts? Opinions? Suggestions?
    Yes and Yes, provided you get Office for your new laptop. Really no different than trying to open a PDF on an apple vs. a pc anymore.

  3. #3
    Old Dirty Basterd Shirtless Guy's Avatar
    Join Date
    Sep 2004
    Location
    Minneapolis, MN
    Posts
    16,851

    Re: Another Computer Question

    Ok I thought I would resurrect a thread instead of starting my own...I'm trying to do some excel vba macro stuff and I've hit a major bump. What was trying to do is create some if statements to determine which macro to run...There is possible relevant data in 2 cells BC7 and BC8

    BC7 can look like the following:
    e0 #1WL pitcher-4 relief(1)/N@
    e0 #1WR pitcher-4 relief(1)/6@
    e10 #3WL pitcher-2 starter(6)@
    e12 #1WR pitcher-3 starter(7)@
    e17 #5WL pitcher-2 starter(6)@
    e17 #5WL pitcher-2 starter(6)@
    e7 #6NL pitcher-1 starter(7)@
    e10 #3WL pitcher-2 starter(6)@

    I want to run a specific macro if the cell contains starter and a different one if it contains relief

    BC8 can look like the following:

    bunting-A relief(3)/N@
    bunting-B relief(3)/0@
    bunting-C relief(3)/N@
    bunting-C relief(2)/6@
    bunting-A
    bunting-B
    bunting-C

    I want to run a specific macro if the cell contains relief or nothing special if it doesn't.

    I thought I could do
    Range("BC7").Select
    If Activecell = "*starter*" then
    Application.Run "StratCardAnalysis.xls!StarterBC7"
    End If
    Range("BC7").Select
    If Activecell = "*relief*" then
    Application.Run "StratCardAnalysis.xls!ReliefBC7"
    End If
    Range("BC8").Select
    If Activecell = "*relief*" then
    Application.Run "StratCardAnalysis.xls!ReliefBC8"
    End If

    But the = "*whatever*" isn't working...help?
    Michigan Tech Legend, Founder of Mitch's Misfits...Posted by Yager on 12/18/09: Remember, remember, the 18th of October (2003).

    Sports Allegiance: NFL: GB MLB: MIL NHL: MIN CB: UW CF: UW CH: MTU FIFA: USA MLS: MIN EPL: Everton

  4. #4
    Clear Eyes, Full Hearts, Can't Lose Zudnic's Avatar
    Join Date
    Mar 2000
    Location
    Doofenshmirtz' Island Hideout
    Posts
    12,770

    Re: Another Computer Question

    I don't know VB or .NET so this may or may not work. Approaching it as someone who used to do a lot of coding in other languages.

    You don't need to ask: is "bunting-C relief(3)/N@" EQUAL TO "*relief*" (which is what you do with your statement: If Activecell = "*relief*" then ... )

    Instead you need to ask: "relief" PRESENT WITHIN "is bunting-C relief(3)/N@"

    A quick Google search shows that there is a fn called "InStr()" which should accomplish this for you.
    https://www.aivosto.com/vbtips/instr.html

    InStr([start,] string1, string2 [, compare])

    So:
    if InStr(ActiveCell, "relief") == NULL

    etc.

    Here it is.. the day I am finally coding on the USCHO boards. Only took eleven years

  5. #5
    Fighting Sioux Hockey Fan
    Join Date
    Jul 2004
    Location
    Verona WI
    Posts
    1,590

    Re: Another Computer Question

    resurrecting an old thread.

    Windows 10, new horses**t computer, lower right of the screen contains multiple popups that go the 'New Notifications'. is this an app that i can turn off somehow???? it's highly annoying. any help would be appeciated.
    Fighting Sioux Forever

  6. #6
    I got nothing Slap Shot's Avatar
    Join Date
    Mar 2001
    Location
    Clark Freeport Zone, Philippines
    Posts
    31,322

    Re: Another Computer Question

    Settings, system, notifications & actions.

  7. #7
    Fighting Sioux Hockey Fan
    Join Date
    Jul 2004
    Location
    Verona WI
    Posts
    1,590

    Re: Another Computer Question

    Quote Originally Posted by Slap Shot View Post
    Settings, system, notifications & actions.
    Seems to have worked. Thanks a lot.
    Fighting Sioux Forever

  8. #8
    I got nothing Slap Shot's Avatar
    Join Date
    Mar 2001
    Location
    Clark Freeport Zone, Philippines
    Posts
    31,322

    Re: Another Computer Question

    Quote Originally Posted by MadTownSioux View Post
    Seems to have worked. Thanks a lot.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •