Recent content by angel007

  1. A

    Run VBscript using Macro

    I figured it out... I could get macro working so I am runing it via comand button Thanks Mark for all your help
  2. A

    Run VBscript using Macro

    When i run the above code i get "Invalid Procedure Call or argument" Error
  3. A

    Run VBscript using Macro

    yes shell ()function. But I am not sure if i am suppose to use it over there. If you know any other way to Run a vbscript please let me know. Thanks!
  4. A

    Run VBscript using Macro

    Hi, Please can anyone help me to Run a vbscript using macro. I am new at this and definately missing something thats not letting me run the macro. I am selecting RunApp and in Command Line this is what i am writing ShellExecute("C:\Documents and Settings\admin\My Documents\Test\Test.vbs")...
  5. A

    Transfertext Method

    Hi, My bad! Here is my complete code... Dim A Set A = CreateObject("Access.Application") A.OpenCurrentDatabase ("C:\test.mdb") A.DoCmd.TransferText acImportFixed, "Spec name", "test", "C:\\test.txt" Set A = Nothing msgbox "Done!" Thank You!
  6. A

    Transfertext Method

    Hi,I need some help with Transfertext Method…. When I run my vbscript code it inserts empty rows instead of data..:(　Please can anyone look into this and let me know what I’m doing wrong…A.DoCmd.TransferText acImportFixed, "Spec name", "test", "C:\\test.txt" Thank you!
See more
Back
Top Bottom