Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sanyup2000

    Help with Password

    1. yes, u r rite. 2. macro is stored externally. They open the macro, Click run in the macro, select the file to process and the file is processed at destinatinon given. the template is saved at C:\. the template is read-write and i dont want them to enter the password. it should be called via...
  2. sanyup2000

    Help with Password

    ...As Date Dim ldPasteEffectiveDate As Date Dim mwbStaticReport As Workbook Dim mwbInvoice As Workbook Sub Selectfiletoprocess() '************************************************************************** *************** 'Name: GetUserInput 'Description: 'Arguments...
  3. sanyup2000

    Help with Password

    Unprotect does not work. My template is readonly, It still pops up asking for a p/w. Can u help ?
  4. sanyup2000

    Help with Password

    When I run the macro, I want to unprotect the workbook and worksheets automatically , and then protect them again via VBA when the macro has been completely run???? Let me know. I tried, this does not work. And with parenthesis, does not work either. This is before last EndSub in the code...
  5. sanyup2000

    Help with Password

    I removed that. So, that its not confusing. But, it was this before the last EndSub at the bottom. mwbStaticReport.Workbook.Protect Password mwbStaticReport.Worksheets("Valuation").Protect Password
  6. sanyup2000

    Help with Password

    And i am using Excel 2003
  7. sanyup2000

    Help with Password

    When I run the macro, I want to unprotect the workbook and worksheets automatically , and then protect them again via VBA when the macro has been completely run
  8. sanyup2000

    Help with Password

    ...As Date Dim ldPasteEffectiveDate As Date Dim mwbStaticReport As Workbook Dim mwbInvoice As Workbook Sub Selectfiletoprocess() '************************************************************************** *************** 'Name: GetUserInput 'Description: 'Arguments...
  9. sanyup2000

    Help with Password

    I have not been able to figure out with recording. SO, i posted it here. It breaks down on Protect/Unprotect line of code.iF i run without the protect/unprotect, the code runs just fine.
  10. sanyup2000

    Help with Password

    When I run the macro, How do I unprotect the workbook and worksheets automatically , and then protect them again via VBA when the macro has been completely run? Can anyone help ? To Run the macro: 1. Save the Template on C:\ as Template1.xls 2. Click Run on TestMacro.xls 3. Select...
  11. sanyup2000

    need to copy data from one workbook to another on selected cells

    In the above code, it breaks at: rngSource.Copy Destination:=rngDest Can you help ????
  12. sanyup2000

    need to copy data from one workbook to another on selected cells

    ...Double Dim liTransactionCounter As Integer Dim ldCopyEffectiveDate As Date Dim ldPasteEffectiveDate As Date Sub Selectfiletoprocess() '************************************************************************** *************** 'Name: GetUserInput 'Description...
  13. sanyup2000

    need to copy data from one workbook to another on selected cells

    What is the Parent and Address properties of rngDest? it is the Valuation worksheet. Not sure, if i answered your question?
  14. sanyup2000

    need to copy data from one workbook to another on selected cells

    It protected, but systems prompts to enter a p/w which i did? Even then i get an error. What can i do ?
  15. sanyup2000

    need to copy data from one workbook to another on selected cells

    ActiveSheet.Unprotect i got rid of it. I still get the same error.
  16. sanyup2000

    need to copy data from one workbook to another on selected cells

    ...As Integer Dim ldCopyEffectiveDate As Date Dim ldPasteEffectiveDate As Date Dim iCounter As Integer Sub Selectfiletoprocess() '************************************************************************** *************** 'Name: GetUserInput 'Description: 'Arguments...
  17. sanyup2000

    need to copy data from one workbook to another on selected cells

    I get a run time error 1004 (cannot change part of merged cells). I have posted the template, macro and source file. Save template on c:\template.xls. Click Run, select source file. Can anyone please help??? http://www.vbaexpress.com/forum/showthread.php?t=15956&page=3
  18. sanyup2000

    need to copy data from one workbook to another on selected cells

    Disregard..i am good and the code is working now, i think.
  19. sanyup2000

    need to copy data from one workbook to another on selected cells

    I get a run time error 70, (permission denied) when i try this. Code dies on this line If Dir(strNewPath) <> "" Then Kill strNewPath Thanks'
  20. sanyup2000

    need to copy data from one workbook to another on selected cells

    How do i keep the destination file name saved same as source file names?

Part and Inventory Search

Back
Top