Hi... need help sooon!
I am trying to copy the text file which is embedded in my excel, and trying to paste it in a folder using the below code.
ActiveSheet.OLEObjects(1).Copy
CreateObject("Shell.Application") _
.Namespace(ActiveWorkbook.Path & "\") _
.Self.InvokeVerb "Paste"
It is working...
Hello,
I need to set up a power query so that it for each Text file that is in a folder the top 8 and bottom 4 rows are deleted when imported.
Is this possible and if so how do I do it?
Hello all!
I am working on a macro that will pull specific data from a text file and put it into a spreadsheet. It has to be user friendly because after it is completed, I will not be the one who is using it.
I have looked on many sites and came up with this code to make it pick out the first...
Hi There! I wanted to parse a text file searching for text "$$$$$" and append some come content at the end og the line where the text is found.
example:
input file:
Hi there! you read this msg
$$$$$ 1234,2345
output file:
Hi there! you read this msg
$$$$$ 1234,2345,6479
Added 6479...
I have an Excel file that I need to convert to a fixed width, space delimited text file, however when I tried converting to a .prn file it is wrapping the columns that exceed 240 characters per line.
It has to text file with padded spaces or fixed width columns.
What other format can I use...
Hi there,
I've an Excel Workbook (SAP Upload File) that has an Export Button, on clicking it I want to ave a copy of that active worksheet to the user's desktop. After running the below code it is showing a compile error 'Expected End with'.
If someone could check this out would be awesome...
We use a third part data system to export data into a csv file. We then import it into a MS Access database. However, the size of the Access database seems much larger than it should be compared to the amount of data imported into it. Is it possible that there could be data imbedded in a text...
Help! I am trying to create a macro from my excel file that will create a brand new textfile on a desktop. Within the file there are date fields that will need to be converted to MMDDYY format. I am a very beginning level macro user and am not well versed in Visual Basic. I appreciate your...
This is probably quite a broad question but any help whatsoever would be much appreciated!
I've been looking around online and believe this can be done... but I can't figure out how.
I would like VBA for Excel to run a code which uses microsoft SQL to query a text file. I'll give a simple...
Hi all
I have a rather large (many calculated columns and relationships setup) table in powerpivot that uses an Excel file on my hard drive as the source. I now want to use a text file as the source and am struggling to change the relationship. I've tried editing the connection but the wizard...
I'm just starting to dabble with VBA and may be in over my head as I really haven't programmed in a decade.
I have already written a macro that allows a user to point to a text file and bring it excel. These text files are the output of a modeling program we use at my workplace. What comes in...
Hello all,
I have a text file which is created daily and placed in the same folder each day. The file path of the text file never changes. For now, let's say the path is : "\\MyPath\test.csv\"
I want to create a report in MS Excel 2010 where the user can press a button, the text file is...
Hi All,
I am looking for a macro which will save out the DATA RANGE as a '.txt' file and for the filepath to be a msgbox pop-up for the user to browse and pick the correct folder to choose where the new '.txt' file should be saved. The new '.txt' filename can be "test".
DATA RANGE: starts in...
Hi guys!
I am working on an application where a text file is opened then some lines are deleted based on a criteria.
I am using the following code to read the text per line:
If FileName(root_loc, period, wsc_code) = "" Then
MsgBox "There is no e-file found for the period M" & period & "."...
Hi,
My instrument spits out two text files of raw data. The analysis I need to perform is depended on which of the two files I'm looking at. The text files have the same filename however the 2nd file has (1) at the end. I can loop through half the files using
sFile = Dir(sPath &...
Hi all,
A few days ago I was trying to edit one of the tables that I created in the Power Pivot model by going to the design tab, clicking on table properties, and then clicking the design button. However, whenever I click the design button, the text file of the query that I already designed...
My Excel Data has two coloms
1st Column is Bank A/c No & 2nd Column is Amount
Excel Data
Bank No Amount
17755 65000
17692 25000
17456 1500
25005 500
27201 10
26845 2
Required text File Data
0250010000.17755.00065000.00...
SCENARIO:
1. I have written some macros which simplify some repetitive tasks.
2. Other employees in the company would like to use the code for their personal project spreadsheets.
3. These other employees have zero knowledge of VBA
GOAL:
I want the employees to be able to go to a folder on...
I need some help in extracting text from a text file using VBA.
I have a vba code that copy-paste a text file to excel and run from there on.
But recently, having lots of line and formula within the excel slows down the process.
the file contains from hundred to thousand of lines.where as I...
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 MrExcel.com.
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 "mrexcel.com".
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.