Over 1 million tech questions and answers.

Reminders from Excel Workbook via Outlook

Q: Reminders from Excel Workbook via Outlook

Hi

Can anyone please assit me on how to make an Excel workbook give me a reminder via Outlook.
I want a reminder that will tell me when a specific task has not yet been completed.
we send requests to a custodian when we a looking for a document. on the excel sheet we enter the date we sent the request, but I want a reminder when the received date column has not been updated if I have not received the documents within 3 days time in order to follow up with the person.

can you pease assist me

regards

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Reminders from Excel Workbook via Outlook

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 73.6

Hi all,

I'm looking to create an Excel document and I need to put cells with dates in that are linked to outlook calendar reminders.

I.e I need a macro that when I click the link it sets the reminder on outlook for the date allocated in the cell.

could anyone please help me with this as i have never created a macro and would greatly appreciate any help you could give me.

Thanks

Read other answers
RELEVANCY SCORE 73.6

Hi guys,

I have read tons of pages from this forum hoping to create a killer excel workbook so my daily tasks can be completed way faster and more efficient, however I have hit a brick wall. That brick wall is called "How in (insert whichever holy character you want)'s name do I get Outlook to obey Excel".

My request is rather simple, yet I don't have the brains for it. Once a week, probably on Monday, based on the attached excel, I want to send specific e-mails to colleagues informing them which documents should they start writing based on the "Deadline to be filled" column and to also inform them what is going to happen based on the Column "When will it happen". Here's how I think the code should be displayed in my humble and unadvised opinion:

If "Col G" = yes, then do nothing
if "col C" is between today() and today()+7, then e-mail must be displayed
Subject = Work schedule
To: ?Col E?
Cc: ?Col F?

Body:
?1ST PART - I am trying my best to understand excel/vba language, so I'm adding hypens like y'all pros when I do a comment

Dear colleagues,

The following actions must be completed this week:
- ?Col A? for ?Col B? ? deadline to be filled ?Col C?
- ?Col A? for ?Col B? ? deadline to be filled ?Col C?
- Preliminary hearing for Yellow SRL ? 09.05.2016 (example)

?2ND PART

Also, if "col D" is between today() and today()+7, then the following tex... Read more

Read other answers
RELEVANCY SCORE 73.6

Hello.
I have been tasked to keep track of follow ups for Implementation dead lines.

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date is 14 days away from being implemented/addressed. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. J), with subject "Audit Follow Up_Audited Function (Col. A) is due on Due date(Col. I)", and body "Dear Name(Col. K), Reminder - Audit Follow up on Implementation Date"
Also, the script should put a check mark on Reminder sent column (Col. L) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help. I've attached my sample spreadsheet.

Thanks
 

A:Automated Reminders excel 2007 thru Outlook

Read other 10 answers
RELEVANCY SCORE 73.6

Hi all,

I am looking for help on VB script to send automated emails based on the dated column in excel sheet..
I need to send reminders to the email addresses in Column J & K to remind them that the vehicle registration in Column B is due an MOT on the date in Column M, also to send a reminder that the Tax is due on the date in Column P. these emails need to be sent 14 days before the due dates.
I also require Column N & Q to generate at date and time when the reminder was sent.
I would much appreciate any help with this as I am completely new to VB script, I have attached the file to aid in any help
 

A:Sending Email reminders from excel to outlook using VBA

Read other 11 answers
RELEVANCY SCORE 72.8

Hi All,

I am new to VBA and although there are many links in the forum regarding the topics of using Excel to send Email reminders to Outlook, my requirement requires an additional option which i do not know how to program to make it work. I hope I can be assisted.

I am currently using Outlook & Excel 2010, Windows 7.

Using the attached test example, I have created a spreadsheet which is used daily. It requires a reminder email to be automatically sent out ONLY if the following is triggered.

Row H (Send Reminder) must show YES, then it will only send on the date shown on Row G (Due Date). However, if Row H shows NO, it will not send even though Row G has Due Dates.

