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 strongm 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. robin786

    Copy from one Excel Workbook to another Excel Workbook with VBA

    I am using Excel 2010. I have an Excel workbook which has about 10 worksheets. Each work sheet has a lot of data. There are a lot of cells and a lot of tables.. I also have another Workbook which has the same 10 excel work sheets in it. However, all the fields in each worksheet are not in...
  2. robin786

    Copy from one Excel Workbook to another Excel Workbook

    I am using Excel 2010. I have an Excel workbook which has about 10 worksheets. Each work sheet has a lot of data. There are a lot of cells and a lot of tables.. I also have another Workbook which has the same 10 excel work sheets in it. However, all the fields in each worksheet are not in...
  3. robin786

    Convert Excel Rows in Columns

    I am using Excel 2007. I have monthly sales data for various countries displayed in Rows as follows. Sales are in column C. Country is in Column A USA January 10 Canada January 20 UK January 30 Italy January 40 USA February 100 Canada February 200 UK February...
  4. robin786

    Transfer Partial Excel Data into XML and viceversa

    Dim objDom As DOMDocument Dim objXMLRootelement As IXMLDOMElement Dim objXMLelement As IXMLDOMElement Dim objXMLattr As IXMLDOMAttribute Set objDom = New DOMDocument Dim i As Integer Dim j As Integer Dim str As String '~~> Creates root element Set...
  5. robin786

    Transfer Partial Excel Data into XML and viceversa

    I am using Excel 2007. I have an Excel Sheet "Sheet1" in the workbook "Employee.xlsx". It has about 20 columns and the number of rows varies. I wish to transfer only the first 10 columns ( all the rows included ) into an XML file ( "C:\Employee.xml" ). The first row in Excel Sheet has title...

Part and Inventory Search

Back
Top