+ Reply to Thread
Results 1 to 3 of 3

I have a Question in VBScript..

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    2

    I have a Question in VBScript..

    i have the below lines in the text file.
    j*k*j*d*k*j*e*r*u*u*~*******
    t*r*n*x*w*i*~****
    Q*Y*P*r*n*x*w*i~******.

    Now i need to write a vb script to Delete all the stars "*" those are present after the ~. Is this Possible to do...

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: I have a Question in VBScript..

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: I have a Question in VBScript..

    Find & replace..

    Find : ~~~**
    Replace : [Blank]
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CSV/XLS via VBScript
    By Leonidars in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2012, 08:24 AM
  2. How to use autofilter in vbscript
    By Rashme in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2011, 01:03 PM
  3. Vbscript Excel question
    By Catherine Jackson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2006, 06:35 PM
  4. macro will not run from vbscript. help please
    By vedran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2006, 10:45 AM
  5. Please help with ADO and VBScript!
    By jenhu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2006, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1