import data vba

  1. E

    import data- query

    hey guys: i was trying to import data from internet to an excel spreadsheet by using the command query. With Sheets(1).QueryTables.Add(Connection:="URL;" & miurl, Destination:=Sheets(1).Range("a1")) .BackgroundQuery = True .TablesOnlyFromHTML = False...
    • ercanu
    • Thread
    • error import data import data vba query url
    • Replies: 0
    • Forum: Excel Questions
  2. B

    importing multiple data files with file name in cell and as sheet name

    I have about 100 tab-delimited data files. All are the same number of columns, but different lengths (rows). All are in one directory (call it C:data). The file name is the date and time (140914-074512.dat). I would like to import them to a single Excel workbook, each file on a different...
    • bcarlton
    • Thread
    • filename as sheet name import data vba summary sheet
    • Replies: 3
    • Forum: Excel Questions
  3. H

    Import text from a text file between 2 sentences

    Hello, I want to import certain text from a text file which is between 2 sentences. Sample text:- ****Begin: 8.3 Naming Convention Path: HKLM\system\currentcontrolset\control\filesystem\ntfsdisable8dot3namecreation Value: 0 Interpretation: 8.3 Naming Convention enabled ****End: 8.3 Naming...
    • hunk_1990
    • Thread
    • import import data text import data vba import selected data vba
    • Replies: 0
    • Forum: Excel Questions
  4. F

    VBA/makro; import all files within a directory in excel

    I am new to this forum. I hope someone can help me: I want to write a VBA or makro to establish the following: I've got a directory 'xxx' with a number of files in it I want to import those in excel (I chose within other for .xml, but than have to change it to all files) the columns are...
  5. R

    Import data in generic range

    I have a code that will import data files to some cells i specified. i need it to count the rows to the end of populated cells and place the new data in the nex blank cell. Here is the code: Sub Macro1() , Destination:=Range("$B$11130")) .Name = strFilename .FieldNames...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top