importing data

Hi just checking If anybody can help be with this as I have a long way to go I have a simple VBA code that lets you import data from another workbook into active workbook by using the file open dialog. currently the code just clears the sheet and imports all the data into active workbook. I...

Hi! I'm looking to import data from 2 files into 1 single master file. Both source files will always be in the same directory with the same name files. A simple description would be: - Delete content on master workbook in B1:B_Last row - Copy info from source workbook 1, cells A6:Q_Last row...

Hi I have tried the code below and it almost works flawlessly for my needs to explain a little what I have going on. I have a sheet called "PropertyLocation" consisting of serialized equipment and their current locations. every so often I receive new equipment and I would like to add to...

I have been away form VBA coding for 10 years and am having a problem. I have copied and adapted this subroutine from a google search. It worked 3 days ago, but now is not finding the files in the same folder. I need help in determining why. The part that errors shows a Msgbox with "Run-time...

#1 I have a spreadsheet with dates and events. I would like to create a monthly calendar. Is this possible to do withoout just creating manually. Does not have to be an Excel claendar- Word calendar template, PowerPoint, Publisher- any Microsoft Office 2010 program. #2 I also want to import...

Hey Everyone, this is my very first thread here please excuse any novice actions I may make while posting this, thanks. I have about a dozen spreadsheets (we'll call these the "Dirty Dozen") that all have product Sku's in column A and have a column for Product ID's in column B but no actual...

Hi Guys, I made a Database already, I need to make a button in Access, Whenever i will press that button it will pop up the to select the files to import and then directly import it. IF thats not poossible then whenever i press the button it will check the folder if i found any new file it...

Hi Guys, I am trying to Import the the files from Excel, but when i am appending the second file its not showing the records or data in sheet. Any Idea whats wrong? Thanks

Hi! I'm stuck on this one and have been trying to figure it out all day, with no luck. I'm pretty new to VBA and macros so what is easy to a lot is quite the challenge for me. I have a workbook that I need to put some code into that will go to a specific sheet then open up a SharePoint document...

Hello all, This my my first time using a forum like this so bear with me please. I'm working on a spread sheet to track inventories and sales. I'd like to auto populate new tabls with information from exsisting tabs, ie. product names, formulas and final inventory figures. Is there an easys way...

My code imports stock historical data. Help would be appreciated in creating a way for a user know that they chose an invalid date when trying to import stock information from the internet. In cases where a user inputs a date before the stock existed, the current code returns blank fields. It'd...

Hi all, I am trying to import a number of cells (G48:67) from a closed workbook using a macro button. The tricky part is that some of the file name will change every month-ish, and I want to see if I can have the macro adjust for the name change every time. Also the closed worksheet have a...

I am looking to automatically import a file into excel from the web with the click of a button. I know how to do this with .txt files, etc. but I am wondering if I can do the same with a .xls file?? Here is an exact table that I am looking to import. http://www.census.gov/const/www/c30index.html...

All, I am trying to import table(s) from word documents to a single excel spreadsheet. The word files contain a varying number of tables. I tried it myself and long story short, couldn't do it. I then searched on the web and found this web site and the macro below. The macro below orginally put...

Hello to all, I'm new to the usage of excel and I have 2 questions for anyone who is kind enough to anwser them and pls give me an example for solving my problem. 1. How can I count the number of sheet in one file? 2. How can I import data from other excel files? PS. Could anyone suggest a...

Hello ppl, The first thing of all i apologize myself for my bad English. Ok, a little bit of history, i write a VBA macro for EXCEL that retrieves information from an SP in SQL Server 2K, and is not the first macro that i write, i have already writed a lot of this macros but this is the first...

Hello ppl, The first thing of all i apologize myself for my bad English. Ok, a little bit of history, i write a VBA macro for EXCEL that retrieves information from an SP in SQL Server 2K, and is not the first macro that i write, i have already writed a lot of this macros but this is the first...

Hello all, Thank you in advance for your help. What I am trying to accomplish is, I have 6 workbooks with multiple sheets each all in the same folder as the destination workbook. I have been scouring the boards trying to find a macro that I can assign to a command button that will import the...

I'm trying to create an "Abroad Expense Report" form, and I would like to get the exchange rate from web site. I would like to put a date in a cell and to get the right exchange rate. Herewith the link to get it. in this example the date is 20030505...

Hi all, Importing text files into excel is farely simple having googled round the topic. The text file i'm importing is awfully big though, so I wondered if I could just read in the columns I need to speed things up. (I could import the whole thing then delete the columns I don't want after...