1. G

    Need help with automatic importing of Data every x minute

    Hi all, I currently have an automatic code that can open up the MOST recent (date modified) file in a folder. It works great BUT my concern is: Lets say i set a timer of 10 mins to execute this macro, However the macro takes 15 mins to run and inside that space of 15 mins another 2 files are...
  2. N

    Combine data from ALL worksheets in different workbook

    Hello, I've been working on a new template and excel sheet for the quality inspection of fresh carrots we receive. Everytime we receive a load, we work on a Excel sheet to fill in our quality inspection. So every load has its own sheet based on a template in the same workbook. The name of the...
  3. J

    Need to import 4 sheets from 50+ workbooks into a summary sheet

    Apologies if I'm not explaining this well; I'm a novice at VBA. I need 4 sheets to be extracted from 50 workbooks and copied into a summary. The VBA needs to work in the background. Can anyone help. I wore this code but it's clunk and doesn't repeat. Sub CopySheetFromClosedWB()...
  4. S

    How to Import or link CSV with more than 255 columns in ACCESS?

    Hello, I have a .csv with more than 255 columns (395 exactly), I only need 3 columns but I cannot manipulate the source file manually, that is, I cannot divide it in two. The columns are: 131, 208 and 282 I have tried to do it by wizard but Access won't let me do it because it has more than...
  5. S

    Cómo Importar o vincular CSV con más de 255 columnas en ACCESS ?

    Hola, tengo un .csv con más de 255 columnas (395 exactamente), únicamente necesito 3 columnas pero no puedo manipular el archivo de origen manualmente, es decir, no puedo dividirlo en dos. Las columnas son: 131, 208 y 282 He intentado hacerlo por el asistente pero Access no me permite hacerlo...
  6. T

    format data

    Hello I am having a problem formatting data in excel, I am preparing this data to import into a database that i have created. the problem is as follows: the raw data i have is for multiple chocolate recipe's that are broken down into the following: Name of recipe weight of ingredients unit of...
  7. S

    Import WhatsApp messages into excel in real time

    Hi everyone, I have been recently asked if it is possible to import messages from WhatsApp to excel in real-time. This person runs a catering business and receives orders via WhatsApp but as you can guess there is no specific format in which his customers send the order messages and his order...
  8. D

    Tableau .csv Url VBA Import

    Hello, With the Web Based Tableau tool, you can download the .csv version of data via replacing the end of the url with .csv then anytime this URL is entered, the file downloads. I am looking to integrate this data into a refreshable vba import that does not require manually downloading the...
  9. D

    Get External Data from Web issue

    Hi all, I am trying to collect FInancial data from, using Data - Get External data - From Web, where I simply paste, for example, this link AAPL.OQ - Apple Inc. Financials | Reuters and click Import. However, when I get the data in Excel, I see everything except for the table...
  10. G

    Edit imported worksheets

    I have this workbook that imports worksheets and needs to delete Column "F" in each sheet that was imported, without editing any other worksheet in the workbook. The current VBA is below. Thank you in advance for the help. Sub Import() Loop Dim fnameList, fnameCurFile As Variant Dim...
  11. S

    Importing Multiple Workbooks that have multiple worksheets

    I’m trying to import a specific worksheet that appears in multiple (40) workbooks. I’m not fussed on how the worksheets are ordered in the new work book. The following code works but tried to pull all the worksheets and falls over when it finds hidden worksheets. As said I only want one...
  12. M

    Auto-Import XLS or XLSB workbooks with multiple sheets and append data to tables. (Access Tables and Excel Sheets = same name)

    Dear MS Access Community! I am actually quite new to this forum (a few months) and very new to MS Access (1 month or so). Earlier this week, I was having trouble with Excel, and now I'm having trouble importing data into my MS Access Tables. Please allow me to explain: Structure and...
  13. R

    Unable to automatically pull data and perform custom modifications to a table from a query whose source is a dynamically changing link

    Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead of manually typing out the inputs into the link, putting it into power query, performing transformations, and...
  14. P

    Stuck, Need Help (please). Trying to export unstructured text from PDF to import into Excel separating/placing text into specific columns

    Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...
  15. X

    Need help with "pastevalue" function

    Hi, Need help with VBA Code. I've searched online and tried a few codes but have been having trouble finding something that works. What I want to do is to insert "pastevalue" function in the below bold parts ( in order to import data with formulas in value from external files)...
  16. D

    Import to Power Pivot..

    Hello, I'm exploring Power Pivot (Power Query, BI) opportunities. I have some 24+ workbooks with IDENTICAL data structure in data sheet and 100K+ rows each. I use a pivot in each workbook. My goal is to have one "power pivot" with all the data (+ additional small reference tables) so I can work...
  17. F

    Importing Lines from a Text File Which Meet Certain Criteria using VBA

    Hi all, Looking to get some expert help as i'm a novice with VBA. I've currently tried searching online and i can't seem to find a macro that can help with what i am trying to do. Essentially i have large data files with more then 1.6 million lines of data. I currently have a macro which...
  18. S

    How to import Excel columns into Python (Word2Vec text processing)?

    I want to import ,say, D column from .xls (not csv) file, data is range, not table. How to do that ? I found how to import named column, but not basic
  19. C

    Macro to inport games and scores from website

    Hello. I need help designing a macro. I have no clue how to do it, never done a macro yet. I want to import into an excel file, the games and the scores from a web site (ie. Live Football Scores, Livescore ). I want to assign this macro to a button, so I can refrash the data...
  20. B

    Import SharePoint Excel Files

    Does anyone know of a way to import excel files directly from a SharePoint into access

Watch MrExcel Video

This Week's Hot Topics

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