Recent content by teters

Gavin, Thanks again for the helpful post. That deserves a star. Also, I didn't realize there would be that much code involved. I will start in the other forum the next time. I will use the code posted above to finish my project. Again, thanks for the time and effort. thanks. Scott

Gavin, I added the .HasFormula to the above code and it worked. Now I need to loop thru A1:Z200 to see if any of the cells has formulas in them. When a cell has a formula I will need to stop on that cell and put a border above it and then continue to loop. Do you have any code that will loop...

Gavin, You given me a great idea. I was looking at it the wrong way. If I can identify the total rows with the =sum then I can create a macro that will place a border above the cell with the =sum in it. Know, how can I identify the formula in a macro. Here's what I have so far...

Gavin, Thanks for the reply. I wish I could do that. All strings coming across can/will be different. The information that is being displayed will be laid out by the month Jan, Feb..., but I never know what month it will start with. We are importing accounting data (like a P&L statement)...

Hi all, I am trying to import a .txt file into Excel. The problem is that the txt file has subtotals in it and I want to make lines above the subtotals - to make them standout - like in a spreadsheet. Is there anyway to bring across the underlines, bold, italics when importing? Are there any...

I'm confused on how the blackberry is supposed to work. Right now I am receiving the emails that are redirected from my Outlook 2000 client. That works great. But when I read and delete the email from the blackberry the emails do not go away in Outlook on the desktop connected to the LAN. Is it...

thank you bc21640! you just saved me a lot of embarrassment.

I got it from an AT&T Wireless Dealer. The model is a 7210.

First, I am new to the Blackberry handheld. I have been going through the documentation and found a table that lists the current OS for the Desktop Redirector and the Blackberry OS. I am currently running Desktop Redirector 3.6 and on the Blackberry I am running 1.6. I would like to update the...

I am running Raptor 6.5 on a Windows 2000 machine. I am trying to set up OWA on our internal mail server (exchange 5.5 also on Windows 2000). How can I redirect the URL that someone puts in to the address bar? For example, a user opens IE and types "http://mail.myservername.com" - I...

mapleleaf, I finally got it to work. Thanks for all the information. Instead of making a direct link to the winword.exe, I went through the scheduler and made the scheduler point to the ...Word.lnk pointer. If I pointed directly at winword.exe, Normal.dot was not loading. By pointing to the...

Thanks Serbtastic that part worked. Now I can't get the macro to run when Word opens. I have a macro, Autoexec, that runs if you click on the Word shortcut, but does not run when you run Word from the AT. According to Microsoft any macro starting with "Auto" will automatically run when...

I'm tyring to schedule a task using the AT command on a W2K machine. The task is to open Word 2000. I can go to a command prompt and type the path to the winword.exe and it works, but when I try to schedule it, it fails. Is there something special about the executable that won't allow it to run...

I am new to programming as well as VB Script. I am trying to send multiple HMTL attachments via SMTP using CDO. I am able to get the html documents to attach, but what I am having problems with is looping through the code. I am tyring to group the html docs by location, when that location...

I have 2 hp v40's setup in 2 different locations. Windows 2000 is running on the laptop and the printers are local. The laptop has a docking station at each location. Users cannot add local printers to their machine - an administrator has to add the printers. The printer drivers were installed...