proceeding

First post. Need to get LUN ID from a Disk UID initial DISK UID is a string of around 20 odd characters. I only need the last 6 which i can do. but then i need to convert that 6 digit string into a 3 character string. like so initial 6 digit string 3 4 4 5 3 4 only intrested in characters 2...

How can I ensure the extraction of data from a webpage has finished before proceeding to the next sub?

OK excel guru's, I have a MsgBox that runs when I open the workbook template telling the user to paste previous days data in the prev day worksheet before proceeding. What I want is to permanently disable this MsgBox after selecting OK so once the user has saved the file under the new name it...

Hi, I have a query regarding DartPart and the format of the value it returns. My example is using date 01/01/2018 If I use DatePart("d", #01/01/2018#) the value is returned is 1. However, what I would like is to have the value, if less than ten, to have a proceeding zero, eg 01. How would I...

Hi, I have two related issues regarding the extraction of a portion of a text string which can be noted as 1) and 2) below. 1) In the case where I have some example inputs of R6.300, R10.300 & N10.300, I would like to be able to extract the numerical value proceeding the capital letter - in...