src

Hi all, I'm declaring my source as "src" and my discount as "dis" src will always be a value, but dis can either be a value or blank. An example will be src = NQS and dis = "", or src = NQS and dis = NQS20 My code is below: src = Cells(ActiveCell.Row, "F").Valuedis =...

Hi all, I know some of what I am doing is not the best possible solution but work with me. I have combobox that is populated from an access table. That works great. Now I have a checkbox that I use to update the checkbox field(Yes/No) in the same table based on the combobox selection. That too...

Hello I have a macro that should loop through the sheets until it reaches the sheet named "HO". However it still tries to run the macro on this sheet. Please can someone let me know where I have gone wrong. Here is my code. Sub Nursery() Dim ws As Worksheet For Each ws In...

Hi, I have the below code that opens and copies data from a closed workbook to the active workbook. Sub FetchData() Dim src As Workbook Set src = Workbooks.Open("G:\Managers\Existing Managers\Equities\Data Management\Monthly Manager Research...

I am trying a new set of code: Sub GetDataClosedBook() Dim src As Workbook 'location of the file and data to copy Set src = Workbooks.Open("C:\\Documents\Data Calc Formulas v 1.13b.xlsb", True, True) 'bring to this workbook ThisWorkbook.Activate...

Hi, With help of the forum and a little research myself, I've come up with the following code that opens a 2nd workbook, copies the data from the specified tab ('Time') and then closes the 2nd workbook that I just opened. This is great, but I have two issues that I need help adapting: 1)...

i am super new to VBA so be gentle... I copied this from youtube and it works great if the filename is fixed. The path will always be the same, just the file name would be one of the following (which i have the user select from a dropdown... (or can be another solution if easier) File names...

So this is my code: Dim src As Workbook Set src = Workbooks.Open("UMF_IR_ADM_<wbr style="font-family: arial, sans-serif; font-size: 12.8px;">SPARTACUS_1910 (Data as of 3-5-2018)") Worksheets("Executive").Range(<wbr>"D7").Value =...

I've almost got this but haven't found a way to get a checkbox (form type, not ActiveX) number. I have too many and want to avoid putting in those. Here is a sample of my current code. So the reference CheckBox1, I would like to have it be automatically determined so that I can use a variable...