Hey SirJB7!, Actually I noted in my question that the start base was this coming Friday (6/14), from that point every subsequent bi-weekly Friday etc. In my working example above I see now (by mistake) that I'm using 5/31/13 instead of 1/11/13 in my Debug.Print example. But it doesn't matter...
I think I have it working. The 1/11/13 is the first pay Friday of the year (although it can be any date as long as it's a previous target Friday date).
I used a Mod formula, if anyone has a more elegant approach I'm all for it.
But this is resolved for now I suppose, thanks again guys...
Having problems getting the following code to get the next bi-weekly payday date.
The paydays are every other Friday, and because the next bi-weekly payday is this week (6/14), the code should return the value date of 6/14/13 (in whatever format as long as the date is essentially 6/14).
When...
I just realized I'm doing something wrong in the function...
But it appears I still have a prob somewhere up top still.
Function addStuffOnString(ByVal c As Range)
c.Offset(0, 1) = c.Value + " ..Appended To String In Col B"
End Function
Got a little stuck..
Function addStuffOnString(ByVal C As Range) returns the right value back (just in the wrong column).
Not sure if it's the function doing this or the Sub once it returns back.
As line 11 beneath indicates, I want the values to populate Column B (with Col A originally...
I have a form I created with Visual Studio.
I plan to display upcoming due projects (like notifications) in a section of the form.
I was thinking a small scroll-able area on my form would be best.
It will pop up the scroll-able table with data based on which project was due soonest.
I...
My prime objective is to have a main initialized userform with menu buttons, and when a menu button is selected it opens another userform pertaining to that button in the same window (without opening a seperate userform window).
I have a simple userform with a button that simply opens another userform.
However, the userform opens on top of the first one (as a seperate userform).
My objective is to load one main parent userform with buttons that open other forms within the main form itself.
How do I open another...
Chandoo is absolutely remarkable.
Everyone's been just as helpful and informative since day one.
*special shout out to Luke & Hui especially*
I wish all forums were this aesthetically pleasing, and simplistically elegant.
However, I am now venturing forth into the world of Visual Studio...
Okay I see I see.
Hmm..
What it make any difference if I were using a .vbs windows sript?
I'm creating a simple calculator at work (using a .vbs file actually), just thought it'd be nice if I could print the results from the message box.
Forgetting absolutely everything I've said so far : )
Imagine walking up a staircase, and for every step your foot lands on a new step appears.
Now, imagine walking down a staircase, and for every step your foot lands on one stair behind you disappears.
This is my goal with the columns as...
My logic (this may not coincide with what I have above my apologies).
But here is essentially what I'm looking to accomplish.
To save space on my worksheet I've hid unused columns.
However, I want to unHide those columns one at a time if the previous column is activated.
That way it...
I tried this code for a test spin and it works only if the cell in the adjacent previous column has value.
What you helped me with is almost there, except I need it to hide the entire column if the entire previous column has anything in the entire previous column at all.
I tried modifying...
'Having trouble hiding the entire active column (based on these 4 criterias)
<br />
'// HIDE COLUMN IF...<br />
'' 1 if that column is not after column X<br />
'' 2 if that column is not before column E<br />
'' 3 if that column has any value<br />
'' 4...
I figured it out.
I hope this helps someone.
Sub ChangeAppColorTheme()
Dim i_RegKey As String
Dim i_Value As String
Dim i_Type As String
Dim myWS As Object
Set myWS = CreateObject("WScript.Shell")
i_RegKey = "HKEY_CURRENT_USERSoftwareMicrosoftOffice" & Application.Version &...
Thanks JP ! : )
I pasted this code to possibly help someone else from the mr.excel first link you posted.
<br />
Option Explicit</p>
<p>Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _<br />
(ByVal lpClassName As String...
We're able to view a sheet in fullscreen mode with everything completely hidden except for the title bar.
Is it possible to hide the title bar at the very top also?
Oh snap!
I added "objxlapp." to each range value and it worked : )
<br />
Set objXLApp = CreateObject("Excel.Application")<br />
objxlapp.Visible=False<br />
objxlapp.Workbooks.Add<br />
With objxlapp<br />
objxlapp.Range("A1").Value =...
Yes that's it, I would ultimately like to just build these things from scratch without the use of Excel from vb script.
But for now simply running the excel macros without ever opening Excel would be fantastic.
I've tried to use the code you provided above like
<br />
Set objXLApp =...
I simply pasted this in a text file with the ext .vbs "HelloWorld.vbs"
Is there any way to accomplish this "Hello World" script without Excel opening?
Oh yeah.. objxlapp.Visible=False (and it displayed the MsgBox without Excel opening) :)
Set objXLApp = CreateObject("Excel.Application")...