Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. primagic

    Find out who has file checked out on Sharepoint

    Yes I know. That is my question. Can we find out who checked out the file? What is the syntax?
  2. primagic

    Find out who has file checked out on Sharepoint

    If Workbooks.CanCheckOut(xlFile) = True Then Workbooks.CheckOut xlFile '...code here does stuff 'Save Workbook ActiveWorkbook.Save 'Check In Workbook back to sharepoint ActiveWorkbook.CheckIn Else MsgBox ("The file is currently in use. You are unable to check out this document at this time...
  3. primagic

    Find out who has file checked out on Sharepoint

    I have the code which checks if the file has been checked out on Sharepoint. Is there anyway of finding out who has the file checked out using VBA (Excel). Thanks
  4. primagic

    Trying to copy data from one workbook to another in VBA

    Got it working. Thank you.
  5. primagic

    Trying to copy data from one workbook to another in VBA

    How do I do this between seperate workbooks? At the moment the code does the copy, opens the new workbook, sets where to paste but doesn't paste. The paste range in the new workbook is alway dynamic by selecting the next available cell So I cant set a fixed range of the new workbook to paste.
  6. primagic

    Trying to copy data from one workbook to another in VBA

    I have the following code so far. From one workbook, I have it opening another workbook from sharepoint. this works fine. I am trying to copy data from the original workbook into the opened sharepoint file, however I am getting the error 'PasteSpecial method of Range class failed' on the line...
  7. primagic

    Find last column and copy formulas

    All my content will be stored in the following range: Range("S5:AD49") I have the following code which takes the formulas from the first column and paste them into the next column, then copies the values in the first column and pastes over themselves. Range("S5:S49").Select Selection.Copy...
  8. primagic

    Copy specific sheets to a new workbook

    I have the following code which works perfectly copying all sheets in current workbook to a new workbook. How do I modify so I can choose specific sheets not to copy. Can I use a range with sheetnames? Sub CreateUKPBFile() 'Change segment selection to UKPB Range("D3").Value = "UKPB" Dim...
  9. primagic

    Query Help

    Would it? I thought if the beginvaldate was 31/10/2014 and the months accrued was say 3, then it would only select records the previous 3 months records up until the 31/10/2014. How/why would it select more than 3 months?
  10. primagic

    Query Help

    I managed to get it working by using the following sql code: SELECT tblBeginEndVals.Sedol, CLng([ParentID]) AS PID, tblIssuerParentMap.ParentID, tblStocks.IssuerName, tblStocks.Description, tblBeginEndVals.ClientCode, tblBeginEndVals.ProductCode, tblBeginEndVals.BeginValDate AS TestDate...
  11. primagic

    Query Help

    When I add AND tblBeginEndVals.BeginValDate>DateAdd("m",-qryAccruals.MonthsAccrued,Date() this to the criteria, I get datatype mismatch error
  12. primagic

    Query Help

    Here is the SQL for the query: SELECT tblBeginEndVals.Sedol, CLng([ParentID]) AS PID, tblIssuerParentMap.ParentID, tblStocks.IssuerName, tblStocks.Description, tblBeginEndVals.ClientCode, tblBeginEndVals.ProductCode, tblBeginEndVals.BeginValDate, tblBeginEndVals.YYYYMM...
  13. primagic

    Query Help

    I have a query which retrieves a year's worth of data. In one of the fields I have a number which specifies how many month's a client has accrued. So Client A may have accrued the last 3 months. So I only want to retrieve the last 3 months for him. Client B may have accrued the last 6 months...
  14. primagic

    'Dropdown list' has a SelectedValue which is invalid because it does not exist in the list of items

    Both options work in the fact the error dissappears however jbenseon your code doesnt pull through the value stored in the database if there is a value. any ideas?
  15. primagic

    'Dropdown list' has a SelectedValue which is invalid because it does not exist in the list of items

    I have a range of textboxes and dropdown lists on my page. On the load event I am populating to these controls with a record from a table in the database. I have a field called AgeRange. I want to display the value in the field as the selected item of a dropdownlist. Then they can change if...
  16. primagic

    Sumif across rows and columns

    =SUMPRODUCT(('[bmi_excel_layer_June_Final_v3.xlsm]Main - Partnerships'!D6:D5000="UKPB")*INDEX('[bmi_excel_layer_June_Final_v3.xlsm]Main - Partnerships'!JR6:KC5000,0,1):INDEX('[bmi_excel_layer_June_Final_v3.xlsm]Main - Partnerships'!JR6:KC5000,0,1)) This works...
  17. primagic

    Sumif across rows and columns

    I managed to get it working, however it works when the column number of the second index statement is 1. If I choose 2, 3 or any other number I get VALUE error. Is this something to do with the data in column 2?
  18. primagic

    Sumif across rows and columns

    I am trying to sum across rows and columns Section Jan 13 Feb 13 Mar 14 A 10 10 10 A 10 10 10 B 5 5 5 What I am trying to do is sum everying up until today for each section
  19. primagic

    Reading XML file to SQL Server

    I have the following code which is importing data from XML fine but only for the parent node. Dim Mapping1 As New SqlBulkCopyColumnMapping("submission-reference", "SubmissionRef") Dim Mapping2 As New SqlBulkCopyColumnMapping("created-at", "DateCreated") Dim Mapping3 As New...
  20. primagic

    Index was out of range. Must be non-negative and less than the size of the collection. Parameter nam

    Getting the error Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Here is my code: Protected Sub gvHosts_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) If e.CommandName =...

Part and Inventory Search

Back
Top