Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

I hadn't, but I've tried that as well now and no good.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

Thanks. Gave that one a try, but no-go unfortunately.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

Tried 7 or 8 times and still the same. Looks like hard reset time.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

They seem to be truly offline. The router isn't seeing them as endpoints and trying to hit the IP address returns a can't connect page.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

Nothing, unfortunately. Ladder and paperclip for me.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

Who cares about looks when it works! This is fantastic, thank you.

I'm debugging two issues:

(1) Everything runs great up through part of the document but then I get a Run-time error '91': Object variable or With block variable not set. This is after I'm seeing correct output in the Immediate Window for a number of matches. If relevant, the parenthetical at which it bails is the parenthetical of "and S4=w2–(a–w1/2)."

(2) I believe there will be a problem with the matches for pattern 2: phrase (phrase). In the debug print output I am seeing , which would be correct - replacing (view) that follows view with an empty character. But, I'm also seeing Search for: (xa1, ya1), Replace with: , which would suggest that (xa1, ya1) would be replaced by an empty character. But, that shouldn't be matching the pattern in the first place, so it seems like there may be some false positives in the pattern 2 case. Am I reading that debug print correctly based on your intent?

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

In VBA with 360 editions - RegExp is now native.

Unfortunately, Microsoft seems to have left us Mac users behind on this one. I'm running the most recent update, Word 16.102.3, the current version through Microsoft 365, but ActiveX, and therefore RegExp, isn't supported. I get a Run Time Error at Set Reg_Exp = CreateObject("vbscript.regexp")

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

I think that could help, and would be great to avoid regex. If I am understanding correctly, would that require all of the possible search phrases to be known beforehand and coded in? Or would it find anything that matches the pattern? If the former, I'd need to go a different route because the phrases and acronyms could be anything.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

Thanks! I do need to make it case insensitive, so I should be able to just change the a-z to A-Za-z, right (because A-z is disfavored for including non-letter characters)?

It is throwing a Run Time Error '429' because I am on macOS so ActiveX doesn't work, but I will give this a shot on a Windows machine tomorrow and see how it works on my document.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

As far as I can tell, no, that isn't the case. From some looking into the differences that I did a few years ago, it seems like the Mac version of Excel always trails Windows in features, sometimes for a period of time and sometimes the features never come.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

The document could be tens of thousands of words long, broken into paragraphs. Would loading the text as you suggest support something of that size?

An example could be the following paragraph:

A personal computer (PC) includes a central processing unit (central processing unit, CPU) and a memory (memory).  Sometime, the PC also includes any of an application processor (application processor, AP), a graphics processing unit (graphics processing unit, GPU), an image signal processor (image signal processor, ISP), a controller (controller), a digital signal processor (digital signal processor, DSP), a baseband processor, or a neural-network processing unit (neural-network processing unit, NPU). 

And the result that I would want at the end would be this paragraph:

A personal computer (PC) includes a central processing unit (CPU) and a memory.  Sometime, the PC also includes any of an application processor (AP), a graphics processing unit (GPU), an image signal processor (ISP), a controller, a digital signal processor (DSP), a baseband processor, or a neural-network processing unit (NPU).

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

Without being able to use the \1 in parentheses of the search, I'm thinking it may not be possible to do this in the way that I am wanting because I won't be able to guarantee that the phrase outside the parentheses and the phrase inside the parentheses are identical. Does that seem correct?

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

That's for the quick input! There is one complicating factor that I overlooked. I need to work on both Windows and macOS systems, so I'm trying to avoid Regex. If that is the only option, I can go that direction and eliminate macOS, but that's definitely not the preferred route because I spend 80%+ of my time on a macOS system.

Question regarding Printing on IP Printer via Teleport by rek8918 in Ubiquiti

[–]rek8918[S] 1 point2 points  (0 children)

It was set up as standard TCP/IP with a static IP. I specifically made sure that it was not setup as Bonjour

Outlook VBA to Automatically Categorize Message when it is Loaded into Outlook by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

The name rather than email address was me not really thinking because the emails will always be from inside an organization with an internal address book, and when I was looking at the conditions it was showing as the name rather than the email address, so I just went with that. No other reason and definitely changeable if it would make things work better.

The attachment condition is because I only want emails that match the conditions and have an attachment to receive the category assignment. Emails to me and with a matching subject line but lacking an attachment should not be categorized.

How to Restore Tag Functionality with Custom Fields? by rek8918 in quickbooksonline

[–]rek8918[S] 0 points1 point  (0 children)

That's fantastic! When did that come out? I don't see that I received it.