The body of the reminder message would say:

Subject: Reminder

The project assigned to you under reference number, "cell D3" in the name of "from cell E3" for the confirmation date of "from cell N3" is now G3 - C3 days old.

If this has been completed, please ignore.
 

Read other answers
RELEVANCY SCORE 72

Hi All.

Hi i have a excel file which has Serial No , Task and date of completion as 3 ccolumns.
I keep on missing the tasks. I heared from somwwhere that we can create automatic reminder in outlook based date picked from excel. I want the same. Example on 1, april, 2010 - if i have to go to my lawer, the in outlook on 1st-Apr-2010 a reminder comes , visit to lawer Mr. XXXXXX.

If any one can help that would be of great help.

Regards,
sam
 

Read other answers
RELEVANCY SCORE 72

I'm in HR and I have a spreadsheet that incorporates staff information commencing, with each month in a new sheet. Unfortunately, department managers are forgetting to do staff reviews at 3mth, 5mth or the 6mth probation. I've entered formula to calculate these dates from the staff commencement date.
Now I need to find out if I can have some sort of Macro or VBA coding to email me a reminder to contact the managers a week prior to the the review/probation dates.

Please help! I have no idea with coding/programming etc.
 

A:Excel 2016 to send Outlook email reminders on various dates

Try the attached, one thing to note that you had the probation dates in the wrong place

6mth, 3mth and 5mth

so I changed it to 3\5\6

when you open the workbook the macro will run and generate an email IF any dates is below or equal to 7 and above or equal to zero. Meaning that there is a week until the review is required. This code will fail if the review date is in the past, this can be changed to tell you that a review date has been exceeded.
 

Read other 1 answers
RELEVANCY SCORE 72

Hi I would like to get VBA/macro codes to send an automated email to the email IDS mentioned in the file when the invoice due date is less than 2 days of current date. please help me
 

A:Excel 2016 to send Outlook email reminders on various dates

Here's a similar thread on the forum. If you can follow the code, then you can adapt it to suit your needs.
 

Read other 1 answers
RELEVANCY SCORE 72

HI, Its my first post here. I need to send reminder mails from outlook based on excel reminder dates.
For this i should not open excel neither i know VBA scritping for this.
Please provide help on this.
As i attached my file i need list of assets need to be calibrated ahead of 45 days of calibration due date.
 

Read other answers
RELEVANCY SCORE 70.8

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 70.4

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?
 

A:Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?
 

Read other 2 answers
RELEVANCY SCORE 68.8

I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?

A:Excel 2010 - Workbook to Workbook Reference?

  
Quote: Originally Posted by Lewiedude


I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?


Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Looks like it's possible.

Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.

Read other 3 answers
RELEVANCY SCORE 66.4

Hello, advicer
I do not understand why sometime I cannot copy a range from a workbook to another workbook in EXCEL (but I can if i paste the range in the same workbook). My PC is in the network of the company using WinNT 4.1. Please help me
Many thanks
Qan
 

A:Excel: Cannot Copy from Workbook to Workbook

Read other 7 answers
RELEVANCY SCORE 60.8

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 59.6

I have a workbook located on \\server\servershare\type2015
file name: TYPE.xlsx

how do i write the path of the table name in my query.

Any suggestions?
Thanks.
 

Read other answers
RELEVANCY SCORE 58

Hi im trying to sort out a system for work that allows me to receive e-mails about 2 weeks before a piece of equipment is due to be calibrated. This runs on a yearly cycle but we have enough equipment to be doing this every week. I have set up an excel sheet with all the information on and currently have to scroll through this all manually which is time consuming. I noticed the thread

http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel-3.html

And this sounds like what I am after but I have no idea what any of the info means or where to start, can anyone help me please.

Or does anyone know of a good free software for asset tracking and data logging???
 

A:E-mail reminders from Excel

Read other 7 answers
RELEVANCY SCORE 58

Hi
i would appreciate some help with this.
i have a spreadsheet with delivery dates. i want the cell next to date highlighted when its due for delivery.
Please see the attached spreadsheet.

