Search:

Type: Posts; User: Shahzadt; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    185

    Re: VBA Code to delete Keyword

    Try The following on test data before using it on actual data. Let me know if this is what you were looking for


    Sub DeletesKeywords()

    Dim NewStr As String
    Dim i As Integer
    Dim MyArr As...
  2. Replies
    2
    Views
    300

    Re: Format VVBA Subtotals in a Dynamic Range

    if you could post a test or a sample file it would be great. try the following on a test file and see if it works for you.


    Private Sub cmdReport_Click()
    Dim WSsrc As Worksheet
    Dim WSReport...
  3. Replies
    2
    Views
    256

    Re: New sheet with select values VBA

    I don't see a file attached. which line is causing the code hangup?
  4. Re: Trouble with Excel 2010/ MS VB for Applications - Compile Error: User-defined type not defined

    go to tools>references check to see if you have check mark next to LawSSOHttp2 if not then find it in the list of references and the check mark next to it. see if it works
  5. Re: How to do a VLookup Macro when array varies in each report?

    Hi Jonathan - paste the following formula in master file column b. change Book1 and sheet1 in the formula to secondary workbook name and worksheet name. let me know if this helps
    ...
  6. Replies
    2
    Views
    241

    Re: Combine two Worksheet_Change

    what is the error you are getting
  7. Re: Sorting rows into other sheets by date value

    here is the link the faq you can use the html tag to attach the file. im not sure how that works:confused:. haven't posted a file here before
  8. Re: Sorting rows into other sheets by date value

    Hi Benlindakzn - please upload an example file for this.
  9. Replies
    2
    Views
    157

    Re: VBA developer tool

    :rofl: i was afraid it started and ended with the keyboard. I will look into smart indenter thank you
  10. Replies
    2
    Views
    157

    VBA developer tool

    is there a tool for VBA which would auto close the brackets and auto complete common statement like end if, end select, end with etc...
  11. Replies
    7
    Views
    240

    Re: E- mailing excel

    add it to the same string separated by semicolon
    .To = "email_address1; email_address2; email_address3; email_address4; email_address5"
  12. Re: Excel VBA 429 - ActiveX component can't create object

    spoke with hp found out that the dll wasn't registered and registered it by going to "http://server:port/qcbin/start_a.jsp?common=true" in internet explorer.

    Thanks all
  13. Re: Excel VBA 429 - ActiveX component can't create object

    below is the codeline which is causing the error


    TDC.InitConnectionEx ("http://server:port/qcbin")

    i will check with hp as well.
  14. Replies
    7
    Views
    240

    Re: E- mailing excel

    the code is available at OfficeTalk: Using the Excel Object Model to Send Workbooks and Ranges through E-Mail with Outlook (Part 1 of 2) to use you just need to activate the worksheet you are trying...
  15. Replies
    2
    Views
    21,331

    Re: Custom Format Add Ins or VBA Codes

    what are you trying to achieve?


    Sub numFormat()

    Range("A1").NumberFormat = "##\,##\,##\,##0.00;[<-999999](##\,##\,##0.00);##,##0.00"
    Range("A2").NumberFormat = "#,##0.00"...
  16. Excel VBA 429 - ActiveX component can't create object

    Hi all - I have Excel 32-bit on windows 7 professional 64-bit. I am able to create reference via tool>references to the OTAClient.dll which is provided by quality center 32-bit application but I am...
  17. Replies
    2
    Views
    387

    Re: VBA Excel Custom Function def

    thank you
  18. Replies
    2
    Views
    387

    VBA Excel Custom Function def

    Hi I am working with Ron's file zip VBA code. the code is using following function and i don't understand what it is doing. I am an intermediate VBA user and never have had the pleasure of working...
  19. Replies
    2
    Views
    298

    Re: set range to variable other workbook

    yes it does. I've tried setting the value with activating the workbook and it works fine, however i get an error if the work is not the activeworkbook. is it possible to assign range to variable...
  20. Replies
    2
    Views
    298

    set range to variable other workbook

    Hi i am getting an error setting range to a variable. the workbook with the sub is open but is not the activeworkbook. i am not sure of what i am missing something. following is the code
    Dim...
  21. Replies
    2
    Views
    285

    Re: Error Handler #DIV/0!

    Yes but i have multiple routines in a module and i was wondering if there was a way to enter this on a module level rather then a sub level. something like on error go to errorhandler; errorhandler:...
  22. Replies
    2
    Views
    285

    Error Handler #DIV/0!

    I have a VBA code that loops through a range of cells and inputs a value of a calculation however sometimes the code throws an error DIV/0 is there a way to tell vba that DIV/0 = 0?
  23. Replies
    5
    Views
    513

    Re: Array input parameter

    I also have part of file name as variable - all files to be ziped start with the same file name string. following is the code sniplet
    ' Get the file names
    FileNames =...
  24. Replies
    2
    Views
    392

    Re: weekly data populate on Excel sheet

    have you tried using msquery in excel? can post a sample sheet with the format?
  25. Thread: FTP upload

    by Shahzadt
    Replies
    0
    Views
    213

    FTP upload

    Hi all I have seen numerous examples of how to load a file to FTP site using VBA in Excel. i have tried to understand and use these with no luck:confused:. Is it possible to upload a file to FTP...
Results 1 to 25 of 72
Page 1 of 3 1 2 3