Search results for query: *

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!!

Hi Andy, appreciate your reply but unfortunately there is no way I can do this within Excel, there are just too many other factors/code/scheduled bat files etc in my project to use Excel directly so I need to be able to script this in a .vbs file (as in first post). Its because I don't have any...

Thank you so much for this Skip. Unfortunately I'm having problems getting this to run. I'm running this as a .vbs file and am getting errors such as "Expected end of statement" due to the Dim r as Object line (when I take out 'as Object') I get "Type mismatch 'Intersect'". Any ideas how I can...

Hi all, would someone please be able to tell me what code to add to the code below to enable me to change the last letter of every string in column 'L' on my spreadsheet please? This is an adhoc thing for work so don't know much about VBA. This is a .vbs file being called from a .bat file. Very...

Hi - we are looking for a way to 'group' calendars within exchange 2003. This will be used to group meeting room calendars together; This would allow any user when creating a meeting via Outlook to view the scheduling information of all meeting room calendars at once rather than having to add...

Just for those of you who may be in the same position it turns out that this was the correct BIOS update. Just run the program which extracts a folder called swsetup in the C drive, in there is a folder called sp46875, run the application in there. Cheers.