Recent content by SaintAugustine

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...

Indeed it does - tnx. It doesn't affect text boxes in the slide title view, only in the Slide view. And I can use F4 to reuse it over and over again. Tnx!

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...

Answer - Pack and Go works and includes animation, but it saves your presentation as a Show - meaning no one can go in and edit the presentation. It sort of makes your presentation "read only." The other wrinkle is that Powerpoint *links* to video files, it doesn't *embed* them. If...

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...

Ok, these are good responses, thanks - I appreciate everyone's help. These sources and some digging have given me pretty much everything I need. My final question was if it was possible to get this data without importing the Excel files as a table, and it looks like the...

Cool, thanks - these are a good place for me to start, I've made a little bit of progress on the macro already. I should have been more specific when discussing what I plan to do - I want to write a macro to get information from about 200 Excel files on a monthly basis. Importing all of these...

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...

You mean as text? Unfortunately, the form has some very fancy formatting which gets garbled when it's included as text in the e-mail.

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...

Also - how does the import command treat blank cells? As long as I have the "required" field set to "no" in the Design view, I should be ok, right?

Thanks Chifu - time to get out the Windex and work on cleaning my data, I guess. ;)

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...