importing

Hi I am a beginner with vba and I am stuck in trying to import another excel workbook with its location being flexible as the file-name will change. This is what i got so far Dim selectFile As String selectFile = Application.GetOpenFilename(FileFilter:="Excel Files, *.xls*" _ ...

Hello, My organization moves data between 2 different applications by exporting and importing csv files. I'll call the programs app1 and app2. app2 has an import file template that we use to match the fields from app1's export file. So I've been manually copying the columns from the export...

Hello Everyone!!! Is their a possible way to link exported XL data to a website & then import updated changes on the same webpage back to XL??? :confused::confused::confused:

Hello and thank you for your expertise. Here is my situation. I have approx. 500 text files all residing in one folder. This folder only contains text files. Each text file has approx. 100 rows of data, tab delimited. I would like to import every row from each file into one sheet in...

Excel 2003 Hi, I've mixed and matched some code to import file names into Excel. I can get the importing bit to work but there's one line of code that I get a runtime 1004 error. I've underlined the piece of code it gets stuck on which appears fine as I got it by recording a Macro...

Hi folks-- Just wondering if there is any way that I can use data from an Access table in my Excel functions without importing the Access data into the wookbook. I set up a connection to the Access table that I need, but don't know what the syntax would be to reference those fields in...

Hi, I am inputting alot of raw data from the field and Excel programming of this sort isn't my strong suit. Basically I have Seven Columns, Column "A, B,C, E" are the one i need to sort, column A is a type of configuration FFC-0###, where the number signs correspond to different locations, the...

Hello, I wish to import the Metatrader 4 "BULL" indicator data, (one live changing number) into an Excel cell. Then, I can use this cell to make normal/easy calculations. I have some knowledge in Excell, but kindly request step by step instructions. Another alternative is to leave your...

Hello, I've used it as a resource as much as I could, but I've hit a wall. I was hoping someone can point me in the right direction. I've found one solution so far, but I know there has to be a better one. I need to import a CSV file which is generated from this address: Example...