What's new
By:
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

Another Computer Question

C

collegehcky2

Vinegar Strokes
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?
 
Re: Another Computer Question

collegehcky2 said:
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?
Click to expand...

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.
 
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?
 
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.
http://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 :)
 
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.
 
Re: Another Computer Question

Nice phishing attack today.

Got an email acknowledging an Apple purchase I hadn't made. So first I send it (like an idiot) to my wife and daughter asking them if they ordered something (it looks like the kind of thing my daughter would get as a present for her boyfriend). I was at least smart enough to not click anything in it. Get home, dig up my account info (I never use that account), log into my account through Apple itself (ignoring the links in the email) and verify nothing has been purchased against it.

It would have been easy and natural to follow the link in the email to "Apple" and log in, thus giving them them my info.

Thank you work training. It didn't help that the official Apple login page is itself not prefaced by "https://", another thing I look for, but instead by some secureid string generated by the login which, yeah, very clever but f-ck you Apple.

Be careful out there. The Dumpbotskis are getting smarter. The email, needless to say, exactly matched official Apple correspondence.
 
Last edited:
Re: Another Computer Question

So this isn't exactly a computer question but maybe someone here can help me figure something out. I can't seem to get my ipads to recognize the microphone on a TRRS cable. I really don't know what I'm doing wrong.

Thanks
 
Re: Another Computer Question

Kepler said:
Nice phishing attack today.

Got an email acknowledging an Apple purchase I hadn't made. So first I send it (like an idiot) to my wife and daughter asking them if they ordered something (it looks like the kind of thing my daughter would get as a present for her boyfriend). I was at least smart enough to not click anything in it. Get home, dig up my account info (I never use that account), log into my account through Apple itself (ignoring the links in the email) and verify nothing has been purchased against it.

It would have been easy and natural to follow the link in the email to "Apple" and log in, thus giving them them my info.

Thank you work training. It didn't help that the official Apple login page is itself not prefaced by "https://", another thing I look for, but instead by some secureid string generated by the login which, yeah, very clever but f-ck you Apple.

Be careful out there. The Dumpbotskis are getting smarter. The email, needless to say, exactly matched official Apple correspondence.
Click to expand...

2-factor for everything.
Never ever trust an email.
 
Re: Another Computer Question

Microsoft 365 Business Outlook users:

Outlook has to be restarted every day in order to get it to link with email provider.

This didn't use to happen, but started about 6 months ago. I have followed every possible fix that Microsoft has suggested on their troubleshooting sights.

I use GoDaddy for my email server.

Anyone run into a similar issue?
 
Re: Another Computer Question

Earl_Leatherland said:
Microsoft 365 Business Outlook users:

Outlook has to be restarted every day in order to get it to link with email provider.

This didn't use to happen, but started about 6 months ago. I have followed every possible fix that Microsoft has suggested on their troubleshooting sights.

I use GoDaddy for my email server.

Anyone run into a similar issue?
Click to expand...

How do you have it setup? Exchange, POP, IMAP, etc.?

Does it crash, just not connect, not load...?

Have you tried appending "_old" your outlook profiles and creating a new one through the system mail application?
 
Re: Another Computer Question

How do you have it setup? Exchange, POP, IMAP, etc.? IMAP

Does it crash, just not connect, not load...? Gets caught in a loop during the "Outlook Send/Receive Progress". Pop up window says "1 of 2 Tasks have completed successfully". The second task, where it is "Synchronizing subscribed folders for emailaddress@emailadress.com" and "Checking for new mail in subscribed folders on emailaddress@emailadress.com" just never gets completed.

Have you tried appending "_old" your outlook profiles and creating a new one through the system mail application? Yes
 
Re: Another Computer Question

Earl_Leatherland said:
How do you have it setup? Exchange, POP, IMAP, etc.? IMAP

Does it crash, just not connect, not load...? Gets caught in a loop during the "Outlook Send/Receive Progress". Pop up window says "1 of 2 Tasks have completed successfully". The second task, where it is "Synchronizing subscribed folders for emailaddress@emailadress.com" and "Checking for new mail in subscribed folders on emailaddress@emailadress.com" just never gets completed.

Have you tried appending "_old" your outlook profiles and creating a new one through the system mail application? Yes
Click to expand...

Does it return any errors on the progress window? You might have to pin the window to keep it open.
 
You must log in or register to reply here.
Back
Top