in
All Tags » VBA » copy (RSS)

Browse by Tags

  • Access VBA, Excel, Copy Recordset, Column Headings

    I have a recordset that I copy into an excel file. Is it possible when I copy the recordset that I can also copy the column names from tbl_Quote_Equipment into the excel file? strSQL = "Select * from tbl_Quote_Equipment where QuoteNo = '" & Me.txtQuoteNo & "';" Set...
    Posted to Access (Forum) by microsoft on 12-06-2009

  • Copy MS Access Table into a VBA Array

    I am trying to read an entire MS Access table in to a VBA array. What is the best way to do this?
    Posted to Access (Forum) by microsoft on 09-08-2009

  • Copy Word Table via VBA

    I a class module I need to copy a table to paste it later to a PowerPoint slide. but the .copy method pops an error with err4605 'no text selected'. Hm, but the table is selected. I don't understand it. If I manually execute row 5 again after the error occurs in row 7, the code is doing what...
    Posted to Word (Forum) by microsoft on 09-06-2009

  • VBA - Open multiple workbooks and copy sheet to new workbook

    Hey all, I have been assigned a new project that will require a little VBA, and my VBA skills are very elementary. I have 100 files (Book1.xls through Book100.xls) All files reside in C:\Temp I need to open each workbook, copy Sheet1, paste to next available Sheet# in Summary.xls, close the workbook...
    Posted to Excel (Forum) by microsoft on 08-20-2009

  • Excel, VBA: (Loop) Copy a cell from one sheet if a criteria  is met to another sheet

    Excel, VBA: I have in fact three challenges: 1) I wish to copy a cell from one sheet to another if a criteria (set out in a different cell) is met. In sheet 1 column C:C lists the criteria 1 for the fields I wish to use, and "" for the ones I do not need. If C1=1 I wish A1 to be copied and...
    Posted to Excel (Forum) by microsoft on 08-17-2009

  • VBA to copy down formula to last row with data

    Hi Experts I am using the macro below to format and juggle a sheet including merging 2 cells into 1 on each row. However, the sheet I am using has x amount of rows and I need to carry out this macro on other sheets with varying amount of rows. Rather than referencing a set number of rows to autofill...
    Posted to Excel (Forum) by microsoft on 08-15-2009

  • Copy to clipboard message bypass in VBA code

    Team, I have currently built a report for senior management by which information from Excels workbook is copied to MS Office using VBA. The whole report works except for this ridiculous milestone which I can not get rid of. I am constantly given a message box which states "There is a large amount...
    Posted to Excel (Forum) by microsoft on 08-14-2009

  • VBA: Open multiple, uniquely-named workbooks and copy sheet to new workbook

    Hello - I was looking through some solutions to try to adapt to my situation. This code (which works really well) was written to open similarly named workbooks ("Book1, Book2, etc.) and copy the same sheet from all of them. I'm hoping to modify in the following ways: 1) Instead of copying "Sheet1"...
    Posted to Excel (Forum) by microsoft on 08-14-2009

  • VBA Code to copy to new record from recordset

    I have a recordset that I need to create a new record and copy the data from the recordset into the new record(s) - with new id and Job #. Note: that the recordsource is also the table I want to update. I don't see a copy option for rs.addnew, rs.copy? Dim rs As Recordset Dim strSQL As String strSQL...
    Posted to Access (Forum) by microsoft on 08-12-2009

  • VBA to copy row contents from one sheet to another

    I'm currently using the following VBA code to copy rows from one worksheet to another, when a certain selection is made in a certain cell. ----- Private Sub Worksheet_Change(ByVal Target As Range) If Left(Target.AddressLocal(ColumnAbsolute:=False), 1) = "C" Then InsPos = Sheets("Booked"...
    Posted to Excel (Forum) by microsoft on 07-20-2009
Page 1 of 3 (26 items) 1 2 3 Next >