Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    8,092

    Re: How Add Values to Sharepoint list

    Please check last section of below page:

    http://flylib.com/books/en/3.464.1.67/1/

    Code to import list from SharePoint:


    Sub ImportListFromSP()

    Dim ws As Worksheet
  2. Replies
    2
    Views
    203

    Get table headings using Formula

    Dear All


    I have data like:


    Headings-----------Col1-----Col2------Col3------Col4
    Col1, Col4-----------5000--------0----------0------2000...
  3. Replies
    2
    Views
    3,011

    Re: Custom Task Pane

    Thanks for your reply Robert...
  4. Replies
    11
    Views
    745

    Re: simple problem

    I think this should work.
    No need to change the formula for all the the cells in B column.
    This formula returns the value of Row Number -1, so you can just copy it anywhere it will return the same...
  5. Replies
    4
    Views
    354

    Re: Concatenate the cell strings

    Thanks lot for your replies...
  6. Replies
    4
    Views
    354

    Concatenate the cell strings

    Hi All,

    I have below input data in my Excel Sheet:


    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt;...
  7. Replies
    2
    Views
    38,653

    Re: Run Powershell script from VBA

    Thanks Andrew Sir,

    It's working perfectly...:)
  8. Replies
    2
    Views
    38,653

    Run Powershell script from VBA

    Hi All,

    Can we run powershell script from VBA Excel?
    If yes then how?
  9. Replies
    0
    Views
    1,729

    PostMessage/SenMessage method of API

    Hi All,

    I want to send Save message to File Download dialog box.
    Can we send API message to DialogBox window(Class - #32770) from VBA Excel? How?

    Please help me if you know something.

    This...
  10. Replies
    4
    Views
    228

    Re: Access Print Log

    Thanks for the reply..

    Yes we can access the log files but I don't know where I can find the log files for printer.

    If it is not possible to access the file from client computer then can I...
  11. Replies
    4
    Views
    228

    Access Print Log

    Hi All,

    Can we access the print log of computer using VBA Excel?
  12. Replies
    0
    Views
    213

    Web page counter

    Hi All,

    Is there any method or code in VBA which will give me the total number of webpages in a particular website?

    May be kind of sitemap etc.
  13. Re: Macro that inserts formula =problem

    I think here is the problem:

    =IF(COUNTIF(SortEkal!$D:$D;$D8)=1,VLOOKUP($D12;SortEkal!$D:$F;3);0)


    it should be (replace Semicolon with comma):
    ...
  14. Replies
    2
    Views
    3,011

    Custom Task Pane

    Hi All,

    Can we create custom task pane using VBA or xml (Custom User Interface Editor)?
    Without VSTO.
  15. Replies
    4
    Views
    317

    Re: Copy data between workbooks

    If you are getting this message:

    "Target workbook not found as - c:\myworkbook2.xlsx"

    Means the target file where you want to paste the data, not at the c drive with name - myworkbook2.xlsx.
  16. Replies
    8
    Views
    640

    Re: How can we do a vlookup in VBA?

    Now try this:


    ThisWorkbook.Sheets(strInputSheet).Cells(intRow, intCol + 3).Value = WorksheetFunction.VLookup(ThisWorkbook.Sheets("2a").Cells(intRow, intCol).Value,...
  17. Replies
    8
    Views
    640

    Re: How can we do a vlookup in VBA?

    Is that workbook open where you want to lookup the data (Macro-Flatten Data 2v2.xlsm)?

    What is the exact data range? ( This - $R$1000$C$4 is invalid)
  18. Replies
    3
    Views
    251

    Re: VBA Syntax help

    With Intersect(Sheets("Sheet1").UsedRange, Sheets("Sheet1").Rows("6:" & Rows.Count))

    OR


    Dim ws As Worksheet

    Set ws = Sheets("Sheet1")

    With Intersect(ws.UsedRange, ws.Rows("6:" &...
  19. Replies
    8
    Views
    640

    Re: How can we do a vlookup in VBA?

    It should be something like this:


    ThisWorkbook.Sheets(strInputSheet).Cells(intRow, intCol + 3).Value = WorksheetFunction.VLookup(ThisWorkbook.Sheets("2a").Cells(intRow, intCol).Value,...
  20. Re: SumIf for multiple criteria with text string

    Try Sumifs:


    =SUMIFS(C1:C6,A1:A6,"car",B1:B6,"*blue*")
  21. Replies
    4
    Views
    317

    Re: Copy data between workbooks

    Try This:



    Sub test()

    Dim wbSource As Workbook
    Dim wbTarget As Workbook

    Dim wsSource As Worksheet
  22. Replies
    0
    Views
    887

    How can I get the VBA Projects?

    Hi All,

    I am from India. I have four Years of experience in VBA development.
    Currently working as Sr. Application developer with a Financial Firm.
    How can I make money with the knowledge of my...
  23. Replies
    4
    Views
    375

    Re: Script picks wrong cell

    I think like this:



    Sub Sortme()

    Dim R As Range
    Dim Cell As Range
    Dim Lastrow As Long
    Dim S As String
  24. Replies
    1
    Views
    568

    Re: Web Interface to Excel

    What exactly you want to do with webpage?

    Explain step by step.

    Check this link, may be you will get some idea - http://www.mrexcel.com/forum/showthread.php?p=2384398#post2384398
  25. Replies
    1
    Views
    241

    Re: Web access

    Data -> Connections -> Refresh All

    Short Cut Key - Ctrl + Alt + F5
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4