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...
The Reason I am coding it is because I am not the end user, if I was the end user I would just use the wizard, but I was given the task of pulling info from a data dump, formating it, creating reports, and automatically creating the Charts in a clik of the button. That is the reason why I am...
Well, I have the data transfered into Excel, now I want to hard code a chart. I need to create two Series, one of which is stacked, and I need to create a second axis. I am not really a coder, but I have been elected to code this in VBA. I am looking for all the help I can get.
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.
Look at the Help files. Believe it or not they explain it really well. You don't have to use one, but they just let you design the Title and so forth. But it is all in the Help files.
I did the same thing, what email application are you using. I tried it and my mail appliaction actually printed out all of the TAGS. I am actually using a txt to send it now. I hope this helps.
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 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 was just omitting it for security reasons. This is the code I came up with in the end. Thank you for your help.
Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String
Dim outFile, filename, date1, path, ext As String
MyDate = Date
date1 = Format(MyDate, "mmm d yyyy")
path =...
I ran into the same problem recently, I found that the easiest solution was to write a macro that was linked to the second button, and when you click that second button it closes the first report.
I hope this is what you were looking for.
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.