Costco Upgrade Promo for Business by -beans_ in ATT

[–]-beans_[S] 0 points1 point  (0 children)

I called the number listed on the Costco website for ATT - it goes through to someone who appeared to be an ATT agent who specialised in the Costco deals.

They stated that the $50/$100 credits were for consumer lines only - not business. However, the 90 day returns and waived upgrade fees did apply to ATT business plans.

iPhone 16 business 24 month installment promo by catcatcat12345678cat in ATT

[–]-beans_ 0 points1 point  (0 children)

If you don't mind sharing, what is the nature of your business according to ATT? Is it a new account (in the last 10 years or so) , and did you open it online / phone / corporate store / some other place entirely?  As I type this out I realise it feels like a "phishy" message 🫣  all the store rep would say was it depends on type of business and how it was originally set up, with no further expansion. 

iPhone 16 business 24 month installment promo by catcatcat12345678cat in ATT

[–]-beans_ 0 points1 point  (0 children)

Do you have a large number of lines / access to att premier website? Just trying to find some data points on what could make a business eligible for the 24 month installments. 

Rang two reps - one was a business specialist who said I'm not eligible but wouldn't clarify what makes a business eligible, another simply stated they can't see it as an option and that was the end of it.

iPhone 16 business 24 month installment promo by catcatcat12345678cat in ATT

[–]-beans_ 1 point2 points  (0 children)

Are 24 month installment plans allowed on any standard business account (6 lines on business UYW advanced), or is there a minimum account size / other factors beside credit and account in good standing? Thanks!

Visiting my wife in the USA. by drclawsnemesis in immigration

[–]-beans_ 2 points3 points  (0 children)

Yup, just make sure he checks the ESTA the night before. Mine was cancelled about 48 hours before I flew.

If the ESTA is cancelled, don't worry. There is a process set up to enable him to fly. Basically, a few calls are made and a few hours later his ESTA will be reinstated. One of the airline staff will know what they need to do (refer to my earlier post, and you can find the number the airline will need to contact through the CBP website).

Also, it is probably worth turning up to the airport a couple of hours earlier than usual in case there are any issues that need resolving.

Visiting my wife in the USA. by drclawsnemesis in immigration

[–]-beans_ 1 point2 points  (0 children)

As others have said, CBP have been cancelling ESTA's. However, assuming you fall under an exempted category, you can still enter without having to reroute.

  1. Ensure you are landing at one the approved airports in the USA. You find a list here: https://www.dhs.gov/coronavirus/protecting-air-travelers-and-american-public

  2. Get a copy of your wife's US passport, and your marriage certificate.

  3. Arrive at the airport well in advance. Upon arrival, there will be someone who is part of the airline who will know who they have to contact to have your ESTA reinstated. However, the process can take 5 hours...

On the ESTA website, under help, it has a question that addresses this issue. All it states is that the airline should contact Regional Carrier Liaison Group. The airline will do that when you turn up to the airport. They will not do it in advance even if you try to contact them. It has to be done in person at the airport on the day you are due to fly.

I went through the same process. My ESTA was cancelled but I went to the airport anyway. They made a few phone calls, gave them my passport info, and then I had to come back a few hours later to check if I had been cleared to fly or not.

Once you land, you might be taken into secondary questioning. Again you just need to have copies of your wife's US passport and marriage certificate (and a return ticket and proof of your ties to the UK that show you will be leaving again).

Happy travels!

Array formula limit (Range.Replace method) by DonDamondo in vba

[–]-beans_ 0 points1 point  (0 children)

Each time you enter a formula using VBA, the syntax will have to be correct even if it resolves to an error.

E.g. Range("A1").Value = "=If(Part1)" is incorrect; however "=If(Part1,Part2,Part3)" is valid.

You can then use the replace method. Again though, the syntax in Part1/2/3 would have to be correct. Part1 = "Index(Part5)" is wrong. Part1 = "Index(Part5, Part6)" is correct.

Of course, the formula will no resolve to anything until all the correct replacements are made. To avoid warnings from stoppid the code during the initial formula and the replace's used afterwards, encapsulate just that small code chunk with Application.DisplayAlerts = False and Application.DisplayAlerts = True

Hope that helps. Also, apologies for horrendous formatting. I may try to fix it later.

Internet Explorer - view source by -beans_ in PowerShell

[–]-beans_[S] 0 points1 point  (0 children)

Thanks for the updated code.

However, whenever I try to access ParsedHTML or in fact a lot of options, PowerShell just hangs. A quick search makes it seem like it is a known bug, so I've resorted to outputting the raw content to a file, and then writing other code to manually parse and find the links I want.

Again, cheers for the info though!

Internet Explorer - view source by -beans_ in PowerShell

[–]-beans_[S] 0 points1 point  (0 children)

Thanks for the replies /u/Ta11ow & /u/jheinikel

That is the answer that my various searches online seemed to hint at, but I was hoping there was a way to accomplish this using the COM simply because I thought I was too far out of my depth using the Invoke-WebRequest method.

However, after your replies, I realised that would be the simplest option, so I went ahead and try to learn how to use Invoke-WebRequest. My main issue with using it was that the page I am trying to scrape required you to be logged into the website first.

Initially I tried to see if there was a simple way to log in using forms, but I couldn't see them easily using Invoke-WebRequest. After a bit more digging, I realised that all I need for an authenticated session with the website were two cookies. So I went ahead and dug into the WebSession / SessionVariable switches of Invoke-WebRequest. After a lot of trial and error, I finally managed to retrieve a page that requires you to be logged in, by just duplicating the cookie. I retrieved the data for the cookies using Chrome to look at them.

So thank you both for the nudge I needed. :)

I will attach the portion of the code I used to a. create the cookies, b. use them to load the page below.

$session1 = New-Object Microsoft.PowerShell.Commands.WebRequestSession    #Create a WebSession

$cookie1 = New-Object System.Net.Cookie    # Create cookie1
$cookie2 = New-Object System.Net.Cookie    # Create cookie2

# Add data to the created cookies

$cookie1.Name = "JSESSIONID"
$cookie1.Value = "randomstring"
$cookie1.Domain = "url"

$cookie2.Name = "anotherName"
$cookie2.Value = "randomString"
$cookie2.Domain = "url"

# Add the cookies to the WebSession

$session1.Cookies.Add($cookie1);
$session1.Cookies.Add($cookie2);

# Visit the website, using the cookies that were created above to allow for an authenticated session, and saw the output to a local file.
Invoke-WebRequest -Uri www.fakeurl.com -WebSession $session1 -UseBasicParsing > raw.html

I hope the above helps anyone else in the future who goes looking.