Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with excel
Search options questions only
not deleted
user 91810
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
4
votes
1
answer
93
views
VBA Function Reads Active Live Data Feed and Translates Product Codes
The following Function is one of the main analysis functions of a larger subroutine. The subroutine is responsible for translating codes that look like this "1|G|XNYM:O:LO:201611:P:44:+1/XNYM:O:LO:20 …
- 589
5
votes
2
answers
101
views
Raw exchange trade data analysis program
The following is a small snippet from a pretty large program written to analyze raw data and find specific trade structures. I am new to VBA and this is my first large scale program I have written in …
- 589
2
votes
1
answer
42
views
Parse Live data feeds to translate product codes
This is the second review of these code blocks. I made major changes and updates to the functions during my refactoring and I would like a follow up review. The original review can be found here VBA …
- 589
6
votes
1
answer
199
views
Retrieves Data From Various Excel Sheets Online, sorts, edits, and Analyzes said Data
I'm fairly new to Excel VBA so I welcome all criticism and advice! … data, ra, "ra", 5)
'Get Ethanol Data, format and paste
Call seperateData(cmeDataBook, data, cvr, "cvr", 5)
'Get Ln Data, format and paste
Call seperateData(cmeDataBook, data, ln, "ln", 1000)
'Excel …
- 589
6
votes
2
answers
81
views
End of day receipt emailing process
" & "<br><br>" & "Best Regards," & "<br>"
Public Const PDF_FILE_PATH As String = "X:\Back Office\Receipt Drop File\"
Public Const EXCEL_CONFIRM_FILE_PATH As String = "X:\Back Office\Receipt Drop File\Excel … firmFinder.Row, 2).Value
firmName3 = contactsMaster.Cells(firmFinder.Row, 3).Value
'Checks for separate trader emails.....If cell filled isTraderSeparate = true
'Checks for firm requirement of excel …
- 589