Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109512
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Huge data set Find-Replace |
| Date | 2016-11-02 00:47 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <nvbr3b$9hi$1@dont-email.me> (permalink) |
| References | (2 earlier) <nv95ip$342$1@dont-email.me> <48812e8f-ca61-4673-af94-b488eb15c40c@googlegroups.com> <nvaprp$be3$1@dont-email.me> <nvb7gn$1gs$1@dont-email.me> <50406397-ecd8-4ad7-8917-57862adbb577@googlegroups.com> |
> I have no idea how to make them work, nor can I see them when I call
> up the Macro box with f8 from the sheet with my test data.
They have args and so must be called by other procs; this is why they
do not show up in the Macros dialog.
WksToTabFile is what you need to load the sheet into a string var. This
is done by the line to write to file and so you just...
MyStr = Join(vTmp, vbCrlf)
Replace(MyStr, sFind, sReplace)
..then load MyStr back into an array of arrays OR a 2D array...
vTmp = Split(MyStr, vbCrLf)
..and loop thru to create array of arrays...
For n = LBound(vTmp) To UBound(vTmp)
vTmp(n) = Split(vTmp(n), vbTab)
Next 'n
..and choose 1 of the methds to put the data back into the sheet.
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Find similar | Unroll thread
Huge data set Find-Replace "L. Howard" <lhkittle@comcast.net> - 2016-10-31 19:17 -0700
Re: Huge data set Find-Replace GS <gs@v.invalid> - 2016-11-01 00:21 -0400
Re: Huge data set Find-Replace GS <gs@v.invalid> - 2016-11-01 00:27 -0400
Re: Huge data set Find-Replace "L. Howard" <lhkittle@comcast.net> - 2016-11-01 01:11 -0700
Re: Huge data set Find-Replace GS <gs@v.invalid> - 2016-11-01 15:19 -0400
Re: Huge data set Find-Replace GS <gs@v.invalid> - 2016-11-01 19:12 -0400
Re: Huge data set Find-Replace "L. Howard" <lhkittle@comcast.net> - 2016-11-01 18:01 -0700
Re: Huge data set Find-Replace GS <gs@v.invalid> - 2016-11-02 00:47 -0400
csiph-web