Search:

Hi,

I have the following code I found on the internet that would work great if the batch file I needed to run was located on my local computer. The windows batch file I need to run is located on...

That didn't work... here is all the code, in case I should have showed more than what I originally did...

Sub SendEmail()

Dim noSession As Object, noDatabase As Object, noDocument As...

Hello,

Below is code that works nicely (I didn't include the whole macro):Const stPath As String = "K:\Groups\ADP\2012\Schedules"
Dim stFileName As String
Dim FileName As String
FileName...

Hello,

I have been using the VBA code below to attach the ACTIVE Excel file to the Lotus Notes email. I have recently created another macro that does a "file save as" function to save the ACTIVE...

This is what worked:

=SUMIFS(H:H,D:D,D2,G:G,CONCATENATE("<=",G2))

I've reattached the example file - I've saved it in Excel 2007.

Thanks again Retired Geek & Steve!! I really appreciate all...

Bingo!!! Thanks so much Retired Geek... you rock. This is exactly what I was looking for, and could have used years ago. This will be a new formula that I'll be sharing with our accounting...

Hi Steve,

The concatenated column (column P) is correct. The sumif doesn't work if the periods are not sorted in chronological order. I've attached a new example.

Is there a formula that will...

Hi Retired Geek,

Thank you for your response. I know it sounds silly that I wouldn't sort the database. It's a huge database that I extract from our AS400 by using msquery. I have other columns...

Hi again!

I just realized that it doesn't work if there is a period missing from the database. The database is a trial balance, so some will not have all 13 periods, as not all periods will have...

Hi Steve,

That was awesome! Wow, I've used the SUMIF formula forever... I had know idea it could do that. Why I didn't ask this question before is beyond me. Anyway, I'm wondering if you could...

Hello,

I'm in need of a formula that would determine the accumulated total for each period. The kicker is that the database will be very large, and will NOT be sorted in an ideal format that...

Hi!

I have written the following code, which works, but then stops with an error at the end (so it really doesn't work :^_^:). Anyway, I think I shoud be using something other than the "For...

Hello,

I have the following macro which changes the CurrentPage based on what is in cell A1 for TWO different pivot tables:

Sub Testing()...

Of course! Rounding... now I feel really dumb. I round everything else in my worksheets, but I falied to do so in this table! Thanks so much for opening my eyes tfspry! I must have been sleeping!...

Hello... I have a vlookup formula (see attached) that is not showing the correct result. I'm looking up a percentage. I've used vlookup's for years, and have never had this problem. Apparently I...

Hi,
I'm hoping that there is a bigger square box in the character map than the one I'm using in the attached example. I'm wanting the box to be a bit bigger. I'm not interested in inserting an...

The formulas are still part of the table... when I click on a cell with a formula, the "Table Tools" tab DOES appear. In addition, if I pick the name of the query in the upper left hand corner of...

Hi,

I have a microsoft query in Excel... beside the ms query data that is downloaded I have several columns with formulas. Normally, these formulas fill up & down as the database that is...

I finally got it to work... I renamed the picture to "object 6", then I had to change the code from:

ActiveSheet.Shapes("Object 6").Select
Selection.Copy


to:

ActiveSheet.Shapes("Object...

Hi,
I have about 7 pictures that I've inserted into an Excel spreadsheet. When I recorded my macro to copy and paste one of these pictures it shows the following code:


...

Problem solved!!! Thanks so much Hans!! It's as simple as pressing Ctrl + 6 to turn off the display objects function.
Thanks again!
Lana

Hi,

Since our company upgraded to Excel 2007 in the last few months I've had 3 occassions where people are trying to insert a row into an old worksheet and get the following message:
"Cannot...

I put the line into VBA's immediate window and pressed enter and it worked (no error message) when I left it as a "1", but then got an error message when I changed the cache to a "2".... because I...

Do I have to run a macro to change this cache index, or do I somehow change this cache index in some type of "properties" area? I couldn't see the cache anywhere, so I must be looking in the wrong...

Hi Rory,

Thanks for the info.... I had already changed the data source, and this indeed did "unlink" the pivot tables, however when I changed the data source back to the original, the link...