Recent content by rcreek09

Wow, just want to say thank you guys so much for this blog. Amazing that this post on an ODBC connection was able to help me with my vba code that has absolutely NOTHING to do with ODBC. I knew there must be a way to write to a network drive WITHOUT using the drive letter, but could not get it...

Here is what I ended up using. I could NOT get the vba format to work as I expected. An awful lot of trouble just to get this: August 25, 2012 - August 31, 2012 vs August 27, 2011 - September 02. 2011 Code: thisweek = Right(Range("a13"), 10) thisweekty = thisweek thisweekly = thisweekty...

Thank you Sir, for the speedy reply. Unfortunately, I cannot access dropbox from work but I will try this as soon as I get home this evening. Without seeing the file/code, I'm not following you very well, but I trust it will be clear when I can get the file. The "mmmm dd, yyyy" works for me...

I have tried every format I can think of to get "August 24, 2012" and I cannot. What am I doing wrong???? Code: Sub formatthedate() Dim thisweek As Date Dim lngDateFormatType As Long lngDateFormatType = Application.International(xlDateOrder) 'Order of date elements: '0 = month-day-year...

Gees, you don't miss a thing! You are of course correct. I typed it in rather than pasting and I missed the A2! Again, thanks so much. It is so nice to be able to get context specific, INTELLIGENT, timely help. This site is a lifesaver. Have a great weekend.

=SUMPRODUCT((ISNUMBER(FIND(B10,(A1:K1),1)))*A6:K6) This seems to be working for all conditions! I do have to use a space with the A, O, or Ms but I can live with that. Awesome!

I see how that works, but that defeats the purpose of my lookup cell. I would have to change my sumproduct formula every time I change the input. When I want to look up "weekly", I have to change the sumproduct to ....right(a1:k1,6). Same for Monthly, etc. I can certainly do that, but it...

I am trying to sum the table below based on the column headers. I want an input cell, "condition to sum", so I can enter a partial header and then sum accordingly. Example, sum all columns CONTAINING "A", or all columns CONTAINING "Weekly", etc. The sumif works for only the first line of the...

Just those from MicroStrategy, but there's two graphs per sheet. Thanks to Chandoo site, I think I can write the code, if I can figure out how to select/copy the graph images. Have never written anything for selecting/copying images. Then just paste special as jpg, and put in a loop. Will...

That is progress. It works. Next problem is that I export graphs to 100+ sheets at a time. I'm wondering if there's a better way than selecting/pasting each graph on each sheet, one at a time? if that's what I have to do, I have to do it. I just keep thinking there's something I can fix in...

I export directly from MicroStrategy into Excel. I add some grid data, comments, etc., then save the file.

I import graphs from MicroStrategy into Excel 2010, then save the files. The graphs are only visible on MY pc. Every other user gets this: X - The linked image cannot be displayed. The file may have been moved. . . bla, bla, bla. It is 'linking' the image to a temp file on my hard drive...

It looks like that will be just about perfect. Thanks so very much!

I feel like I'm overlooking something obvious, but I have searched Help, and Chandoo and can't find the answer! I have a workbook with multiple sheets that is used to receive imported data. The data is manipulated, then a printout is done. Then the file SHOULD BE closed without saving, to be...

WooHoo! That did the trick. Many Thanks!