Search results for query: *

Hi guys, I am not sure if this is possible, but I wanted to give it a try. I am working with userforms on excel. One of the userform is called "frmTrials" and on it I have a ComboBox1 that the user may choose from 1 to 3. Based on that decision a second userform is openned called "frmComp"...

Hi, I would like to extract the filename from the path using excel vba. As I open my file I store its name on a variable calle FileVar. I did some research and found an example of deleting the filename from the path using: Directory = Left(VarFile, InStrRev(VarFile, "\")). I am not sure how...

Hi everyone, I am not even sure how to explain what I need. I have 6 forms that are linked to a general form called frmDevices. Here is just a portion of the coding for the dependent userform (frmDevices) where each Case is for a different form: Private Sub cmbDevice_Change() Dim r As Range...

Hi everyone, I have a big project using user-forms in Excel and one of the task is to allow the user to attach different types of files such as text and picture to a cell pre-destinated by my VBA code, so that it can be downloaded by a different user/tech. I am not sure if this can be done...

I have a text file that has 65 columns and 1836 rows. I need to: * Open the text file for the given path * Create a vba code in excel that writes a string before each cell; (Example: "Insert into channel_data ("here have the cell information")" * Place the entire workbook with the added...