import data

Greetings, I would like help creating a document to harvest information (metadata) from digital images (jpegs and others) from within specific folders. Specifically, I want columns with Filename - Keywords - Title - Date Modified - Description. I appreciate any help you can provide. I am using...

Hi guys Anyone see a more memory-efficient way of running this code? It's importing from Excel to Project resources. The Loop goes through 800 excel rows, same for the 'For' which goes through 800 resources. Despite having calculation set to manual and screenupdating off, this takes nearly 2...

Hi Guys, I currently have the following macro which works a treat however I wanted to add to it and Im not sure where to start. Sub Consolidate() 'Open all Excel files in a specific folder and import data as separate sheets 'JBeaucaire (7/6/2009) (2007 compatible) Dim strFileName As...

Hi all, I'm running the following subroutine within an excel module to import a table from an access database into the worksheet named Summary starting from row A3. The nice thing about this code is that it allows me to import starting from any row I designate. The one thing that I can NOT...

Hi all, I have a number of workbooks that are in the same map. These workbooks consist of one workmap only. All of these workmaps have the same layout. In it are production data for monitoring the quality of several production processess (one workbook per proces). The first two rows have the...

hi, I am new at VBA coding. Can anyone help with a standard code to import certain ranges from a closed(or opened) workbook to a specific range in a new master sheet (open workbook). thanks for your time Nrn

Hello all. I'm the new official noooob :) Any idea of how to retreive information from a page using excel macros? The connection is done via SSL with login and pasword. The url is something like: http://..........&NQUSER=xxx&NQPASSWORD=XXX I'd need to import for each of 18 different url's 9...

What you are looking at is a excel file i created from the import new data wizard. Now my report has a header which you can see at the top is all cut up because of my columns. Less importantly within the report you can also see "r This Colo r" and "r This Styl e" it is suppose to say Total For...

What you are looking at is a excel file i created from the import new data wizard. Now my report has a header which you can see at the top is all cut up because of my columns. Less importantly within the report you can also see "r This Colo r" and "r This Styl e" it is suppose to say Total For...

Hi, I've used this site to find solutions to problems before but I can't find a relevatn thread so I'm trying a posting myself. I have 250 Input spreadsheets and one calcualtion spreadsheet. I want to take a set of data from each input spreadsheet, run it through the calcaultion sheet and...

I am doing a mail merge file in Word 2003 that imports from an Excel spreadsheet. The issue I am having is that it is not importing the data in certain columns from the spreadsheet into the Word document. When I bring up the Mail Merge Recipients List in word, and scroll through the data...

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

I have 240 text files (dxdiag reports from 240 different computers) that I would like to put into an excel spreadsheet. I do not need all of the file but would like to have about nine different lines from the file placed in cells with one row representing each file (computer). Is this possible...

I’ve seen this question asked several time, but I have yet to find a solution that fits my needs. I have an Access database containing several tables with over 300,000 rows each. This database is nothing more than a place to store raw data. Within Excel I have gone through the process of...