Search results for query: *

I have a Word 2003 document (form letter) that we have people open, fill out, then email to a specific list of people. I have code in the document open event that expands the envelope header and populates the recipients with the list of people. Problem is, I get the warning message that a...

Hello - I'm a vba guy, don't know javascript very well so I need some help. I have a simple page with a table that has three columns. Each cell in the right column has a hyperlink. I want to be able to type a url in a text box, hit submit, and the script would then add a row to the table...

I have an Outlook macro that opens an excel workbook when an email arrives to a specific folder - but if excel is already open it opens another instance - also if the desired workbook is already opened, it opens a read-only copy. This is what I have: Dim xlApp As Excel.Application Dim wb As...

Hey all, We just upgraded to office 2003. I had several excel 2000 workbooks/sheets that I sent out every day. I'd saved them with the recipients in the 'To:' field and then when I reopened them, the recipients were already there. Now with 2003, I can't do it. What's up? Thanks...

I have a worksheet that is emailed by many to many daily. Many people still send it as an attachment rather than just the sheet. I've instructed till I'm blue in the face. I want a button that invokes the 'send to' command and allows the user to choose the recipient from their address book...

I have a daily report in excel that needs data from web pages. I currently open/print the web pages, then enter the needed data in the report. I'd like to (at least) open and print the web pages for now...I don't really know where to start. Any help would be appreciated... Thanks...

I'm having trouble referencing range names in my code.. I have several ranges named "range01", "range02", "range03" etc. I want to clear the contents of all the ranges and this is what I have, and it gives me an error 1004 'Method range of object _worksheet failed" dim rname as string For i...

Question: I'm trying to load a variable array with numbers, say 100, then sort them, and load a second array with the lowest, next lowest, etc. something like load a variable array: for n = 1 to 100 variable1(n) = rnd(1000) next Then sort them and load another variable so that...

Hi - I have an excel sheet with 5 image controls - I'm loading pictures using the loadpicture method which works fine - however I have to send the pictures with the workbook - I'd like to have all the pictures on a seperate sheet in image controls, i.e. sheet2.image1, sheet2.image2, etc - then...

I'm building a form in Access 2K - there is a multiselect listbox that users will pick items from then click 'print' and a report for each item will print. That's done. I also want to populate a temporary table with each item selected to use in a query for a report. Basically a hard copy list...

Hey gang. Just today, when I start a new email message in outlook 2k running on win 2k - the new blank email has a data file attached. I open it with notepad and it appears to be a header from a previous email, i.e. recipient, sender, ip address, etc etc. in a. the file name is something...

Question: I have a win 2k pro machine with a 120 gb hd that I use for a file/backup server. It contains all of our engineering data-CAD files, etc. Currently it's around 40 gb total size. I purchased some 120 gb external USB Western Digital hard drives that I want to use for my backups but...

Hey gang. I'm having trouble getting an array formula to work right in excel. I have three rows of data. The top row is a percentage and the bottom two are whole numbers. I want to add the numbers in the 2nd and 3rd rows and multiply by the percentage in the 1st row for each column of...

We had a power failure and everything shut down. Now I can't browse the network due to an error that says, "..there are currently no logon servers available.." I have unjoined the domain, rebooted, and rejoined the domain. I have verified all tcp/ip settings are the same as any other client...

Hello, I've built a report in Access and am now building a form to launch it with option groups for users to set criteria. I'm having difficulty setting the OrderBy property. I want the user to select if the report is sorted either by Part Number, or by Inventory level, and either Ascending...

I'm having difficulty getting my conditional formatting to do exactly what I want. I have data in 5 columns spanning many rows. The left column is populated with weekly dates through the end of the year and every week data is entered in the columns to the right. The first column of data is...

All of a sudden I can't leave the home page with IE 6 on an XP Home box - It is set up as a workgroup - not part of the domain. No matter what I change the default home page to with internet tools, it comes up fine when I open the browser - but if I try to navigate away, the browser hangs and I...

Hey gang, I'm having trouble with a query statement. Expr2: IIf([forms]![frmName]![checkbox1]=True,[EndTime] Is Null,[EndTime] Is Null Or <[forms]![frmName]![txtEndTime]) If the checkbox is checked, the query works and returns only records with no EndTime, but if the checkbox is not...

Hey all, How can I attach a usb camera to a pc wirelessly? I have a usb camera attached to a pc - however the camera is 20 feet from the pc. (it's for a laser shooting simulation) I've been using a 20 foot active usb extension cable which works most of the time, but occasionally either the...

Hello all, I have two pc's on my network that have recently started giving me a 'Primary disk not found' error (not at the same time, about a month apart) and prompts me to hit f1 to continue. I do, and they both boot fine. One is running NT and the other is 2K (and a dell that's less than...