Search results for query: *

Hello I am looking for some help using the BuiltinDocumentProperties object. I am trying to adapt it into a directory index macro. What the macro currently does is use FoundFiles to basically create an index of whatever path you want it to. I then want to offset and list various info on the...

Hello i recently bought a pc but do not have the admin rights. It is xp and i have managed to download a version of MS VB express 2008. Using VB is there a way to create a new user then add to admin group or am i barking up the wrong tree entirely here. I am a familiar low skilled user of VBA...

Hello I have created a .xls for multiple users; it seems that some users have accidentally delted data from the SS in the past, is there a way i can have maybe use a userform that warns users when any data is about to be be deleted and request a confirmation, this would include using delete on...

Hello can anyone give me a code for Excel VBA that will give me a complete index list of all files on a drive (e.g. my C) Thanks in advance Nie

Hello there I have created a macro that sends a message to set addresses when a criterion is met. However on my outlook it brings a security pop up, is there something i can incoporate in my code that automates or gets riund this part as well. Many thanks N

Hello - I am having problem populating my combo boxes and list boxes. I have coded the following: Private Sub UserForm_Initialize() textb1.Value = "" With combobox1 .AddItem "A" .AddItem "B" End With cb1.Value = "" textbox1.SetFocus End Sub This works fine but for some reason when you click...

Hello I can not think of a solution to my problem. The problem is i need to divide "number of calls" by "time logged on" (Helpdesk Scenario) - so i need to divide 55 calls by say 5 hours logged on: I calculate the time logged on by subtracting an "=now()" function from a "shift started time"...

Hello there i am trying to populate a list box with the names of the sheets in a workbook. I know a way to do this if i know how many sheets there are but cannot do it for x amount of sheets. Ideally i would sue this macro many of my workbooks and it would count how many sheets i have and...

Hello there I am trying to populate a listbox on a userform with the sheet names of the spreadsheet. I need a code that picks up, firstly, how many sheets there are and then puts them into a listbox for selection. I would like the macro to work on any spreadsheet regardless of how many sheets...