User Profile

Collapse

Profile Sidebar

Collapse
Suggz
Suggz
Last Activity: Apr 11 '12, 06:58 PM
Joined: Feb 7 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Suggz
    started a topic Converting vba(excel macro) to vbscript
    in Visual Basic

    Converting vba(excel macro) to vbscript

    Hi All,

    Copying code from vba to vbscript did not quite work. I was hoping if anyone could give me a hand. The purpose of the code is to sort the selection so that the smallest value is on the top. I was wondering if there is a way to make this work. Thanks!

    This is the original vba code.
    Code:
    Range("F1").Select
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("Sheet3").Sort.SortFields.Clear
    ...
    See more | Go to post
    • Suggz
      started a topic Import text file into excel using vbscript
      in Visual Basic

      Import text file into excel using vbscript

      Hi,

      I am attempting to import a text file, but I get an error "(10094) ActiveX Automation: Object var is 'Nothing'."

      Not sure what the mistake here is.

      Code:
      Sub vba_excel_importing_file()
    Dim strFileName As String

    strFileName = InputBox("Enter the full path to the comma " & _
               "separated file to import")
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...