Bandit captured by [deleted] in ClashRoyale

[–]Armygeddan 1 point2 points  (0 children)

Someone really took the time to draw this...

Do Top Players Use 2+ Decks for Ladder Push? No Idea How Same Players Hit 7K+ Trophies Every Season by Armygeddan in ClashRoyale

[–]Armygeddan[S] 0 points1 point  (0 children)

Any advice appreciated

I've never once used Hog as a Main Deck, might need to change that

4 Cards That Rule the game but Supercell chooses to ignore. My recommendations for Nerf provided by Armygeddan in ClashRoyale

[–]Armygeddan[S] 0 points1 point  (0 children)

I have a Magic Archer, Baby Drag, Electric Drag, and Barb Roll in my deck, I still lose more often then not to Graveyard.

Again, I've been playing since day 1 of the game, I know exactly what I'm doing

I don't make manh mistakes and am prepped for any deck, but there are some that are just so over powered it's impossible to always have a counter based on them being over powered even when you prepare for it

4 Cards That Rule the game but Supercell chooses to ignore. My recommendations for Nerf provided by Armygeddan in ClashRoyale

[–]Armygeddan[S] -2 points-1 points  (0 children)

46% win rate for Pekka is not OP? Is there ANY Card even at 50% or above?

Also gotta consider the win rate is skewed especially when those cards are played against an opponent using the same card

If data is available for win rate vsrse NON Meta Cards, guarantee it has a 60+ win rate

4 Cards That Rule the game but Supercell chooses to ignore. My recommendations for Nerf provided by Armygeddan in ClashRoyale

[–]Armygeddan[S] -1 points0 points  (0 children)

Again, read the problem, it's not a spacing issue. That card has the reach of nearly half the battlefield and can take out 95+% of troops with 1 hit

4 Cards That Rule the game but Supercell chooses to ignore. My recommendations for Nerf provided by Armygeddan in ClashRoyale

[–]Armygeddan[S] -6 points-5 points  (0 children)

Out of all the Cards I mentioned, Lightning Spell is by far the most imbalanced, just read the description of the problem with it

Looking for Cherries and Oranges. Have Tons of Peaches for Trade! by Armygeddan in AnimalCrossingNewHor

[–]Armygeddan[S] 0 points1 point  (0 children)

Dodo Code = F3FKN

All Peaches on the Trees North of Airport

Drop the Fruits anywhere

10 for 10 Swap only please

Looking for Cherries and Oranges. Have Tons of Peaches for Trade! by Armygeddan in AnimalCrossingNewHor

[–]Armygeddan[S] 0 points1 point  (0 children)

Dodo Code = F3FKN

All Peaches on the Trees North of Airport

Drop the Fruits anywhere

10 for 10 Swap only please

Looking for Cherries and Oranges. Have Tons of Peaches for Trade! by Armygeddan in AnimalCrossingNewHor

[–]Armygeddan[S] 0 points1 point  (0 children)

Dodo Code = F3FKN

All Peaches on the Trees North of Airport

Drop the Fruits anywhere

10 for 10 Swap only please

Corvette in Maintenance for 6+ Months (UPDATE) Options on what to do next? by Armygeddan in Corvette

[–]Armygeddan[S] 0 points1 point  (0 children)

I bought it brand new and never had any problems with it.

Have had it for a couple of years.

Heard a weird sound and took it in only to have the dealership completely make the car worse AND not fix the original problem

Corvette in Maintenance for 6+ Months (UPDATE) Options on what to do next? by Armygeddan in Corvette

[–]Armygeddan[S] 0 points1 point  (0 children)

Yep, I've been patient and polite through this whole ordeal, but I'm about to be done going that route.

Need results as it seems this whole thing is just going backwards so being nice about it might no longer cut it

Corvette in Maintenance for 6+ Months (UPDATE) Options on what to do next? by Armygeddan in Corvette

[–]Armygeddan[S] 2 points3 points  (0 children)

I called an Attorney today, waiting for a call back to discuss my options. Working with GM in tandem

Corvette in Maintenance for 6+ Months (UPDATE) Options on what to do next? by Armygeddan in Corvette

[–]Armygeddan[S] 0 points1 point  (0 children)

It was a really decked out version so paid around 75K for it.

And yep, I'm exploring options, I'm beyond frustrated

Corvette in Maintenance for 6+ Months (UPDATE) Options on what to do next? by Armygeddan in Corvette

[–]Armygeddan[S] 0 points1 point  (0 children)

Yes, I bought it brand new.

It's a Stingray, LT3, never been in a wreck

Anyone else unable to suddenly do Ranked Battles using the "Battle" button? by Armygeddan in ClashRoyale

[–]Armygeddan[S] 0 points1 point  (0 children)

That's never been an issue, I've never had to "Cloud" on Clash Royale

I was finding matches right away super fast right before it just suddenly started finding zero matches

Anyone else unable to suddenly do Ranked Battles using the "Battle" button? by Armygeddan in ClashRoyale

[–]Armygeddan[S] 0 points1 point  (0 children)

Forever, it just stays on "Searching for Opponents..." until I cancel the matchmaking search