Thanks in advance.
 

Read other answers
RELEVANCY SCORE 58

Hi All,

I have a File in which i store all the billing records of my transmission circuits, but most of the times, i missed billing of some circuits or vendor didn't send the bill.

Is there any mechanism in Excel 2007 through which i get notified either via Popup or email or ballon notification about the missing bill?

An urgent help would be helpfull.

Azfar
 

Read other answers
RELEVANCY SCORE 58

Hi guys! I've been looking on this forum for quite some time and I did find some useful information about creating outlook reminders in Excel. However, I didn't find exactly what I am looking for.

I need to create different reminders using information in the same line. I have attached an example of my document. I have 12 tabs, each representing a month. All upcoming groups are separating by their arrival date. Each group has either 1 or 2 deposits required by a certain date, And some groups have a rooming due by another date.

For exemple, in January, I have Montcorr coming. 1st deposit is due on 12/30, 2nd deposit on 01/02. The rooming list of due on 01/09. As for the deposits, I need to receive a reminder the day of. As for the rooming list, I need a reminder 3 days before the due date.

Can somebody please help me out? I know this might be a little complex... But thank you!!!
 

A:Set multiple reminders in Excel

Read other 14 answers
RELEVANCY SCORE 58

I used to be happy with Works 2002 calendar reminders. They came on at startup without the program being on. Now I have Outlook 2003 and the reminders only work whem the program is on. Does anyone know how to automatically turn them on at startup without the rest of the program.
 

A:Outlook 2003 calendar reminders don't work without Outlook being turned on.

outlook needs to be up and running.

drag it into the startup folder, reboot.
 

Read other 3 answers
RELEVANCY SCORE 57.6

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 57.2

I send invites to lots of all day events from my Outlook 2003 to users who have Outlook 2010. When I send these through I set them to not have reminders set. However, when they get accepted to Outlook 2010, it sets a reminder which means they are being woken up at 11.45pm by reminders for these events. I assume this is a compatibility thing between the two versions? Does anyone have any ideas on this?

This is becoming a real pain for our managers so any assistance that anyone can offer would be appreciated.

Thanks, Stephie
 

Read other answers
RELEVANCY SCORE 57.2

Hey Everyone,

First post here. I was fallowing this thread:
http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

And i have a similar problem i could use some help with. Now that i think about it it might be harder than original thought of. I have a workbook with 12 sheets, one for each month. For each month i have a list of Magazines titles all in separate rows in one one column. to the right of those, i have each day of the day of the month. I have attached a sample spreadsheet of what i mean. On any day a sales rep will call me and book a day they want to send a email, or eBlast message to subscribers of the particular magazine they choose. I would love to have the option to have an automatic email send to each sales rep 5 days before ther scheduled booking is to be sent out, only problem is how would i extract the email address from a comment in excel, and have ti send a email to that person?

Another idea i had was to creative a booking sheet for which each sales rep would fill it out with fields such as Clients Name, Date to send email, Type of email, Geo targets, creative elements in email etc etc. is there a way that once i approve this and send back the excel file with an approved icon or logo and some notes, can it automatically, even without being open, send an email or reminder to the user i sent it to?

i greatly appreciate any comments as i know i most likely trying to ask for the world here.

Thanks!

Connor
 

Read other answers
RELEVANCY SCORE 57.2

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

A:Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

Read other 1 answers
RELEVANCY SCORE 57.2

Hi,

I have created a workbook that tracks individuals qualifications that shows me those who need to renew in 90,60,30 days. I can toggle between the 3 or set different parameters if needed.

Instead of copying and pasting those details into an email i would like to be able to auto copy to another sheet and send a snapshot of the date required to renew to the individual and their line manager for 90,60,30 days

In my head I would have 3 buttons (or 4 if we could do an overdue one too) which i would press to pull through the info and send?

Is this possible and can you help??

Thanks
Richard
 

Read other answers
RELEVANCY SCORE 57.2

Hi friends,

I have not used Excel for ages apart from basic adding formulas etc.

What I am trying to do is make a set point (date) that turns a box red if one year has passed since the original date entered.
(not sure if I have explained it very well?)

ie
I am making a list of alarms on some machinery & want to show that the alarms have been tested within the past 12 months.
If I do not get around to testing, I would like the relevant field to change colour, so that a simple check upon opening the spreadsheet will tell me what is overdue on testing.(eventually there will be a lot of different alarms within the spreadsheet)
I am not sure if it will be easier to make an "issue date" then another field for "review date" or just have the one field that will turn red if today's date passes 365 from the last test date? (is that possible?)

I am sure it is easy - unfortunately, not for me!

keep the faith

Rob
 

A:Excel formula for annual reminders

You need to apply conditional formatting to the cell you want to change colour.

Condition is the formula type. Formula is

=today()>=(yourissuedatecell+365)

In the formatting, select fill colour to suit and any special borders / font formatting. Hit apply.

You can change the range affected by the formatting, but you might need to lock the column / row, depending on what you're trying to do.

No need for a due date field
 

Read other 3 answers
RELEVANCY SCORE 57.2

Hi There

I would like to set up an automatic email reminder for the attached workbook

I would like an email reminder to be sent 1 year prior to the expiry date in (COL F) then 3 months prior and then again when due
I would like to send the reminder to my own and potentially multiple emails.

To set up a macro as such would the programme and said file need to be open. every time the computer starts up?
 

Read other answers
RELEVANCY SCORE 57.2

I am trying to put together a reminder from a spread sheet to email me in say 3 months from a date in a specific cell. is this possible?
 

A:excel 07 setting email reminders?

will some one plaese tell me if this is possible?
 

Read other 1 answers
RELEVANCY SCORE 56.8

I have a shared workbook that when some people open it the formatting does not show the same. Example I have hidden columns, but they don't see them hidden
 

Read other answers
RELEVANCY SCORE 56.8

I created an Excel workbook to monitor my investments. One of the work sheets contains a long column of currency values from an annuity investment with each row showing daily values.

Presently, I manually copy the daily value of that investment and paste it into worksheet # 2 that contains all of my investments. Worksheet # 2 daily refreshes, updates and totals all investments.

My question is this: is there a formula that would automatically copy and paste the daily annuity values from worksheet # 1 into worksheet # 2 without having to manually copy and paste? If so, could you please guide me through the steps to accomplish this?

Many thanks for your prompt attention and cooperation.
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 4028 Mb
Graphics Card: NVIDIA GeForce 9800 GT, 1024 Mb
Hard Drives: C: Total - 476837 MB, Free - 414208 MB; D: Total - 114439 MB, Free - 21161 MB;
Motherboard: Intel Corporation, DG43GT
Antivirus: avast! Antivirus, Updated and Enabled

<edited by moderator (etaf) to reduce font size - not required default forum font size is adequate >
 

A:Excel investment workbook

Read other 9 answers
RELEVANCY SCORE 56.8

Hi there

Sometimes I click on the X to close the workbook and I accidentally press NO when the computer prompts me to save the workbook since it usually comes up in a yellow box that does not really capture my attention. This usually happens when I'm in a hurry or late at night when I'm half asleep. Is there some code that makes a message box pop up with a message that says in big bold letters "YOU FORGOT TO SAVE YOUR FILE" when I click on the X to close the workbook? If so, this will save me a lot of headackes.

Mario
 

A:Save Excel workbook.

I am no guru, however I did find this in the hep wizard of MS Excel. Hope it is of some help to you.

Save workbooks automatically as you work
On the Tools menu, click AutoSave.
If the AutoSave command is not on the Tools menu, you must install the AutoSave add-in.
How?
Select the Automatic save every check box.
In the Minutes box, enter how often you want Microsoft Excel to save workbooks.
Select any other options you want.
 

Read other 3 answers
RELEVANCY SCORE 56.8

