Search results

  1. zelarra821

    Solved Create several MergeField by VBA

    Hola, Edgar. Perdóname por no contestar antes, pero he estado de mudanza, y con el trabajo además, me ha sido podido responder antes. Yo ya le he encontrado lo que pasa. Es un aplicativo de la Administración, que genera informes en Word, pero hay campos que da error por algún motivo que...
  2. zelarra821

    Solved Create several MergeField by VBA

    Hi. It works fine for me. That's what I need. However, there's a little problem with blank fields (attached files) when I execute to get fields value. Is there an option to skip that window? Thanks a lot.
  3. zelarra821

    Solved Create several MergeField by VBA

    Hi everyone. I need help with a problem I'm having with Word. I have a table with the field names I need to create, and I want to do it using VBA, so that it goes through the left column and generates the field as it appears in the right column, like this: {MERGEFIELD Example1}. I've only...
  4. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    Thanks, Edgar. It's all right.
  5. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    Ok, guys. Thanks for all information.
  6. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    Do you know where I can find more information and examples for VSTO addin? Thanks.
  7. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    I know that. Thanks for that advise. So, how could I block access if user try to enter via Developer Tab?
  8. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    I know That's the reason I want to learn how to hide VBA project, not protect. Thanks.
  9. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    I've already solved it. What I did was create a form to ask for a password if the user wants to access the VBA project, enabling or disabling ALT + F11, and hiding the VBA window if opened via the Developer tab. Thank you very much.
  10. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    Hi guys. I need your help. I want to protect/unprotect a VBA project using SendKeys based on the value of a specific cell in a specific sheet. I created this macro, in which I set the sheet where it will check whether or not to protect the VBA project and the password, and then use SendKeys...
  11. zelarra821

    Solved Help with a bat file

    Fixed. Here's the error: fso.GetFileName(file.Path) --> objFSO.GetFileName(file.Path) Thanks a lot.
  12. zelarra821

    Solved Help with a bat file

    Ok, that's fixed. Next: For each file In objFolder.Files file.Move targetFolder(i) & "\" & fso.GetFileName(file.Path) If I try to see every single file by "WScript fso.GetFileName(file.Path)", I get nothing.
  13. zelarra821

    Solved Help with a bat file

    I noticed that For i = 0 To Ubound(sourceFolder) Set objFolder = objFSO.GetFolder(sourceFolder) sourceFolder doesn't get folders path
  14. zelarra821

    Solved Help with a bat file

    Awesome. So, I need set this: if there's more than one file, vbs script should move all files from every single folder. This is bat script I want to rewrite to vbs script: @echo off echo. SET choice= SET /p choice=¨Quieres mover los archivos? [S/N]: IF NOT '%choice%'=='' SET...
  15. zelarra821

    Solved Help with a bat file

    Hi guys. I'm having a problem with a bat file that I can't seem to solve, and it's driving me crazy. I want to count the files in a folder and its subfolders, but without including a file type or the name of a specific file. This is where the problem lies: no matter how many filters I use, it...
  16. zelarra821

    Solved Unicode compression when creating a table

    Awesome. Thanks a lot!!!!
  17. zelarra821

    Solved Unicode compression when creating a table

    I've already managed to get it working. Now, this doesn't fix the problem for me. Dim prj As CurrentProject Set prj = Application.CurrentProject prj.Connection.Execute "CREATE TABLE TEvents " _ & "(DateEvent DATETIME, Name CHAR WITH COMP)"...
  18. zelarra821

    Solved Unicode compression when creating a table

    Dim dbs As Database Set dbs = Application.CurrentProject dbs.Connection.Execute "CREATE TABLE T00CopiasDeSeguridad " _ & "(Fecha DATETIME, Nombre CHAR WITH COMP)" dbs.Close Application.RefreshDatabaseWindow I have tried both...
Back
Top Bottom