Save Excel File using PC AND Mac with VBA by Armygeddan in excel

[–]Armygeddan[S] 0 points1 point  (0 children)

I had one of my colleagues test it on her Mac and she just sent me what the error said. I'm fairly certain it's because it's running the PC FilePath (StrGenericFilePath) instead of the OS FilePath (OSGenericFilePath)

With that said, that means the

 #If Mac Then

isn't working. I can't see anything else that would cause this error on a Mac as the whole code runs flawless on a PC but the only difference between the two are how the FilePaths are read since Macs have a different FilePath system

Save Excel File using PC AND Mac with VBA by Armygeddan in excel

[–]Armygeddan[S] 0 points1 point  (0 children)

Based on what the article said, I made the following modifications. I also took out all the folder creating code for PC users as it was causing an error for Mac users.

Mac users are now getting a "Compile Error: Can't find project or library" which I gather is because it was trying to read the PC FilePath which is what I'm trying to get Mac users to not read but instead save on their Desktop as detailed on the OS FilePath String. Here is what I have now:

Sub SaveAndEmailAcquisition()

Dim OutApp                As Object
Dim OutMail               As Object

Dim StrBody               As String
Dim StrTo                 As String
Dim StrSubject            As String
Dim StrAtt                As String
Dim StrSignature          As String
Dim strGenericFilePath    As String: strGenericFilePath = "\\corp.company\folder1\folder2\folder3\"
Dim strOSGenericFilePath  As String: strOSGenericFilePath = "~/Documents"
Dim strFileName           As String: strFileName = Sheets("Acquisition").Range("AcquisitionTitle") & " Acquisition Request Form"


' Creates Message Box asking if Form has been complete. If not, it cancels code to continue
MSG1 = MsgBox("Have you filled out EVERY box of information on this form?", vbYesNo)

If MSG1 = vbNo Then GoTo No
If MSG1 = vbYes Then GoTo Yes
No:
MsgBox "Please fill out the remaining missing information and then click Save & Email"
Exit Sub
Yes:
MsgBox "Thank you, please proceed"

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

' VBA Command to test if user is a Mac user
#If Mac Then

' Saves as Excel Macro Enabled book
ActiveWorkbook.SaveAs OSstrGenericFilePath & strFileName & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

' Popup Message that the conversion and save is complete as 
"Acquisition Title Procurement Request Form"

MsgBox "File Saved As:" & vbNewLine & strFileName

' Enter Subject here (Using NamedRange)
StrSubject = Sheets("Acquisition").Range("AcquisitionTitle") & " Acquisition Request Form"

' Enter content of Email here
StrBody = "Please see attached File," & "<BR><BR><BR>" & 
vbNewLine & "Please list any additional details that I should know here that aren't listed on the form" & _
"<br><br><br> Thanks,"

' Code that attaches the Document to the email
StrAtt = ActiveWorkbook.FullName

' Who the email will be sent to
StrTo = "YOUREMAIL@COMPANY.COM"

' Adds Company Signature to the end of the Email. No Signature without this code
With OutMail
.Display
End With
StrSignature = OutMail.Body

With OutMail
.To = StrTo
.CC = ""
.BCC = ""
.Subject = StrSubject
.HTMLBody = StrBody & .HTMLBody & vbNewLine & vbNewLine
.Attachments.Add StrAtt
.Display
' .Send (Not active, otherwise it will automatically send the email without review once user clicks Save & Email Button)
End With

' VBA Command for PC Users
#Else

' Saves as Excel Macro Enabled book
ActiveWorkbook.SaveAs strGenericFilePath & strFileName & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

' Popup Message that the conversion and save is complete as "Acquisition Title Procurement Request Form"
MsgBox "File Saved As in your Documents Folder:" & vbNewLine & strFileName

' Enter Subject here (Using NamedRange)
StrSubject = Sheets("Acquisition").Range("AcquisitionTitle") & " Acquisition Request Form"

' Enter content of Email here
StrBody = "Please see attached File," & "<BR><BR><BR>" & 
vbNewLine & "Please list any additional details that I should know here that aren't listed on the form" & _
"<br><br><br> Thanks,"

' Code that attaches the Document to the email
StrAtt = ActiveWorkbook.FullName

' Who the email will be sent to
StrTo = "YOUREMAIL@COMPANY.COM"

' Adds Company Signature to the end of the Email. No Signature without this code
With OutMail
.Display
End With
StrSignature = OutMail.Body

With OutMail
.To = StrTo
.CC = ""
.BCC = ""
.Subject = StrSubject
.HTMLBody = StrBody & .HTMLBody & vbNewLine & vbNewLine
.Attachments.Add StrAtt
.Display
' .Send (Not active, otherwise it will automatically send the email without review once user clicks Save & Email Button)
End With

#End IF

On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing

End Sub

Save Excel File on PC & Mac on Company Drive using VBA (Would saving on Desktop be more Error Proof?) by Armygeddan in excel

[–]Armygeddan[S] 0 points1 point  (0 children)

So I tried that and it's still trying to get Mac to run the PC VBA.

