Hi
IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS PROBLEMTHE
STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO DO IT??
1..Running a particular code from .XLSB file 2..This .XLSB file is locked and i
know the password also.3..Code which is in this locked .XLSB file runs
satisfactorily.4.. When it comes to copying some modules from this locked .XLSB
to opened XLSX file.IT FAILS
my understainding
Since some code is running from locked .XLSB file, this copying code also needs
to be runBUT THIS IS NOT HAPPENING WHY??
I TRIED ALL
THESE--------------------------------------------------------------------------------------------------------
Dim argPWD As StringargPWD = "tcs"Dim VBP As VBProjectSet VBP =
ActiveWorkbook.VBProjectMsgBox CStr(VBP.Protection)If VBP.Protection <>
vbext_pp_locked ThenExit SubElseApplication.ScreenUpdating = TrueSendKeys
"%{F11}%TE" & argPWD & "~~%{F11}", TrueEnd If
---------------------------------------------------------------------------------------------------------------
With Application.VBE.ActiveVBProject .SendKeys "lolla"
.SendKeys "{ENTER}" '
.VBE.CommandBars("Menu Bar").Controls("Tools") _
.Controls("VBAProject Properties...").Execute .SendKeys
"^{TAB}" .SendKeys "{TAB}" & "lolla" .SendKeys "{TAB}" &
"lolla" .SendKeys "{TAB}" .SendKeys "{ENTER}"
End With
----------------------------------------------------------------------------------------------------------------
NONE OF THESE ARE WORKING
PLEASE COMMUNITY MATES HELP ME
LOLLA SUDHEER
("Achievers never expose themselves,their achievements expose them")
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
