Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Byron
 
Posts: n/a
Default Macro to automatically open a website or send an e-mail in excel

How might I create a macro that detects when a field is changed from one
status to another and automatically either creates a popup to a webaddress or
sends an e-mail?

For example: In the Status field, You can select yes, no or maybe. If the
value is changed from yes to no, I would like macro to automatically detect
this and create a questionnaire e-mail or to link to a website.
Any help would be greatly apppreciated.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Macro to automatically open a website or send an e-mail in excel

Try this
http://www.rondebruin.nl/mail/change.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Byron" wrote in message ...
How might I create a macro that detects when a field is changed from one
status to another and automatically either creates a popup to a webaddress or
sends an e-mail?

For example: In the Status field, You can select yes, no or maybe. If the
value is changed from yes to no, I would like macro to automatically detect
this and create a questionnaire e-mail or to link to a website.
Any help would be greatly apppreciated.



  #3   Report Post  
Posted to microsoft.public.excel.misc
Byron
 
Posts: n/a
Default Macro to automatically open a website or send an e-mail in exc

Hi Ron,

Thank you for the suggestion, I'm still playing around with it as I have
very little experience with Excel macros. I was wondering if it is possible
to automatically open a internet explorer browser with a preset webaddress
instead?

Also, do you know if you can run macros from an excel uploaded into a
sharepoint site?
Thanks,

-Byron

"Ron de Bruin" wrote:

Try this
http://www.rondebruin.nl/mail/change.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Byron" wrote in message ...
How might I create a macro that detects when a field is changed from one
status to another and automatically either creates a popup to a webaddress or
sends an e-mail?

For example: In the Status field, You can select yes, no or maybe. If the
value is changed from yes to no, I would like macro to automatically detect
this and create a questionnaire e-mail or to link to a website.
Any help would be greatly apppreciated.




  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Macro to automatically open a website or send an e-mail in exc

Use this
ActiveWorkbook.FollowHyperlink Address:="http://www.rondebruin.nl/Google.htm"


Also, do you know if you can run macros from an excel uploaded into a
sharepoint site?


No


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Byron" wrote in message ...
Hi Ron,

Thank you for the suggestion, I'm still playing around with it as I have
very little experience with Excel macros. I was wondering if it is possible
to automatically open a internet explorer browser with a preset webaddress
instead?

Also, do you know if you can run macros from an excel uploaded into a
sharepoint site?
Thanks,

-Byron

"Ron de Bruin" wrote:

Try this
http://www.rondebruin.nl/mail/change.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Byron" wrote in message ...
How might I create a macro that detects when a field is changed from one
status to another and automatically either creates a popup to a webaddress or
sends an e-mail?

For example: In the Status field, You can select yes, no or maybe. If the
value is changed from yes to no, I would like macro to automatically detect
this and create a questionnaire e-mail or to link to a website.
Any help would be greatly apppreciated.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Macro - Open Word with Excel macro Bill Excel Discussion (Misc queries) 3 May 23rd 05 11:21 PM
How can I import a website into my excel sheet automatically ever. Mohamed El Hefnawy Excel Discussion (Misc queries) 2 April 13th 05 04:51 PM
Button fails to call macro when open an Excel via Intranet tigertax Excel Discussion (Misc queries) 1 April 12th 05 10:21 AM
Excel 2003 / Send To / Mail Recipient / body text is removed jmaynard2 Excel Discussion (Misc queries) 1 March 16th 05 03:26 AM


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"