Search results for query: *

Why don't you try creating a workbook object and range object first and then setting the gridlines, maybe the program is just fussy: dim objwkb as excel.workbook, objrange as excel.range set objwkb = myexcel.workbooks.add set objrange = objwkb.range("A1:O1") With...

I am using the sentonbehalfofname property for my email distribution but it is not available for an Outlook posting. I am using the PostItem object.

Yes, all the permissions are in place. I just don't know how to change who the posting is 'From' in code. When I create a posting manually I can change the 'From' field to my departments email address and it posts fine but I don't know how to change the 'From' field of the posting in code. I...

My situation is a little different. I have a program that writes the reports to the network. The reports are then reviewed and if everything looks good they are distributed. So the reports will not be routed as soon as they are created. I have the interface built that the user goes into once...

Thanks for the reply! My workgroup has a shared PC that is setup with the department's email so as a last resort the distribution program will have to be run from that PC. I am trying to set it up so that the user can run the program from their own PC.

I am wondering if anyone knows how to change the 'From' field in an Outlook posting. The situation is this: - Outlook postings are used to distribute corporate reports. - Currently the postings are created manually by a user. - I am automating the posting process and everything works fine...

Thank you very much, this is working great!

Hi, I have a worksheet where all of my data validation values are maintained and I use code to read from this worksheet and set the validation on a different worksheet. I have to do this because Excel 97 requires that the data validation range be on the same worksheet as the range being...

Hi, I have code that runs which sets the validation for a range of cells on a worksheet with a range of values from another worksheet. The code works very well. Once in a while I run into a problem where the cells that I have set the validation on lose the drop down arrow that displays a list...

You will need to use docmd > outputto to create the files on your hard drive. Then you will need to create a mail object in Microsoft Outlook (you will need to set a reference to Outlook) and attach the files to the object. Once this is done the files can be deleted from your hard drive.

AJ My suggestion is to set a recordset object for tblTest and run a loop that determines the record count. If the record count property is greater than zero and it doesn't change for a few seconds I would assume the transfer has completed. bev My suggestion is to create an excel object...