Search results

sorry, I am not sure I follow. In the code wherever "-Company Name-" is used is just a redacted version for data protection. usually, the company name is actually there. The file paths usually work just fine. As I say, the code runs fine on my own computer.

yes, something about not finding the file path. C:\users\MyName\rest of the file It is as if the export is ignoring the ENVIRON function completely

Apologies to bring up this old thread but I am having problems getting the ENVIRON function to work all the time. Whilst the code works fine to open up a shared spreadsheet on someone else's computer now, I have one bit of code which kills the old exported spreadsheet, exports the updated...

Yes, I used a Macro and managed to edit the code @Gasman provided to me to include the border options as well. All is working amazingly now and the thread is resolved. A special thank you to @Gasman for his help in resolving this.

Sorry to add to my own thread again! Would there be any way to update that so that it can remove borders from a range when another cell in the table is blank? I used to have a CF rule set up where if the MO column is blank, the borders disappeared leaving a blank white space like you can...

Never mind, bit more investigating and I have it working now. I found some code to convert selected cell colour to its long number. Now to test it on multiple formats!

Yeah, I had a read through now, thank you. colour wise, I keep getting the below issue: This debugs down to here: I get my colour numbers from custom section of the more colours option but these cannot be right. Am I missing something?

Whilst I struggle to comprehend the code you have given me, I look a little deeper into what my code was doing and noted the following: Sub UpdateProdPlan() ' ' UpdateProdPlan Macro ' ' Keyboard Shortcut: Ctrl+m ' ActiveWorkbook.RefreshAll Dim rng As Range Dim condition1 As...

ok, thank you. I will give it a try and see how I get on.

@Gasman, wow, that is a big wall of code! Starting to think I might be out of my depth with this. If I set my "CF" worksheet up exactly as above, is it a simple copy/paste job of the code itself? @theDBguy, unfortunately not. There are already more rows than are needed. that data moves up/down...

Hi all, I am working on a project that creates a production plan in Excel based off data from an Access Database. This was working fine until I introduced conditional formatting into the mix. I found that the range for the conditional format kept changing when the data was updated within the...

Thank you. I think I will look into that as some added protection then.

Morning All, I can confirm that all is now working thanks to the Environ Function! I can also confirm that both myself and my colleague were able to be in the spreadsheet at the same time. Thank you all for you help on this. It has been an excellent learning exercise for me.

@The_Doc_Man, this seems very strange to me as there are many shared spreadsheets at my work that have all been working fine for quite some time. @raziel3, I believe everyone is accessing it through a sharepoint path. The spreadsheet in question is not one that everyone edits, it is a...

Oh no, I was not aware that users might get locked out. I will have to test and see what happens. Thank you for the heads up!

@Pat Hartman, I am not sure. It might be the way that the Sharepoint folders are set up. When I copy the file path from my computer, it starts from my C: drive, if the same link is copied from a colleagues computer it starts with theirs. I do not know enough about computers to be able to guess...

Thank you. I will learn about this function later and see how I can amend my code to suit. Am I right in thinking that I would "Dim UserName as String" and then concatenate that variable and the rest of the file path together?

Hi All, I am having a bit of a unique problem with a database I am trying to create to improve processes at my work. I would like to open a shared Excel document using a button click and whilst this works perfectly on my own computer, the moment it is opened on a colleagues computer, the code...

So, I left it overnight as i was getting a little annoyed with it all. I have come back to it this morning, deleted my old ItemStatusF form and remade it after I removed the autonumber field from my table "OrderStatusT". This meant that both the combo box and the Form records now only had 1...

I do not think so. The unbound combo box was created using the Wizard. It pulled through the the entire "OrderStatusT" and the hid the primary key field ("OrderStatusID") so I think that still counts as 2 fields in the unbound combo box though.