• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    VBA to summerize the workbook sheets data in a required structure

    Hi All, Please check the attached workbook at this link. http://speedy.sh/mYzPk/SampleTest.xlsx It contains how the data existed in different sheets which i need to summarize in a separate sheet. I have prepared the data structure how i required manually in the sheet "FinalResult" for...
  2. R

    How to find all the previous months from the current month ?

    Hi All, I am able to find out the current month and previous month by using this code and it is fine. Dim CurrMonth, PrevMonth, ws As Worksheet, x CurrMonth = Format$(Date, "mmm") PrevMonth = Format$(Date - Day(Date), "mmm") For Each ws In Sheets If ws.Name Like CurrMonth...
  3. R

    How to do Error handling for a sample Excel vba code?

    Hi All, Can anyone help me how to do error handling with a sample code? Thanks in advance. Regards Kumar
  4. R

    How to insert null as a value for the sql table DateTime column from excel?

    Hi All, i am able to insert the values from excel sheet columns data to the corresponding columns of an sql table. But the problem is in my execl sheet i have some date columns.In those some rows are having data(date) and some rows are empty. Now when i am sending these data to a...
  5. R

    How to find the Current month and Previous month?

    Hi, if the workbook sheet names are like this "Jan '12"....."Jun '12","Jul '12"..etc I am using this code to find out the current month and previous month sheets in my workbook sub test() Dim CurrMonth As String, PrevMonth As String CurrMonth = Format$(Date, "mmm 'yy") PrevMonth...
  6. R

    Syntax Problem

    HI, This is the query i am using to update the records. But when i am executing,getting sql syntax error. Please correct the syntax of the query. sSQL = "UPDATE TblTest " & _ "set [Month] = '" & SplitMonth & "' , [Year] = '" & SplitYear & "' ...
  7. R

    How to catch the result in a variable?

    Hi All, I want to catch the ID comming from the sqlTable like this but i am not succeeded ~ ColA = shtSheetToWork.Cells(lRow, 1) ColB = shtSheetToWork.Cells(lRow, 2) SplitMonth="Jun" SplitYear="2012" SQLSelect = "select ID from Test where Country= ' " & ColA & " ' and Name=' " & ColB &...
  8. R

    SQL Select,Insert,Update queries from Excel vba?

    Hi All, I am having an excel workbook with some sheets.From that i am able to read the current month and previous month sheets data and inserting those columns data into sql table. But to avoid insertion of same data all the time, I just want to check a condition like if particular columns...
  9. R

    How to access and edit the same workbook by multiple users simultaneously?

    Hi All, Is it possible to access the same workbook and made changes(Like passing the cell values from other workbook) for multiple users of the same network simultaneously. Here is the problem. I have 2 workbooks say "first.xlsm" and "second.xlsx". from the "first.xlsm", i am passing the...
  10. R

    How to open the same source workbook from which the target workbook open from?

    Hi All, I have several source workbooks and only one target workbook. I can redirect to target from any of the source. Now the problem is, How can i go back to the same source from the target.(target opened from which source dynamically control from target). Hope you understand the...
  11. R

    How can i save and close the first workbook after opening second workbook from i

    Hi All, How can i do like this. I am opening second workbook from the first workbook at that time how can i save and close the first workbook. So, that one workbook should open at a time. This is how i tried but not succeeded. Application.Workbooks.Open ("E:Second_Data.xlsx")...
Back
Top