dcsimg

Search:

Type: Posts; User: Siddharth Rout

Page 1 of 13 1 2 3 4

Search: Search took 3.62 seconds.

  1. Replies
    24
    Views
    2,298

    MsOf07 Re: vba-excel allow-paste-special-only

    Unfortunately, the code that you are using is not meant for such complex operation. You will have to re-do the code from the scratch keeping all your requirements in mind. Mind you, it will not be a...
  2. Replies
    24
    Views
    2,298

    MsOf07 Re: vba-excel allow-paste-special-only

    Hi Stephen

    Got your PM. Slightly busy with other projects and hence was not able to reply on time. Anyways, I see lot of posts above. So if you want me to effectively and quickly help you then can...
  3. Re: need a code to remove special character

    You do not need to write so many lines if you want to remove them. Here is a shorter way to do it :)



    Sub replChar()
    Dim ws As Worksheet
    Dim rng As Range
    Dim SpecialCharacters As...
  4. Re: Using TRIM with Evaluate Isn't Working

    Here is one piece of code which you will rarely see being used :)

    You can TRIM a range in one line i.e without looping.



    Sub Sample()
    [C1:C1000] = [INDEX(TRIM(C1:C1000),)]
    ...
  5. Re: I need help - Macro to print page to pdf and send to a person on a list

    The code by Ken is good. Go ahead with that :)
  6. Replies
    9
    Views
    1,149

    Re: [RESOLVED] closing excel problem

    I have not tested this but try this. This will not leave an instance.



    Sub main()
    Dim oXLApp As Object, oXLWB As Object, oXLSht As Object
    Dim QuitIt As Boolean

    '~~>...
  7. Replies
    9
    Views
    1,149

    Re: closing excel problem

    If your query is not resolved then you do not need to mark it as resolved :)
  8. Re: Need help writing some VB code

    You seemed to have missed what I mentioned in post #25?

    Is this what you are trying? I fixed the Caps issue as well.



    Option Explicit

    Sub Sample()
    Dim MyArray() As String
  9. Re: Need help writing some VB code

    >>>Is there any way of removing the Input box so it can be added only if needed? As in putting the code in a comment?

    Yes put a single quote before it :)



    'This is a commented code

    ...
  10. Re: Unpin files from taskbar with VB.net code

    I hope TG has cleared the confusion regarding merging of the threads :)

    Did you try the code that I gave? You can easily remove the entries using that code.
  11. Replies
    11
    Views
    1,041

    Re: INSERT image in subitems of lisvtview

    I answered a similar question 8 years ago :D

    Is this what you want?

    http://www.vbforums.com/showthread.php?562763-How-to-add-checkboxes-in-subitem-of-listview&p=3478144&viewfull=1#post3478144
  12. Re: Need help writing some VB code

    Sorry was having Dinner. Replace



    '~~> Highlight duplicates
    For Each itm In Col
    Selection.Find.ClearFormatting
    Selection.HomeKey wdStory, wdMove
    ...
  13. Re: Need help writing some VB code

    You mean just highlight the text or the number?
  14. Re: Need help writing some VB code

    Great. If your query is solved then feel free to mark the thread "Resolved". If you do not know how then see the link in my signature :)
  15. Re: Need help writing some VB code

    Simply remove the Inputbox and change the line



    If Left(MyArray(i + 1), 4) = Ret & "-" Or Left(MyArray(i + 1), 5) = Ret & "-" Then


    to
  16. Re: Need help writing some VB code

    I thought you wanted to choose?
  17. Re: Need help writing some VB code

    Is this what you are trying? :)



    Option Explicit

    Sub Sample()
    Dim MyArray() As String
    Dim n As Long, i As Long
    Dim Col As New Collection
  18. Re: Need help writing some VB code

    Ah I see.. So you want to type "HCI or ERL or MSRS" and it should highlight the duplicate for those?
  19. Re: Need help writing some VB code

    Like this?

    HCI-10001
    HCI-15002
    HCI-15153
    HCI-10001
    ERL-14122
    ERL-15002
    ERL-10001
    MSRS-51112
  20. Re: I need help - Macro to print page to pdf and send to a person on a list

    Well you need the desktop version (MS Outlook - Paid Version). Else do what Pete Suggested. Use CDO :)
  21. MsOf365 Re: Macro / VB Coding help needed please

    Great!

    If your query is solved then feel free to mark the thread resolved :) If you do not know how then see the link in my signature.
  22. MsOf365 Re: Macro / VB Coding help needed please

    That is because there is some space in the worksheet name. Go to the worksheet and retype the name of worksheet in it's tab. Remember to remove the spaces.
  23. Re: I need help - Macro to print page to pdf and send to a person on a list

    Welcome to vbforum :wave:

    >I have been able to do a bit of code to convert an excel sheet to a pdf and send it via gmail but I dont know what the next steps are

    Why not use Outlook? It is much...
  24. MsOf365 Re: Macro / VB Coding help needed please

    Is this what you are trying?



    Sub Sample()
    Dim wb As Workbook
    Dim wsI As Worksheet
    Dim NewFileName As String

    Set wb = ThisWorkbook
  25. Re: Need help writing some VB code

    I guess you are replicating my stackoverflow post? :D That logic will not work here.

    Ok quick question. What should happen to these numbers. I mean what output are you expecting?

    Before
    ...
  26. MsOf365 Re: Macro / VB Coding help needed please

    So this is what I have understood.

    1. You are running this code from the workbook "Blastbag Work Instruction"
    2. There are 2 sheets. INPUT" and "DATA"
    3. The filename is in cell D8 of INPUT...
  27. Re: Need your help to work this faster and doesnt freeze when running the code.

    I only give code in a platter if I am paid for it LMAO (Just Joking)

    I can but I want you to try it yourself. Else how will you learn mate?
  28. MsOf365 Re: Macro / VB Coding help needed please

    Ok scratch that. Let's start from the beginning.

    We will rebuild from the start and we will try and have only one macro in lieu of 5 if possible :)

    Explain what exactly are you trying to do....
  29. Re: Need help writing some VB code

    Can i see a sample document? You can zip it and upload it here
  30. MsOf365 Re: Macro / VB Coding help needed please

    Then

    1. Declare a workbook and worksheet object
    2. Open the workbook which has the path/filename
    3. Read it from the cell
    4. Use it in your code
  31. Re: Need your help to work this faster and doesnt freeze when running the code.

    I just gave your code a quick glance. Here are few of my observations

    1. Avoid the use of .Select. Work with the object directly. See the below link

    Avoid using select

    Example
  32. Re: Need help writing some VB code

    How many numbers are there? If there are few numbers (say around 20) then you can put them in an array and then loop through the array.
  33. MsOf365 Re: Macro / VB Coding help needed please

    Why are you using ActiveWindow.SelectedSheets.PrintOut method? Why not .ExportAsFixedFormat when printing/saving as pdf? It will let you specify the filename as well.

    You may want to see the below...
  34. Re: Need help writing some VB code

    That is a good start. Now the next thing. What kind of numbers are expected? "_id1", "_id2","_id3" etc? Is there a trend that we can see. If yes, then identify the lowest number and the highest...
  35. Re: Need help writing some VB code

    I am ready to assist but I need to see efforts from your side. If you are doing this from VBA Word then I hope you know that you can record a macro and then amend the code to suit your need?
  36. Re: selenium vba runtime-error 438

    The .HideCommandPromptWindow property was available from version 1.0.18

    You are getting that error because you are using an old version of the wrapper. My guess is that you are using version...
  37. Re: Run Time Error 1004 application defined object defined

    Trish

    When you are working with `Worksheet_Change` event, you have to be very careful. I have explained it here

    Worksheet_Change

    Also if you have correctly defined your objects and variables...
  38. Re: Problems with #VALUE in VBA Function - SOLVED!

    Glad to be of help :)
  39. Re: Convert folder name and file location to a clickable link in excel

    ADO can be used strictly to transfer raw data to a workbook. You cannot use ADO to apply formats or formulas to cells. You may want to see this

    ExcelADO demonstrates how to use ADO to read and...
  40. Re: Disable start button and task bar via VB.net in ppsm

    Office Dev thread merged with Vb.Net Thread and Moved to VB.Net
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width