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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.