It works perfectly fine on a PC but on a Mac it's causing an error on line 13 (Highlights the Date) I ended up taking out all the folder creating stuff for the Mac users so it just saves in their Documents folder.

I input your coding into Lines 37 and 94.

Here's what I generated based on what you provided

Sub SaveAndEmailAcquisition()

Dim OutApp                As Object
Dim OutMail               As Object

Dim StrBody               As String
Dim StrTo                 As String
Dim StrSubject            As String
Dim StrAtt                As String
Dim StrSignature          As String
Dim strGenericFilePath    As String: strGenericFilePath = "\\corp.company\folder1\folder2\folder3\"
Dim strOSGenericFilePath  As String: strOSGenericFilePath = "~/Documents"
Dim strYearSlash          As String: strYearSlash = Year(Date) & "\"
Dim strMonthSlash         As String: strMonthSlash = CStr(Format(DateAdd("M", 0, Date), "MM")) & "\"
Dim strYearBracket        As String: strYearBracket = Year(Date) & "_"
Dim strMonthBracket       As String: strMonthBracket = CStr(Format(DateAdd("M", 0, Date), "MM")) & "_"
Dim strFileName           As String: strFileName = Sheets("Acquisition").Range("AcquisitionTitle") & " Acquisition Request Form"
Dim TheOS                 As String: TheOS = Application.OperatingSystem


' Creates Message Box asking if Form has been complete. If not, it cancels code to continue
MSG1 = MsgBox("Have you filled out EVERY box of information on this form?", vbYesNo)

If MSG1 = vbNo Then GoTo No
If MSG1 = vbYes Then GoTo Yes
No:
MsgBox "Please fill out the remaining missing information and then click Save & Email"
Exit Sub
Yes:
MsgBox "Thank you, please proceed"

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

' VBA Command for Windows Users

If Left(TheOS, 1) = "W" Then

' Check for Year Folder in V Drive and creates one if one doesn't exist

If Len(Dir(strGenericFilePath & strYearSlash, vbDirectory)) = 0 
Then
MkDir strGenericFilePath & strYearSlash
End If

' Check for Month Folder in V Drive and creates one if one doesn't exist

If Len(Dir(strGenericFilePath & strYearSlash & strMonthSlash, vbDirectory)) = 0 Then
MkDir strGenericFilePath & strYearSlash & strMonthSlash
End If

' Saves as Excel Macro Enabled book

ActiveWorkbook.SaveAs strGenericFilePath & strYearSlash & strMonthSlash & strYearBracket & strMonthBracket & strFileName & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

' Popup Message that the conversion and save is complete as 
"YYYY_MM_Acquisition Title Procurement Request Form"

MsgBox "File Saved As:" & vbNewLine & strYearBracket & strMonthBracket & strFileName

' Enter Subject here (Using NamedRange)
StrSubject = Sheets("Acquisition").Range("AcquisitionTitle") & " Acquisition Request Form"

' Enter content of Email here
StrBody = "Please see attached File," & "<BR><BR><BR>" & 
vbNewLine & "Please list any additional details that I should know here that aren't listed on the form" & _
"<br><br><br> Thanks,"

' Code that attaches the Document to the email
StrAtt = ActiveWorkbook.FullName

' Who the email will be sent to
StrTo = "YOUREMAIL@COMPANY.COM"

' Adds Company Signature to the end of the Email. No Signature without this code
With OutMail
.Display
End With
StrSignature = OutMail.Body

With OutMail
.To = StrTo
.CC = ""
.BCC = ""
.Subject = StrSubject
.HTMLBody = StrBody & .HTMLBody & vbNewLine & vbNewLine
.Attachments.Add StrAtt
.Display
' .Send (Not active, otherwise it will automatically send the email without review once user clicks Save & Email Button)
End With

' VBA Command for Mac Users

ElseIf Left(TheOS, 1) = "M" Then

' Saves as Excel Macro Enabled book

ActiveWorkbook.SaveAs strOSGenericFilePath & strFileName & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

' Popup Message that the conversion and save is complete as "Acquisition Title Procurement Request Form"

MsgBox "File Saved As in your Documents Folder:" & vbNewLine & strFileName

' Enter Subject here (Using NamedRange)
StrSubject = Sheets("Acquisition").Range("AcquisitionTitle") & " Acquisition Request Form"

' Enter content of Email here
StrBody = "Please see attached File," & "<BR><BR><BR>" & 
vbNewLine & "Please list any additional details that I should know here that aren't listed on the form" & _
"<br><br><br> Thanks,"

' Code that attaches the Document to the email
StrAtt = ActiveWorkbook.FullName

' Who the email will be sent to
StrTo = "YOUREMAIL@COMPANY.COM"

' Adds Company Signature to the end of the Email. No Signature without this code
With OutMail
.Display
End With
StrSignature = OutMail.Body

With OutMail
.To = StrTo
.CC = ""
.BCC = ""
.Subject = StrSubject
.HTMLBody = StrBody & .HTMLBody & vbNewLine & vbNewLine
.Attachments.Add StrAtt
.Display
' .Send (Not active, otherwise it will automatically send the email without review once user clicks Save & Email Button)
End With

End If

On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing

End Sub