I have found a code to pull outlook calendar information from outlook to excel. I am trying to determine how to pull from Shared Calendars. This code looks as if they calendar has a number (9), but I can't figure out what the other calendar's numbers would be. How to pull from Shared Calendars and how to pull the month for which the calendar is on. My shared calendars are under Calendars>Shared Calendars in outlook. So for example, I would need to pull John Doe's calendar information for January if the calendar was on January. My code is listed below.
Sub ListAppointments()
Dim olApp As Object
Dim olNS As Object
Dim olFolder As Object
Dim olApt As Object
Dim NextRow As Long
What I've got: This code allows the user to pick one (sub)folder - the MailItem properties of the folder are then printed to the sheet.
[Code] .....
My goal: Rather than allowing the user to pick one folder, I'd like to set up a hardcoded array of five subfolders found in a shared inbox. The hierarchy is as follows:
[Code] .....
The thing is, I have huge problems with referring to any of the red subfolders above. I think I'm able to point to the shared inbox if I substitute .Pickfolder with this, but then I'm stuck! I need to go down two levels in the hierarchy.
[Code] ......
I should be able to produce an array by myself so if I at least just could get a pointer on how to refer to one single folder that would be truly awesome.
I am trying to pull info from Access into Excel using Data, Import External Data, New Database Query. I follow the menu and when I get to the end for the info to be pulled to Excel I get an error.
I have created a spreadsheet that displays new dates in column D based on provided dates in Column B and recurrence intervals selected in column C. The dates in column D are when a training deadline occurs. I have been trying to get a macros written so that when a cell in column d is updated, an outlook appointment message is sent to the person doing the updating. The idea here is that anyone can use this without future coding (so their address would be placed in cell say A1)
So far all i have gotten is excel to send an email to me with the excel spreadsheet as an attachment, not really what I want. Again, I dont want somethign specific to my computer settings, I want to be able to send the spreadsheet out with simple instructions for the user to change their email in cell A1 and then every time a cell changes in column D, it automatically generate an appointment reminder for the new date.
I have a spreadsheet with info about students in a summer program. I need to pull out the students who have allergies along with what their allergy is and their emergency contact phone number. I would like this new info in a new spreadsheet.
Here is an example of the spreadsheet:
allergiesnamephoneallergy type nobob410.555.1234 nojim410.555.5843 yesmeg410.555.7458nuts nolex410.555.1159 yeswill410.555.5005fish
I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes
When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)
The problem I'm running into is obtaining the dollar amount within the cell. For example:
A1 contains: 11112222 $1234.56 Sample, Name Sample Note
I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.
Further, the dollar amount varies from $1.01 to $10,000+
I have a list of cities, counties, and schools with dates for each account. I want to put these into a workbook with tabs along the bottom for each one, then I want to be able to select all of the accounts that have a Jan 1st effective date and show them on a list in the first worksheet.
I have a regular table of data and dependent on the info within a column of cells I would like the info to appear within one of 3 new sheets. BUT.... I can't figure it out because the info forms an irregular part of text within the cells in a specific column - Obviously if it was dependent on the whole of the text I could use Vlookup but it's not.
If it needs further clarification, a column of cells may have, say, "blahblah234/PLblah" -> If this cell contains within the text "PL" then it should have the whole of the row in the new sheet, if not then blank.
I have monthly reports of sales by client number. I am now trying to pull the annual sales info by month for one client by name. Eg. each month, XYZ ltd has sales figures for various products. Is there a way of me grabbing all his sales info for the year with out having to open each spreadsheet
I am accustomed to using filters to find a lot of my information in large datasets.
However, now I am trying to use formulas to return specific values. For simplicity's sake, I have included a sample below with a couple types of scenarios I am looking to solve through the use of formulas. Would this involve sub-arrays perhaps?
i am using the attached sheet to export data from excel to outlook calendar from last 2-3 months. Now suddenly it stopped working for me (I didn't amend the code)
All the data i have filled in is in the correct format but the code doesn't export the data after ROW 72.
Basically, I run a DJ Management company, arranging bookings for 6 artists. What I'm trying to do, is have data be auto populated from the Master sheet, into separate sheets. The aim, is to create 1 master with ALL the dates for the month in, and the each of the separate sheets to only populate data relating to that artist.
For example!
Artist Event Location Fee Date
Tony Tomorrowland Boom, Belgium 5,000 01/05
[code]....
Now, I need to send the artists their individual schedules for the month, but I do not want to copy and paste individual rows to their new sheets as this is a pain. I know i can sort by artist and copy it easier, but really i just want to put in the info once and not multiple times.
So the master is sheet 1, on sheets 2,3,4,5,6,7 (each one assigned to a particular artist) i need the artists gigs for that month.
How to automate outlook 2010 calendar and email integration.
I would like to create a button that sends out calendar invites to a large number of recipients with different specific meeting details (date determined by spreadsheet and other details standard). I'd expect that this would populate a specific shared calendar (not my personal calendar) for managing these appointments. It would be good to avoid duplicate correspondence (e.g. via drop-down list or checkbox).
I've created buttons testing a few codes provided in forums, but have not been able to make these work correctly.
Attached is a simple excerpt of the spreadsheet I'm seeking to automate.
I'm trying to reference a public folder in Outlook and pull a date from a specific appointment. I can get this to work for my personal calendar but I cannot get the code right to reference the public calendar.
Code:
Sub GetApptsFromOutlook() Application.ScreenUpdating = False Call GetCalData("4/1/2013", "4/30/13") Application.ScreenUpdating = True End Sub
[Code]...
Now I'm very green when it comes to VBA but I've messed around with the last line of this code in all sorts of ways and I still fail to get the object reference correct. I'm not sure if this has something to do with doing it from excel, offline, online, etc etc...
I have a worksheet that has about 20 columns and 60 rows, but only need the data from 5 of the columns to link with outlook calendar. I want to be able to enter the date of completion of a task in the excel spreadsheet and have an reminder entered into outlook calendar a year later. I would like the Subject of the appointment to be the EMPLOYEE NAME and the Location of the appointment to be the TASK (what the employee has to renew) [these would be the column headers]. The duration can be ALL DAY for all appointments. A reminder would be fantastic!
The only other fear I have is each time I run the macro/VBA it will recreate duplicate appointments.
And I don't know if this is possible but one of the tasks (column) for renewal, ie: drug test, calls for an employee to be randomly selected every quarter. This will cause the employee to have a new annual renewal date in outlook but will outlook still retain the original annual renewal appointment date? I am sure we can live with this, but just a thought if there is a possibility of removing the original appointment it would be amazing.
I have attached example of worksheet. The yellow highlighted column headers contain the information I need renewal appointments created for.
I want to select a date of choice from a calendar in a field within an Excel spreadsheet.
I do not know how to do userforms and so that is why I wonder if I can add this in just a spreadsheet.
This is how far I have gotten so far: After doing the following, I have a static calendar setting in my spreadsheet like a text box showing the current date.
Developer Insert More Controls Calendar Control 12.0
Here is what I am trying to do with no luck so far.
If I type RS23U1R109000 in a cell A1, I want B1 to read the 5th letter or number and fill B1 with E86.
Example A1= RS23U1R109000 B1=E86 A1= RS23V1R109000 B1=E87 A1= RS23R1R109000 B1=E84
As you can see in my example, the 5th letter could be U,V,R or whatever, but I need cell B1 to read that letter and populate B1 with E86, E87, E84 or whatever.
I am using excel 2002 and I have found that when the workbook is shared and getting 2 or more users to open the workbook around the same time brings up a read only type prompt box for the 2nd ( and 3rd) user when the book hasn't fully opened for the 1st user/is still fully opening. Is this a limitation within excel or is there a way around this for example via vb code.
I know the more data a workbook has can cause it open a lot slower but is this the same for shared mode.
I have a file that has an original file format .xls
I saved as .xlsx (I am using Excel 2007) with a different name so I could make changes to the new file without changing the original.
That turn off compatibility mode.... but it is still "shared". While it is shared I cannot delete a sheet. In fact, I really don't even want it to be shared. If the file is open, and someone else opens it, I want it to open as "read only". I cannot uncheck the "Allow changes by more than one user at the same time. This also allows workbook merging." checkbox because it is greyed out.
Now, when it starts, I have a popup form asking for password for access for it. The problem is that for one person - AND ONLY THAT PERSON - the VBA Editor window opens and she has to press the "Play" button for it to hide and be able to enter the password to access the application.
The editor is not showing on any other computer. All computers are running Excel 2010.
Im using Excel 2010 and have a data connection that I want to use. I added it to a regular workbook and it updates perfectly as-designed. However, I need this feature to work in a shared workbook, but it doesn't.
We have a Shared workbook on our Server and about 5 users work at the same time every day. I want to understand something, If I open it I can see all the information in it, all the rows and so on, but if the same workbook is opened by another user he will see other information, the rows aren't the same as in my case. Why does this happen ? I would like the second users to see the same information as I do.
