I am not much familar with data connections to/from excel or automating emails but I remember when I had checked "data query" property (i got it by right-clicking on a cell in a sheet having external data connections) I had seen an option for "background refresh". When I enabled this feature, excel was available for use while it refreshed the data in the background.
Have you noticed that when an excel application is busy (running a macro etc.) you could always open a separate excel application using [WINDOWS + R] key and entering "excel" in the dialog box? Why don't you run a separate excel application programatically (i guess you can even keep it invisible), get the data refreshed and values copied to the original workbook later when the refresh is complete? Please let me know if any of the above solve the problem Can you please email me the workbook (or a part of it) which you use to send emails to yourself or any other way of posting data from an excel workbook to a web site? I prefer the easiest way of doing it. That is may be like by generating an easy url like http://mywebsite.com/?mymsgsub=test%message?body=blah%blah%blah and without depending on a configured MS Outlook account. Thank you :) -- Hemant Hegde --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