Hello guys.
Please guide me through building my own tool in Excel.
I need to have workbook WK 1 with macro to modify another workbook WK2 which already have macros in it.
That is my plan : WK1 should have several command buttons first is to find person by ID from WK 2 , copy entire row with persons details to WK1 list 1, another button same but copy entire row to WK1 list 2, than when both lists created, I must have third command button which will : for each person in List1 WK1 will change value in cell 1 in WK2 from none to 1 and cell 10 enters =today date, for each person in List2 WK1 will delete value in first cell of the row in WK2.

I am keep loosing the track of what would be most simple way to do those steps, WK 2 file name is changing every day with date in beginning of the name of file,
 

A:Need help Excel 2 modify other workbook

Read other 13 answers
RELEVANCY SCORE 56.8

I have an Excel (2010) template from which I need to create separate workbooks for our range of ocean-going vessels.

Requirement 1
Upon loading the template, I need to prompt the user to enter the name of the vessel.

Requirement 2
The name must be transferred to a particular cell, probably A1, in proper case.

Requirement 3
I then wish to save the workbook using the vessel’s name, in capitals, followed by a space, a hyphen, another space and then the rest of the filename – based on the name of the template.

Example 1: name of template Record of voyage.

Example 2: name of workbook OCEAN TRAVELLER - Record of voyage.

Any thoughts?

 

Read other answers
RELEVANCY SCORE 56.8

Howdy, kinda new here. Anyway, I've got a doozy I can't seem to figure out. We just installed dual-monitors and now Excel is coming up saying "Not enough resources to display completely." It does this even when Excel is just started, with the blank, new workbook. There doesn't seem to be any screen real-estate issues since there's now double the screenspace. Any thoughts or ideas to try would be greatly appreciated.

-Ted
 

A:Not enough resources for Excel, even with a new workbook.

Read other 13 answers
RELEVANCY SCORE 56.8

Hi,

I am using Office 2013. I have a workbook which has to be shared. I want to protect it in a way that none of the options can be changes (like I have enabled 'track changes'. 'highlisght changes from users' etc). I do not want that someone turn off the 'track changes' option or as a matter of fact any other option.

They, however, should be able to edit the workbook. Is it possible?

I tried searching but could only see an option to protect workbook structure but noes not protect options.

-regards
 

Read other answers
RELEVANCY SCORE 56.8

Hi,

I am working on an Excel 2002 report. I need to be able to create a copy of the workbook, strip it down a bit (for uploading purposes), and let the user save it as he/she pleases.

Is it possible to make an active copy of a workbook without saving it?
Excel VBA help is not being very "helpful" on this matter.

Thank you,
ABentsionov
 

A:Copy Excel Workbook

Hello, welcome to the board!

It is always best if you work from a saved file. This is just generally a good idea. Is there a reason you do not want to save the workbook? You need to save to do what you want. There is a way, but it is more convuluted than just saving your file.
 

Read other 3 answers
RELEVANCY SCORE 56.8

My O/S is Windows Vista and I am running M/S Office 2000 Professional. In the past when using Windows XP I have been able to change which workbook opens when I open Excel. Now with Vista, I have designated 2 different workbooks to open when Excel begins however I cannot delete them form the Excel XLS folder. When I delete them, the screen shows that they are gone however when I strat Excel afterwards, they are back! How can I dlete them and install a new workbook. The standard process shown in the Excel help files is not working. Thank You.
 

A:Excel Startup Workbook

Closing duplicate...........replies here: http://forums.techguy.org/business-applications/672809-revise-excel-startup.html
 

Read other 1 answers
RELEVANCY SCORE 56.8

