wkb

Hello When inserting Images i get Error "variable not defined" using the below code in Excel 2010 but runs perfectly in Excel 2013 which i am currently using Set s = ActiveSheet.Shapes.AddPicture2(picPath, False, True, rr1.Left + 48.48, rr1.Top + 11, 60.0944882, 462.047244...

First, I want to thank all the awesome people who have helped me so far. I've managed to streamline my tasks significantly with the VBA help that the people on this forum have provided. Thank you so much! Now, my current bit of tinkering. I use a single file that has my macros programmed into...

Hello, I have 6 Excels files. I am using one file as the main file, and the other five I am using as data connections for the main file. My code is as follows Sub DataRefresh() Dim wkb as Workbook Set wkb = Workbooks.Open("filepath") wkb.RefreshAll (This is where the debugger says the error...

Hi, Code is several procedures/functions, too long to post and haven't quite found required answer through several searches online. Workbook macro opens a file, extract data from opened file and then creates output sheets in the workbook macro is run from: Sub CreateOutput(byref dic as...

I have a template file which has several macros in. At present I have a short bit of code at the start of the module to check the file name is not the template file. This is to prevent users overwriting the template as each of the modules as a save at the end. WKB = ActiveWorkbook.name...

Hello, I am having difficulties with what should be an easy macro.... I am trying to link two workbooks so that specific column values(only) get pasted into active workbook when activated by command button. Source wkb: "Inventory Master List (Macro)" Destination wkb: "Inventory Check...