import

Hello everyone! I need may be some VBA script or something else to solve my problem) I have many txt files in one folder. Each file contain information like: some text here some text here some text here start to copy some text here some text here some text here end of copy some text here some...

Hello I'm trying to import a text file into a specific sheet, where it should do a Text to columns with the delimiter set as a space. What I would like to do: Clear all data in Sheet "SVKData" File Prompt for a text file, that imports data into "SVKData" the data should just be imported into...

Hello, I have a table I use for sales forecasting, teams fill in the out months and I would like a process to create a table that can be imported into the General Ledger. Above is the import file, the teams would fill this in. EAch month there could be unique Billing Codes, and the billing...

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

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

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

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

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

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

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

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

Hi all, I am trying to collect FInancial data from reuters.com, 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...

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

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

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

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

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

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

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

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