Search results for query: *

Okay, I'm back with more goofy questions about custom reports. I think once I get these all figured out I'll be set. I now know how to make custom reports and get them onto the enterprise global so that everyone can use them. But I do not know how to specify the columns for the reports. From...

I have created a custom report for my managers to use. I turned this into a global report, but they still can't see it. Is there a way to make it so that everyone can use this custom report? -Dave the Perpetually Confused

My co-worker is experiencing weirdness when trying to open an Excel file in a SharePoint portal page. It is pulling it up as an Excel file directly in Explorer, but her standard choices are not allowed (File, Edit, View, etc.) She can use some of them, but not anything that will allow...

I am running an Excel sheet with a macro attached to a command button. The first order of business in the macro creates a backup copy of the sheet. My PC does not like this, however. The macro was created by another user in our shop, and I am the only one that is having this trouble. The...

I know this is foolish. I have a spreadsheet that is color coded beyond belief. Because of its complexity, we need to be able to count how many of each color are in the range. I have that one figured out by using the following: Function CountByColor(InRange As Range, _ WhatColorIndex As...

This is similar in scope to what SamDemon wanted to know in thread "thread68-817810". I have a document that (due to managerial doctrine) MUST be done in Word with calculations. This is a 3 column table that has the following properties: A1: Dollar Amount (Call this Cell Monthly) B1: 24 C1...

This is just a curiosity question. I received an email in Outlook 2003 that had a picture that kept changing. Unless this is an animated gif file, is there any way to replicate this? I do not believe that this was a gif. I think it could be kinda cool to do sometimes. -Dave the Perpetually...

I have a large spreadsheet that has duplicate entries. Normally, I could use the DeleteDuplicateRows() sub that I got from here (Thanks!), but in this case the dups are in strikethrough font. I wrote a small sub: Sub TestingStrikethroughDelete() Dim c As Range For Each c In Selection If...

I have a huge spreadsheet that I've been tasked to turn into an Access database, but have only a passing familiarity with the app. The data on the sheet looks like this: Programmer: REQ ID: Member: Ticket #: John X Y3943071 BL39RRDB 26827 BL19CRDB...

I loaded a new game onto my system on Saturday, which required DirectX 9. Everything was fine until last night, when it froze like a popsicle. I ended up having to do a cold boot and got the infamous BSOD. This in itself is not a problem, but it won't reboot. I get to the screen that allows me...

I was creating a set of switchboards for work, and then created a master switchboard to link the whole thing together. Unfortunately, I had to run away from my desk before I got very far on the master board, so I saved it. Stupid me, I had nothing in the Main switchboard so when I load the file...

I have a user that is having trouble with her keyboard. WHen she types, extra characters are inserted, seemingly random. For example, if she hits an 'L', it will print the 'L' but may also through in a 'K' or an 'O'-somtimes both. We've taken the keys off and cleaned the heck out of it, but it...

I have a user who has made no changes in recent days, but her Office documents take up to a minute to close. I'm not talking about Word or Excel itself closing slowly, but the documents. Documents open as normal and the programs open and close normally, but the documents are maddening. I have...

In Word 97, my document shows fine on the page, but once I go to Print or Print Preview, it effectively doubles all of the carriage returns. The paragraphs are still set at single spacing, when viewing all non-printing characters it does not show anything amiss and I have already deleted and...

I have a user who cannot open Word 97 documents on her Windows 95 PC, unless she first opens Word and then opens the file through the menu. I have reinstalled, deleted the Normal.dot and reassociated the files with Word--all to no avail. Any thoughts? -Dave Any dog is just a dog. But if...

I recently took over a sys admin position and found that our backup program has not worked in a long time. Our tapes go back a month and they're all bad. The main issue is that it calls for a second tape, but since it runs at 2 in the morning, no one is here to change it. It times out & sends...