I write a few macros for other users, and right now I just request that they rename the workbooks each month (or however often they run it) to the same names and then offer a reminder at kick-off. Something like:
Code:
If MsgBox("Are the workbooks saved as 'Workbook_1.xlsx' and 'Workbook_2.xlsx', and are they both open?", vbYesNo) = vbNo Then
End
End If
Windows("Workbook_1.xlsx").Activate
Range("a3").Select
Etc, Etc
Otherwise, I don't know how to make changes or run actions based on workbooks whose names might change. But is there a better way? I've had some people - those least familiar with automation - forget to rename, ignore the message, and then call with problems. Perhaps there's a way, instead, that asks them to name as variables whatever the sheets are called, though this might require some hand-holding, such as a list of what workbooks are open? I don't know. I'm open to suggestions - just putting it out there.

Thanks!

Windows XP
Excel 2007
 

A:Excel VBA: Prompt for workbook?

Read other 10 answers
RELEVANCY SCORE 56.8

Tech Support Guy,

I have a question regarding linking two Excel (I am using Office 2003) workbooks and varying worksheets.
Here's what I want to do, using a macro, create a link to a cell in workbook A/worksheet X to workbook B/worksheet X (where X is variable).
Now creating a link is easy, except I want the "link" itself to appear in workbook A.
I tried the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= Workbooks("Workbook B.xls").Worksheets(Worksheet A).Cells(57, 3).Value
However, Excel places the value instead of the link in the cell. I want both, meaning, you see the value in the cell, but when you highlight the cell, you see the link to the 2nd workbook.

I have also tried the the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= "='[Workbook B.xls] Worksheet A '!R57C3"
This gets me what I need except as I mentioned, the worksheets vary and I have not been able to figure out how to do use a variable worksheet name in this example.
I appreciate your help in solving this problem
Take care,
RJ
 

A:Excel Workbook Question

See if using the indirect function is the solution?
 

Read other 1 answers
RELEVANCY SCORE 56.8

When I attempted to save an Excel workbook, I couldn't because the file name had changed to a number. What should I do?
 

A:Can't Save Excel Workbook

Read other 7 answers
RELEVANCY SCORE 56.8

I have two workbooks I'm trying to combine in a VBA macro. The first excel spreadsheet is just simply a sheet of 30 columns of data and 5k rows. It adds a new row every day.

The second sheet will be the model with the macro. I would like to write a script that will use a sort of vlookup to the data sheet to pull in specific parts of the datatable instead of searching through the whole big sheet.

For example, see attached. The Model tab lets you input a date or dates in the C column and then it would have to somehow search another WORKBOOK, not within this one as the example shows (for simplicity). Any ideas would be much appreciated.
 

A:Call Excel Workbook in VBA

Read other 9 answers
RELEVANCY SCORE 56.8

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

A:Please Help ASAP: Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hello,
I have a excel through which I track the delivery schedules of a large number of IP's for a design.
I looking how I can automate in excel to send reminders to the IP Providers.
Based on the Actual delivery date, I need to automate the excel to send out reminders.
Please let me know how I can do this. If you need to look at the excel, I can send it.
Thanks
Nagesh
 

A:Sending Email Reminders to Different people from Excel

Hi Nagesh!
Wy did U put the same thread twice!
 

Read other 2 answers
RELEVANCY SCORE 56.8

Hi,

My excel sheet has 3 columns.

1st column has email ids
2nd column has has Name of employee
3rd column has their respecive DOB

My requiremnet is;

An auto generated email (saying "today is xyz, abc's birthday") should be sent to everyone in the list whenever there is someone's birthday.

Also, can this be achieved even if the excel sheet is closed? If we use the google spreadsheet and write some script for the auto alert? let me know if this is posible.

Please help

Rgds,
Saqib Khan
 

Read other answers
RELEVANCY SCORE 56.8

Hi!
I am using Excel to track many IP deliverables for a project. almost 100 IP's
In the excel I have Initial/current/Acutal/date of IP delivery.
Based on the Aligned(Actual) IP delivery scheduled date, I am looking at how to automatically send Email reminder to the IP Provider on or before the aligned from Excel.
Please do let me know how I can acheive this automation.

Thanks
Nagesh
 

A:Sending Email Reminders to Different people from Excel

Read other 16 answers