importing data

  1. T

    Need help with VBA Sub routine

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

    Spreadsheet to calendar Excel 2010

    #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...
  3. M

    Trying to match product sku from 2 spreadsheets and if they match can I have the product id pulled from one to the other?

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

    Access Importing Problem

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

    Access Importing Problem

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

    Need Excel macro to open Sharepoint library file and save it to my hard drive as an .xlsx file or import into my workbook

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

    importing data from tabs

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

    Create an alert when attempting to import invalid data

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

    Importing data from a closed workbook

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

    Importing from Web

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

    Word tables to a single Excel spreadsheet

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

    2 macro questions

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

    EXCEL Issue retriving data from SQL

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

    EXCEL Issue retriving data from SQL

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

    Consolidate Workbooks with multiple sheets into existing worksheet

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

    Import external data - web query

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

    Import Text File - CERTAIN COLUMNS ONLY

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

    Comma delimited text file import to Excel failing

    Maybe its late in the day but this one is doing my head in. I have a .txt file Im seeking to import to an Excel worksheet where wierd and wonderful macros will do fascinating things to it. But the actual text import is erroring and my brain has screamed that its after 4pm and then gone to the...
  19. S

    Importing Data

    I created a macro that imports production results from multiple staff folders. Before I had the macro I was manually coping and pasting their results into staff tabs that was auto filling a PivotTable. When I clear the data that was imported the links to the other tabs are lost, they give me the...
  20. S

    Importing Data

    I created a macro that imports production results from multiple staff folders. Before I had the macro I was manually coping and pasting their results into staff tabs that was auto filling a PivotTable. When I clear the data that was imported the links to the other tabs are lost, they give me the...

Some videos you may like

This Week's Hot Topics

Top