Search:

I figured as much :(, but thanks a lot for your help I appreciate it.

No worries usually just takes a second glance to see stuff like that, happens all the time ;)

Thanks koolsid unfortunately the dates that are plotted are incorrect as in which are in the format of 00-01-1900. Not sure if you are able to replicate this on your side or not but may have to do...

No worries I'm about out of here myself thanks again.

No problem thanks for the assistance, unfortunately I cant send the exact project since the data pulls from a DB but I have made a mock up of how the array is built and how the rest of the code...

Didn't think to check that but unfortunately it did not work.

Question on: frmendyear.txtto.Text

frmendyear = The name of your userform
txtto = The object name you are using (textbox)

The reason I ask is that errors is saying it cant find the object you...

Haven't had the chance to play with Citrix from a coding side but have you checked out the Citrix forums just out of curiosity?

http://forums.citrix.com

From what I am aware of a word document (assuming this is what you are referring to) sets the whole document to the style you choose and not sections. However if I am wrong I'm sure you can do a for...

Hello all been a while since I've been on the forums, but ran into a rather annoying issue with bubble charts in excel.

Basically I am taking 4 series of data Name, Y Axis, X Axis, and Bubble Size...

Actually it dose not work the way I need it to.

For Example if the Array is 12:00:00 AM and the StartDate is 8:00:00 PM and the EndDate is 1:00:00 AM it still returns false instead of true.

Ahh nice didn't even think about using the TimeSerial function thanks anhn, and shorter more efficient code is always nice :)

LOL nevermind figured it out




Sub Test()

Dim timeAry(0 To 47) As Variant

Never had to check this before and for some reason its not working the way I want it to.

Basically I am trying to see if a time from an array is between two times from a SQL query.

So


Dim...

This should do the trick ;)

http://www.vbforums.com/showthread.php?p=3310279#post3310279

I have been trying to figure this out for a while and have found my solution, and thought I should share. Basically I was trying to create a graph in excel without having to reference the data from...

Sweet RobDog I'll remember that for next time :D

Not really a problem but, more or less sharing :). Basically a co-worker and I were trying to figure out how to make a binary clock in VBA like the one I downloaded to my sprint mogul phone. So spent...

I use this to check SQL tables should work the same for your purpose


Private Sub UserForm_Activate()
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim Verify() As Variant
...

LOL your AWESOME I knew I was over complicating it. Thank you very much it works perfect. :thumb:

Maybe http://www.vbforums.com/showthread.php?t=527468

Also submitting your code will possibly help us understand what you are trying to do and you may be doing it inefficiently no offense (I actually do it all the time :)) which could be causing the...

Have you looked at the users machine thats having the issue and stepped through the code (F8) to see where it is breaking. I know a lot of things can come into play such as the user not having the...

Wow sorry not all there today lol, what kind of array do you have going on in your code?

Sorry if it helps this is what it looks like compiling the values.

Dim enddate, startdate, enddate2, startdate2, userenddate, userstartdate As Date
Dim theday, thehour, theminute As Long

If...

Hello all,

I have ran into a rather annoying result from an application I am creating.

Dim enddate, startdate, enddate2, startdate2, userenddate, userstartdate As Date
Dim theday,...

Thanks Si didn't even thing about using INT ill have to remember that next time. Been a long time since I've read the excel bible but then again haven't really played a lot with excel until as of...

Woot Resolved...

Thanks RobDog you made me see a new route :)

=DAYS360(B9,C9)&" Day(s) "&TEXT(C9-B9,"h") &" Hour(s) "& LEFT(TEXT(C9-B9,"mm.0"),2) &" Minute(s)"

Hmm tried this

=DAYS360(B9,C9)&" Day(s) "&TEXT(C9-B9,"h") &" Hour(s) "& TEXT(C9-B9,"m.0") &" Minute(s)" and got this 34 Day(s) 13 Hour(s) 51.0 Minute(s) but trying to get rid of that .0 but if i...

Yeah I looked back at the data and realized it was wrong in the hour and minute area. I tried the formula I posted today to see if I could fix the issue but I was originally using...

=C9-B9
...

Morning everyone,

I have a non VBA question this time about finding the difference between two different cells which are in the format of m/d/yy h:mm AM/PM.

Basically I have the following...

Anyone know how to convert this to work with Excel VBA SQL? More or less si_the_geek lol


local numbervar LNumStartOfText;
local numbervar LNumTotalCharacters;
local stringVar LStrOutputText;
...

Hmm thanks for the reply unfortunately I tried to test your code just to see what it did and I get bad name references. Do you by any chance have a document with it in it so I may see a general...

Have you cross referenced the settings for the computer that gets the redirect and the one that does not. It would have to be some setting in IE doing that to you.

Well I didn't do exactly what you said because removing the as 'starttime' made the export fail.

So what I did is removed the whole conversion on the Select statement and now everything is in...

I have been searching for this for some time and have not come up with what I need.

Basically what I want to do is in Excel using VBA query a database Access or SQL and take that data and create a...

its a field

Almost lol


strSQL = _
"SELECT Convert(varchar, Row_Date, 101) as 'Row_Date', var(split), Convert(varchar, starttime) as 'starttime', " _
& "sum(acdcalls) as 'Answered',...

Yeah unfortunately I only have read access to this database so I cant make any changes. If I could I wouldent bother with these long SQL statements ;) Ill try that conversion see what happends
...

AppActivate "Microsoft Excel"