Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by dwillpower
at 2024-07-16 15:38:20
ModifyPoint:0 Replies:4 POST_ID:828993USER_ID:11893
Topic:
Visual Basic Programming;Spreadsheet Software;Microsoft Excel Spreadsheet Software
I would like to create a vba script to do the following:
1.)load the following file into Excel 2013:
http://www.irs.gov/file_source/pub/irs-soi/10eo.txt
2.) parse the files into columns using the following field specifications:
http://www.irs.gov/file_source/pub/irs-soi/10eoderl.xls
Any help you can provide is greatly appreciated!
Thanks!
1.)load the following file into Excel 2013:
http://www.irs.gov/file_source/pub/irs-soi/10eo.txt
2.) parse the files into columns using the following field specifications:
http://www.irs.gov/file_source/pub/irs-soi/10eoderl.xls
Any help you can provide is greatly appreciated!
Thanks!
Author: dwillpower replied at 2024-08-07 02:15:42
This what I ended up using. Couldn't find anything which addresses the specific situation on Experts Exchange.
Accepted Solution
Author: dwillpower replied at 2024-08-02 11:05:22
I ended up using a solution on Pearson Consulting located here:
What I used is located here:
http://www.cpearson.com/Excel/ImpText.aspx
What I used is located here:
http://www.cpearson.com/Excel/ImpText.aspx
Expert: duncanb7 replied at 2024-07-16 23:37:17
Proabably, you need to split function to split the text file sentence into
array and copt and paste into excel workbook
YOu can take a look aat the split function tutorial example at this
http://www.exceltrick.com/formulas_macros/vba-split-function/
The site is still loading, http://www.irs.gov/pub/irs-soi/10eo.txt
Duncan
array and copt and paste into excel workbook
YOu can take a look aat the split function tutorial example at this
http://www.exceltrick.com/formulas_macros/vba-split-function/
The site is still loading, http://www.irs.gov/pub/irs-soi/10eo.txt
Duncan
Expert: duncanb7 replied at 2024-07-16 23:33:44
You cansee use the following function to extract any format of remote files, for example yahoo.com index webpage.
I could not go into your site http://www.irs.gov/pub/irs-soi/10eo.txt , I don't know why,
it just keep loading.....
Could you us send the 10eo.txt file ?
Duncan
I could not go into your site http://www.irs.gov/pub/irs-soi/10eo.txt , I don't know why,
it just keep loading.....
Could you us send the 10eo.txt file ?
Duncan
Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" ( _ ByVal pCaller As Long, _ ByVal szURL As String, _ ByVal szFileName As String, _ ByVal dwReserved As Long, _ ByVal lpfnCB As Long) As LongPrivate Const BINDF_GETNEWESTVERSION As Long = &H10Sub DownloadFile() Dim result As Long Dim url As String Dim localFile As String url = "http://yahoo.com" localFile = "C:yahoo.html" result = URLDownloadToFile(0, url, localFile, BINDF_GETNEWESTVERSION, 0) If result <> 0 Then MsgBox "Couldn't download file" Exit Sub End If End Sub 1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:
