Molly Mae
-
Posts
3659 -
Joined
-
Last visited
-
Days Won
11
Content Type
Profiles
Forums
Events
Gallery
Blogs
Everything posted by Molly Mae
-
That what you call "Satan" or "human nature," I refer to as entropy?
-
-
You, sir, are awesome. I'm not entirely sure how this is working, but I'll take it. I've gotten this for your module code: The button macro just calls the whole code, correct? Or is it just the Private Function?
-
COACH If 1, C is the first letter. OACH are eliminated by AORTA, FLAME, and BELCH. If 0, R is the second letter utilizing my last justification--only this time including COACH-0 to eliminate the C. S cannot be the first (SPORK-0). EAM does not change from CREAM to STEAM, but the number decreases. That means that C or R must be correct. C is eliminated from COACH.
-
Here's what I have in my module now. I'm trying to call the environment variable windir. It doesn't matter what variable I call, I just want to call one. When I try the function Environ(windir) in excel, it switches over to the Visual Basic Module and returns "Compile Error: Invalid Outside Procedure" EDIT: Don't trust the color in the codebox, though. Comments are preceded by the single quote (').
-
I shouldn't have to connect the excel spreadsheet to the batch, though. All variables from the game are saved as windows environment variables, so I should be able to pull them directly from windows. I guess a simpler method of asking would be: "How can I type in an Environment Variable in an Excel spreadsheet and have it return the value of that variable without redefining all Environment Variables as variables local to excel?" But the only thing I've really done is put that VBA code into the module and saved it. Perhaps =Environ$(%windir%) ? I have to recreate the file, so I'll check that.
-
This isn't homework, just something I've been trying to accomplish. I didn't know where else to ask... If your familiar with the windows command shell and/or batch scripting, you probably know that windows stores variables in shell32.dll. You can view the semi-permanent values in the environment variable section of system properties. Really, though, this is a MS Excel question for anyone who knows how to integrate VBA. Here's the situation: I wrote a simple RPG (like a MUD--except only single-user....so...a SUD) using batch files. Stats and the like are stored as windows variables. Incidentally, variables are temporary unles you use the setx command, which I've done. So all of my stats are saved in the environment variables and are semi-permanent (they can be written over). I've done this to act as a save/load game function. Now, I want to integrate an auto-updating character sheet using excel. It's possible, from what I've read. Traditionally, I just google something and mess around with it until I figure it out. VBA is more of a headache than I bargained for, however. My search returned THIS. I've copied their code into a module using the steps provided HERE. Ultimately, I want to be able to input a variable name (say windir), and have it output the variable value (C:\windows). Am I doing something incorrectly? Any help with this would be greatly appreciated.
-
That's actually the funniest thing I've heard in awhile. It's a reference to the NES console--the button sequence for many cheats. --- I'm taking this rubik's challenge to a new level. I'm going to write a windows batch file to scramble and solve it. It's actually not nearly as daunting as I had originally imagined.
-
S P O R E THANK - 0 FIRST - 0 QUILT - 0 CROWS - 1 FROWN - 1 FROST - 1 FRANK - 0 STORM - 3 STOVE - 3 STOMP - 2 SPORE - 5 Congrats, PG. Vine +5 PG +25 MollyMae +11 Totals: Cherry Lane - 449 Glycereine - 443 Izzy - 386 plainglazed - 367 Vineetrika - 317 Unreality - 284 t8t8t8 - 190 Framm - 177 Dawh - 154 NickFleming- 136 woon - 136 golfjunkie - 132 Blablah99 - 53 MollyMae - 41 Hirkala - 36 JarZe - 25 Harvey45 - 24 yuiop - 21 Abhisk - 20 PVRoot - 20 Filly - 19 Prince Marth - 15 DudleyDude - 15 phaze - 15 Kac_cotu - 5
-
I need something to generate an array representing the unsolved cube. I'll be writing an interface in which you can input the "unsolved cube." It will solve it, output the number of steps, and detail each move. It's not brute force, though, and doesn't solve it in the fewest moves. It follows the pattern I know for solving a 3x3x3, checking itself after each step. Alternatively (and as a joke), I'll write up one that simply renames one side to an appropriate color (or number) making the cube appear solved. This would be the program-equivalent of removing the stickers and placing them on their respective sides.
-
-
Just decided to check the thread. =P I guess I've made some more enemies in Survivor, huh?
-
In further response to BB...Hirk is not Jewish. In fact, he persecutes our kind. He insults my nose and bank accounts on a daily basis...
