+ Reply to Thread
Results 1 to 1 of 1

email code works but while running as application from another code selects whole sheet

  1. 07-05-2017, 09:36 PM #1
    jpbisani
    jpbisani is offline
    Forum Contributor
    Join Date
    12-23-2007
    Location
    chennai india
    MS-Off Ver
    2010
    Posts
    141

    email code works but while running as application from another code selects whole sheet

    When I run code Send_Range_Or_Whole_Worksheet_with_MailEnvelope() it works correctly. But when I run code TestCopyData it mails whole works sheet (tomail) instead of A1:G170 which is defined in Send_Range_Or_Whole_Worksheet_with_MailEnvelope(). In TestCopydata I have mentioned Application.Run "'copy from one sheet to anotherand mail vba.xlsm'!Send_Range_Or_Whole_Worksheet_with_MailEnvelope()". I am new to VBA, I could not trace out where the error is. Your help would be great and appreciated.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] trying to code is a test to see if a program/application is already running
    By Fawkes_ in forum Excel General
    Replies: 7
    Last Post: 01-17-2017, 06:26 PM
  2. [SOLVED] First Check An Application is running or not using vba then run the code
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-30-2016, 07:16 AM
  3. code works running in visual basic editor but not when running from Excel macro
    By smporco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2016, 05:44 PM
  4. Code to find if Application is running or available
    By annux08 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2015, 12:49 AM
  5. [SOLVED] Excel-to-eMail Code Works Only When Stepping Through
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2014, 11:19 PM
  6. Code selects entire rows upto one range and same code selects only columns for other.
    By sriharigk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 05:19 AM
  7. Application Error 1004 running Pivot Code
    By grifter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2012, 12:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1