exel vba

I currently have an issue trying to open PW protected file. My question is this: "Has anyone successfully opened either and XLS or XLSM file with ADO?" AND not had to actually open the workbook up in code first? Everything runs fine without a PW. I've tried moving the password location in...

Hi Team, Greetings! I need a help here, I have created an excel template in which the workbook has n numbers of checkboxes. I don't want end users to do the right click and change the checkbox properties. I want to lock all the checkboxes so that users can only check or uncheck the checkboxes...

Hi, I have created a Media player on a userform in the following way. Using a MP3 Filelister procedure ( available on the web), I populate a sheet with all the details from a music folder containing the tracks. Then I open a userform that creates a playlist for WMP, by looping through the column...

Hello and a happy new year to everyone on this forum! I am trying to filter a listbox full of data from one of the worksheets. I have 8 combo-boxes that have options within them which i want to utilise to filter the information already in the list box. I already have the listbox working when i...

I have a program which download lotus attachment to a path in computer. It does not download the file when the file is already downloaded. But if we delete the file from path, it downloads it again. I have a workaround, that we can mark the file as read when downloaded, but don't know how to...

Hi everyone! I want to have a webquery that pulls figures from a url in a cell. I was thinking it might be possible to do this using a string but I cant seem to get it to work. Can anyone help me please? With Selection.QueryTable .Connection = "INSERT STRING HERE"...