ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MVP's Where Are Thou? (https://www.excelbanter.com/excel-programming/444246-mvps-where-thou.html)

Dave[_11_]

MVP's Where Are Thou?
 
Hi MVP's,

I have currently an issue that I am not getting any bites on , I would
really appreciate if you could please look at it and give me a macro
for it. The thread is at

http://groups.google.com/group/micro...8d58b2b?hl=en#

Thanks in advance,

Dave

GS[_2_]

MVP's Where Are Thou?
 
Dave was thinking very hard :
Hi MVP's,

I have currently an issue that I am not getting any bites on , I would
really appreciate if you could please look at it and give me a macro
for it. The thread is at

http://groups.google.com/group/micro...8d58b2b?hl=en#

Thanks in advance,

Dave


I'm not a MVP but I can tell you that the reason you haven't had any
bites is because you did not answer the questions you were asked. go
back, read the replies, answer the questions, state how you want to
proceed, and see what results!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc



joeu2004

MVP's Where Are Thou?
 
On Feb 16, 2:19*pm, Dave wrote:
Subject: MVPs Where Are Thou?


I don't know why you need MVPs per se. Many non-MVPs are equally
helpful.

But to answer your question, see http://www.microsoft.com/communities...s/default.mspx.

The gist of it is.... The microsoft.* newsgroups are effectively
defunct. That is, MS no longer maintains them on its own servers,
which used to be the initial feed for the mirrored sites like Google
Groups.

The microsoft.* newsgroups that you find now may be disjoint, although
some newsservers share a common third-party feed.

In place of the MS newsserver, MS now only supports the Answers Forum
and some other technical websites. For Excel, see
http://social.answers.microsoft.com/...ry/officeexcel.

Most MVPs now service only those websites.

Harrison Hill

MVP's Where Are Thou?
 
On Feb 16, 10:19*pm, Dave wrote:
Hi MVP's,

I have currently an issue that I am not getting any bites on , I would
really appreciate if you could please look at it and give me a macro
for it. The thread is at

http://groups.google.com/group/micro...rogramming/bro...

Thanks in advance,

Dave


You need to cycle through your worksheets:

For each sht in ThisWorkbook.Sheets

Next

Inside that loop you neet define on column of each each database. Use:

Set R1=Range("B1").CurrentRegion.Offset( 1, 0)
Set R1=R1.Resize(R1.Rows.Count - 1,6)

....where 6 represents any suitable column

Now do the same for R2 your csv fie.

For each c1 in R1.cells
For each c2 in R2.cells

Next
Next

....and use Offset to reach out to other data in other columns.


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com