Search results for query: *

I'm trying to write a macro that will run down the column to the right of a table and change the value of those empty cells to "value to left of active cell *divided by* table total" in order to let me see the percentages. My loop seems to work fine. The problem I'm having is with getting VBA...

I'm working on a Presentation in Powerpoint that has slides inserted from various other sources. I've re-applied the slide design, but the format for the slide headers remains inconsistent. Changing them to the proper format means resizing the font, changing the color and changing the...

Augh! A Very Important Client and Close Personal Friend of the Boss just called me up to go over the video clips I had inserted into his Powerpoint presentation. They worked fine on my laptop - but now they won't play for him or for me on my desktop!! He says when he tries to run it he gets...

Anyone ever have any problems with using Word's Track Changes feature on RTFs? I heard from a friend who heard it from a friend, etc, that it wasn't reliable and that sometimes changes were lost. I haven't seen this myself, but I haven't tested it thoroughly. Is it a load of hooey?

Another access question - after trying the TransferSpreadsheet function, I got error #2391, "Field 'F1' doesn't exist in destination table.' I checked the Microsoft knowledge base, and it instructed me to create an "import specification." So I'm trying to do that (basically...

Does anyone know of a good source if info on how to make "Advanced" Access Queries? I'm trying to make an Access database which populates itself by taking certain data from standardized-format Excel files. I've made Excel macros before (though I'm far from an expert), but this is...

I'm using the Microsoft Word 97 Mail Merge feature to send out several e-mails at once. The thing is, I'd like to these e-mails to include a form as an attachment (the form is another Word doc). I can't figure out how to insert the attachment into the Word doc and have it included in the...

Ugh. I'm trying to import a file from Excel into Access, since the file has just gotten too darn big for Excel. The problem is, the importing isn't going well. I get an error message at the end, and it turns out that either 1) nothing has been imported or 2) most of the rows have been...

My boss sent me a Powerpoint presentation that someone else created. He wanted the bullet points to slide in via Animation, but for some odd reason, they won't. When I click the "preview" button in the Animation window, they behave accordingly, but when I click "ok" and...

I'm trying to generate an index in WOrd 97 using a concordance file. The results didn't combine consecutive page references into page ranges (ie, if Ronald Reagan was discussed on page 3, 14, 15, 16, the index says "Reagan, Ronald 3, 14, 15, 16 instead of 3, 14-16") Is there a way to...

Howdy folks, I've got a big list of values, which unfortunately aren't numbers - they're letters (let's pretend it's letter grades: A-F). There are two columns: Last Year and This Year. I want to write a formula to see if the values have increased or decreased. =TRUE would work great, but it...

Howdy folks, long time no see I've encountered an odd problem working with Powerpoint - I've been sent some presentations that were created with no template, just in the black and white. When I try to apply the template, not everything gets changed - frequently the title and the body text stay...

Howdy guys, I'm trying to...well, long story. I'm writing a macro that will rename a worksheet tab based on user input. The problem is that the name of the worksheet combines a couple of variables - so the variable for the name sometimes exceeds 30 characters, but worksheet tabs can't be over...

I'm trying to make an option button rename itself when it's selected. So my question is, is there an object name for a Control? "ActiveButton" or something? Basically, what I'm trying to do is have option buttons that say: Do you own a dog? * Yes * No If the user selects Yes, an...

Another question (gotta love people who say "by the way, I need this by tomorrow") I created a bunch some "Yes / No" option buttons, and I grouped them so that if the "Yes" is selected, "No" can't be selected at the same time (duh). The problem is that...

Hi all, I made a mock-up spreadsheet so people here could track some data...strictly internal. The way it's set up is, names on the top, categories on the left: ....|.Dog.|.Cat.|Gecko| Type|Mamml|Mamml|Lizrd| Fur |..Y..|..Y..|..N..| Legs|..4..|..4..|..4..| Beak|..N..|..N..|..N..|...

Hi all - another super-urgent question. I'm working with a coworker's graph of stacked columns. A client (the same one as before) just asked me to remove two of the three types of data displayed and to add a new one. I've added the new one, but I want it to be displayed underneath the...

Ack! Big Powerful Lawyers need to print out a Powerpoint presentation I made. Our company template is a dark background with light text. So when I print the slides, much of the text & chart labels are invisible. Is there a way around this? Help!

Hi all, I'm working (peripherally) on something that automatically generates many pivot tables to help sort data. There's a pivot table on each tab. A problem I'm encountering is when I choose a different sort option from the Pivot Table's dropdown menu (in the worksheet itself, not in the...

I'm making a Table of Contents for a workbook. I'd like the ToC to be interactive. Is there a way I can turn each entry in the Table of Contents into a hyperlink that will take the user to the appropriate worksheet? I know this can be done with VBA, but writing a macro for each tab and...