Recent content by TropicalFred

Tried it and now I get the "Object Required" error on line 3. I also moved it to another machine and got the same results. I am using Office 2000 and Win 2000 Pro. If you think of anything else, let me know. Thanks.

I have a VBScript that runs fine when I save it as a .vbs file, but when I put it into an Excel VBA module and try to run it I get a VB "Object Required" error on the first line. What am I doing wrong? VBS code: Set WshShell = WScript.CreateObject("WScript.Shell") Set objEnv =...

Is there any way, using VBS, to change or delete the “From” field in an Outlook 2000 e-mail? I am sending out a custom e-mail to 400+ people in our company. I developed a VBScript to automate the process and it works great with one exception. I would prefer that the "From" field either show a...

How about: Range("A" & ActiveCell.Row).Activate -Fred

Sounds like your formulas have already lost their refernces and need to be re-entered. What do the formulas look like now? Do you know what the formulas were (=Count("A1:A100"), for example) before you started getting the #REF error? -Fred

You could try something like this: Sub totsheets() Dim wrksht, wrkshtname, rownum, colltr, totrownum totrownum = 1 For Each wrksht In Worksheets wrkshtname = wrksht.Name Worksheets(wrkshtname).Activate ActiveCell.SpecialCells(xlLastCell).Select rownum = ActiveCell.Row...

I think we need a little more information. What is the formula on the "Summary" sheet, and how are you deleting the data on the "Month" sheet? If you are just highlighting the range of data and using the delete key, any formulas referencing those cells will remain...

Is the file in a local folder on your machine, or in a shared network folder? Is the file open on one machine when you are opening it on another machine? I'm just thinking that this may have something to do with security and/or file sharing issues. TropicalFred

Try this: Open your Excel spreadsheet. Click on Tools > Options. Select the Transition tab. Under Sheet Options uncheck Transition formula entry. Clcik OK. Save worksheet. Import to Access. Hope this helps. TropicalFred

Not sure that formatting will help you here. An empty cell is an empty cell regardless of format. You may need to actually have something in the cell, a single quotation mark or a space for example, to prevent it from coming across as a zero. Hope this helps. TropicalFred

I believe that PHV is right and that you are searching for the text "True" and Excel is finding the value of the result of a True/False Boolean expression. Try this: Before you do your search/replace, copy the range of True/False cells and paste them back in the same cells as values...

What I have done in a similar situation is to just add check boxes at the bottom of each column or at the end of each row that say, "Select Col/Row" and another button somewhere that says, "Select All." Probably not the solution your looking for, but it works for me. Good Luck.

You could use a formula like this (where E2 = Column E, Row 2): =VALUE(LEFT(E2,4)&"/"&MID(E2,5,2)&"/"&RIGHT(E2,2)) This will return the MS date number which you can then format any way you like. Good Luck.

In the format editor, under the hyperlink tab, I selected "An E-mail address" and then used the formula editor to create the formula "mailto:" & {Data.eName} where eName is a field in my database that contains e-mail addresses. This fills in the To: field in the e-mail...

I have a CR 9 report distributed through CE 9 that has several fields formatted so that when the user clicks on a field it opens up a blank e-mail form with an address in the To: field. My question is what will happen if a user tries to do this on a machine that is connected to our WAN but does...