Recent content by MottoK

Hi, we have two environments, our virtual environment uses Windows 10 1909, Outlook 2016 and several browsers but for this example Chrome v109.0.5414.75. In this environment we are able drag attachments from Outlook to OneDrive online no problem. On our 'physical' environment we have Windows...

Hi, we have a hybrid setup, exchange on prem and O365. I renamed a shared mailbox (and alias) at the request of a user and now the shared mailbox no longer appears for her in Outlook 2016. This is doing my head in. It works for all other users, it works for her account via OWA and via her...

Hi all, sorry if this post is in the wrong forum but was struggling to know where to post it (let me know if I can/should move - this is my first post here in years!). The circumstances: Our Cisco/network engineer left our company last week and I have been left to deal with everything, my...

Not at all Skip, wouldn't have been able to figure it out myself so many many thanks.

Woohoo that's it! Thank you so much for that SKip, didn't realise it would be such a headache. can't believe I saw that .Row while searching for an answer but was convinced it was around the If statement, id*ot that I am. Pity we can't test from ipads right enough, as I'm waiting to hear if...

Don't leave me! Appreciate the help so far with this everyone but still not working, seems to be around the If .Value <> "" Then bit of code so if anyone has any ideas that would be very much appreciated. Thanks.

Now error says "The remote server machine does not exist or is unavailable: '(Cells...).End'" - what the heck is that all about it isn't even calling a remote machine?!

Code so far is below but when I run it nothing seems to happen, it is however opening Excel, when I close via task mgr I get the "remote procedure call failed" error? Dim r With objWorkbook.Sheets(1) r = 2 Do While r <= .Cells(.Cells.Rows.Count, "L").End(-4162)...

remote procedure call failed" but I'll double check I applied the code correctly when I get home. thank you.

Starting to feel really bad now Skip, "invalid procedure call or argument 'Left'" - guess it must be because it's trying to apply Left to a blank cell and I guess the same will happen when it gets to the Ucase as well. Sorry!

Yeh I see the line of code but unfortunately there are one or two blanks in the spreadsheet so only the first half get changed.

Well it works! Only problem is it stops whenever there is a blank cell, I'll try and figure it out. Thank you so much for your help Skip, brilliant.

haha - I love how cool these reply's are. Unfortunately not that easy, the same error occurs for every row in the entire 'L' column. :-(

Getting closer anyway. I can't set r as anything because vbscript doesn't allow data types so the code so far is as below. I now get an error saying "Object required '[string: "manager"]'. "manager" is the header string of column L. monitor is close to going out of window! Thanks for your...

Thanks but still not working, same errors as before. I'm literally double clicking a .vbs file to run this - didn't think vbscript supports data types? So close and yet so far!!