modules

EXCEL VERSION Excel 2013 (15.0.4631.1000) BACK STORY I create weekly reports, reporting activity based on a 'Week number' defined by a custom year. Custom year = 01 SEP - 31 AUG. Each week within this custom year is defined by a week per row in a named table. E.g. Monday 02/09/2013- Sunday...

It seems I have accidentally made about 19 duplicate vba modules so what did I do wrong and is there a quick way to eliminate duplicates?

Dear All, I have a file which is distributed to around 20 users. I need to make some changes in one of the modules and instead of recalling all files and do the change manually I would like to create an update file and to export the new/updated module through VBA to all 20 user. Does anybody...

Hello, I am trying a do cell replacement exercise and have found it a bit challenging. Below is my data and expected results: Current Data: <tbody> Policy No Name_Address Agent Code Date Premium 23456 James Price T83P 2XP 23/05/2013 £35.00 Line1 Line2 Line3 PO1 2TN...

Hi, I'm very very new to access vba. Here's what I did(I'll explain with an example) - (NOTE: If status is inactive then column 32, 33 should be "No" and red. If status is "Active" then only next strings should be searched in column 13) Example - columns are - Status(4th column), Group(13th...

Hi. I've made a code that will create, position and name a new command button when a command button that already exisits is pushed. The next step is to insert code into the new button. I think the best way to do this is to put the new button code in a module, which can then be copied and pasted...

I use Access 2010, but many clients still have 2003, so I have to deal with 2003-format files all the way. I've developed MyTools.MDB with nothing but macros and modules containing various tools like exporting all objects to text files. I want to make it an add-in so I can open any MDB or...

I'm using Excel 2010 with Windows 7. I'm new to macros. I've been recording macros and trying to assigning a keyboard shortcut in the Record Macro window but, they don't seem to stick. The macro keyboard shortcuts work with the first use but, don't work if I close Excel and try to use them...

hi all, Does anyone know how to import modules which are saved on the computer into a opened powerpoint presentation? I have succeeded in doing this with importing into other excel files and i am trying to modify that code. Everything works up until it trys to import the modules. Here is my...

Hello GANG! I have 3 modules I am trying to merge into 1...they are: Sub WriteOffs() ' ' WriteOffs Macro ' maniplute Imported Oracle Data for write-offs ' ' Columns("J:L").Select Selection.Delete Shift:=xlToLeft...

Hello, I've been trying to calculate a weighted average and weighted standard deviation in Excel 2007/Windows 7. Since there is no formula for it I looked for one on the web and found a UDF that I copied into a VB module. It worked and I got the result I was looking for. I saved the workbook...

Hi Guys, I juts don't seem to be able to formulate the right question to Google today, so maybe you can help me out. I have code in several modules (saved as .bas files) and want to use them in different workbooks. How do I do this? All I have found is code for importing the code / module...

Can anyone please provide a script that lists all of the userforms in my file named Excel Template in Listbox1 and a script that lists all of the modules in the same workbook in listbox2. I don't want to list the macros in the modules though, just the modules themselves. Thanks

I have been playing around with scripts trying to delete modules from ALL workbooks but no matter what I try it only deletes them from the current active workbook, can someone please help. I have read other forum threads on this site and Chip Pearsons but nothing seemes to work. Before...

Is there a script that will deactivate the worksheet selection change event so that it stops updating and then when I am finished with the workbook I would get it reset to be activated again. Thanks

Is this a script that I can use to rename a module in my workbook. i.e. I want to use a script to change code: private sub module1 to code: sub module1 And then when I am finished using it I would then change it back to private sub. I don't want all the scripts in the macros dropdown...

Hello all excel experts. I have a fairly simple problem that my inexperience is making difficult.I have a column A and column G list generated in Sheet3. I have build a simple droplist interface in sheet1 to fill in the additional data for Sheet3 columns B,C,D,E & F. Here is my problem. I need...

I would like a vba script which will export all modules from workbook named excel template and then would import the modules into ALL open workbooks. Your help would be appreciated.

The block of code below, provided to me by Peter SSs, needs to be modified slightly to accomplish a new task. Instead of just grouping and offsetting the given values in my range for column A, I need to do something similar for a range in column B with a small exception. The offset target...

Populate a listbox from worksheet range BUT do it with a BAS module call Greetings- I have a column of data (really several different columns of data) and I want to throw it into a userform listbox- not too hard. The tricky part is that I want to be able to throw the code into a *.bas...