Hi!!!
I need a macro to:
save active sheet as new workbook on desktop + email to someemail@somemail.com.
name of workbook = concatenate cell C9 & H9 from active sheet (example: "555555-Moscow.xls" where 555555 is value in C9 & Moscow is value in cell H9 in active sheet)
thank uuuu
Last edited by arkharova.s; 02-18-2014 at 06:19 AM.
Hi
use the following code..
Please Login or Register to view this content.
Like my answer, then click * below
Hi, arkharova.s,
regarding copy the ActiveSheet you may try
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello HaHoBe, satabp,
thank you for ur inputs! in both scenarios excel shows run-time error 1004... do you know what is the reason for that?
thank you!!!
Hi, arkharova.s,
since 1004 is a not clearly documented error code in VBA you would need to tell us which line is highlighted in the VBE in order to narrow down the reason for this message to be raised.
Ciao,
Holger
Dear HaHoBe!
its working now!!! thank u very much!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks