Help with If statement based on cell value of Active Sheet

[kt_mr_excel]

I'm obviously very new to VBA in Access and need some help with a very simple If statement based on the value of a specified cell in the active Excel worksheet. My many attempts have included every type of declaration I could find in online examples and many different range expressions but always result in an "error 91 - Object variable or With block variable not set". I also tried using a With block without any luck. Here's my simple sub - I thought that this approach would not require declaration of any variables, but obviously I thought wrong. Any help would be appreciated. (Note: Excel 16.0 Object Library is referenced)

Sub MySub()
If Excel.Application.ActiveSheet.Range("A1").Value = "String to match" Then
MsgBox "Message string"
End If
End Sub

 

[Micron]

Ahh, so I wasted all my time here providing you with the same answer that you already got elsewhere and you didn't bother to announce that you had cross posted.
Thanks. Won't happen again.

 

[kt_mr_excel]

My apologies if you feel your time was wasted, but I was merely trying to get an answer to the core question of how to set the wb variable to the open wb without a file path.

 

[rlv01]

My apologies if you feel your time was wasted, but I was merely trying to get an answer to the core question of how to set the wb variable to the open wb without a file path.

There are rules about cross-posting which you agreed to follow when you registered here at MrExcel.

Please read this article on the etiquette of cross-posting

A message to forum cross posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →

www.excelguru.ca

 

[kt_mr_excel]

Thanks! I didn't realize that. Sincere apologies.

 

[welshgasman]

Not often people admit to crossposting without notification themselves

 

[kt_mr_excel]

If it matters, I've never posted or joined any other forums. I just googled for setting the wb object to the open wb and came across a suggestion that worked. Just thought sharing it may help another struggling newbie.

 

[james_lankford]

found some really interesting code over here

Given the HWND values for several application windows, how to use vba to return each window as an object?

I use an API, run in excel, that returns: Parent window handles, classes and text. for ANY excel, non-Excel/non-office app. 'source: http://www.markrowlinson.co.uk/articles.php?id=4 The handle (HWND), 'text' and 'class' variables enable the identification of each Application window...

www.mrexcel.com

haven't tried it yet, but interesting

 

[welshgasman]

If it matters, I've never posted or joined any other forums. I just googled for setting the wb object to the open wb and came across a suggestion that worked. Just thought sharing it may help another struggling newbie.

Yes, that matters, a lot. That is not crossposting. At least not to me, so well done for finding a solution.?

 

[Micron]

If you didn't cross post you should have said so when I wrongly accused you of it. For that, I apologize.
In fairness, "I found a solution..." and posting the link would have been perceived differently than "I received another solution...) and not doing so.
Perhaps all those posts on that subject should be deleted.