I have an Outlook Calendar in the All Public Folders area that is automatically updated using the information from Access Queries. I am trying to make the same calendar save itself to a website. As of right now we just have to go in and do it by hand, but there is a push to make it all...
I currently have a code that automates the creating of an Excel chart every week from an Access Query. The problem is that it is capturing the rolling data from a table, and I only want the last 12 rows to be graphed. Is there a way I can do this programmatically, so that every week it only...
I need help!!! I need to find out how to trigger a macro on the event that a fields value is changed. If anyone can help me please post anything!!! If you know a good book about Project, please help.
Ed Rich
Here is the Code I currently have. Everything works except for the SetTaskField Method. Am I even using the right method. Can someone please help me.
Dim NumOfTask As Integer
NumOfTask = MSProject.ActiveProject.NumberOfTasks
For i = 1 To NumOfTask
Dim RemainingCost As Double...
I need to get the value of a field so that I can run an equation against it.
How would I write the VB to get the value of a field, like Baseline Cost or RemainingCost?
These are both Task Fields
I was given the task of creating reports within Project. It was something that was started before I was hired. The problem is that the person who created the reports used all the Custom Fields that Project has and Management wants me to write the VBA in Project to run the code in the...
Here is the situation...
I am currently creating an application that grabs a data dump; exports, formats, and creates a MS Access Database. It then exports the data to different Excel Worksheets and Graphs are created. I have everything working, but I can't get the graphs to reflect the data...
I have a multi-page report that I am exporting to an HTML File. I want to make it so that instead of exporting three html files (one for each page) it will put all three pages into one HTML file. Is this possible, and could someone please help me.
I am trying to email a file that I am generating from a report. The file is being created successfully, but I am getting an error when I try to read the information or email it, I am not sure where the error is occuring. Here is my coding:
Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage...
I am trying to ouput to a file then email an attachment of the file and a link to the webpage it will be on. I am receiving errors when I try to output the file, the email is working good. Here is my code, could someone please help?
Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String...
I am in the process of automating a report for a database. Currently I am outputting the report to a word file in rtf format. I want that file to be in the body of my message and then emailed out. Can anyone help me.
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.