modules

Hello... Here's a simple function I use in a lot of different programs. I normally just paste it into each module but it occurs to me there should be a way to paste it a single time and make it available to all the modules. 'Get Folder Function Get_Folder() Dim Folder_x As String...

Good day. I am running Excel out of Office 365 on Windows 10. I was working in the Developer function editing a macro. Normally, on the left side of the screen is a list off all the available Modules. I tried to hide some modules with a number higher than 9 because the list was sorting 1...

My current code simply adds a 1 to the module's names, just wondering if there's a replace command I could use or some other method, Thanks Sub Import_basFiles() Dim StrFile As String StrFile = Dir("C:\users\steve\desktop\basfiles\") Do While Len(StrFile) > 0...

I have a spreadsheet that takes training attendance for up to 16 modules (there is a 4a and 4b between 1 and 16 also). I have the code written so that when a name is entered, and a user chooses the appropriate modules that have been completed it writes properly to 2 other worksheets. The problem...

Hi, I am new to Vba and have picked up a lot but I still need some help with a spreadsheet I am putting together. I have two sets of stock sheets (on separate worksheets) in the same file that I need to compare to see which ones exist in one that don't in the other and then highlight them. I...

Hello, I'm looking for the best way to manage a group of data record layouts where I can create one module with these record layouts, (all DIM names and types), and include them into worksheets with 30 separate code modules. I would like to modify the record layouts in one place, and have all...

Is there an (easy) way to move ALL macros to a new workbook? I need to move around 100 macro's. The only way I know how to do this is to: (1) Copy and paste everything into new modules. (2) Export each modules 1 by 1 and then import into new workbook 1 by 1. (3) Drag and drop each macro into...

Hi all, I have an Excel workbook with 2 modules: OwnMailbox & SharedMailbox. Both modules hold a public sub: OwnMailbox has sub Kickoff, SharedMailbox has sub Kickoff1. I try to start the procedures via PowerShell, however it seems it's not working as expected. This is working: $excel =...

I want to de-clutter the list I see in my VBAProject window. I see a lot of modules that have nothing in them. Perhaps they did at one time, but I'm guessing as macros were created and removed, they became empty. ?? So if I double-click on one that shows nothing in the window, is it all right...

Hi and thanks in advance I have a Workbook with 3 sheets and 4excel vba modules when I go to VBA I see the Sheets and the VBA modules mixed. I do not see the way I used to see the modules, I mean, Now I see this way: 1) aaModule bbModule Sheet1(Sheets1) Sheet2(Sheets2) Sheet3(Sheets3)...

Hello, I have a work book, in Excel 2010, that uses modules to build a spreadsheet template (Datasheet-C). I work off of Sheet1. When all said and done, I have a button, on Datasheet-C, that when clicked deletes all other sheets besides Datasheet-C, removes the code from Datasheet-C for the...

I have a workbook that uses macros. I open a lot of macros when loading data to a lot of sheets. I would like to close all open macros and modules before starting the next operation and before closing the workbook. Can someone help me do this? Thank you in advance

I was wondering if there are any additional security tips beyond password protection for VBA modules since VBA passwords are pretty easy to crack? What others things have folks tried?

Hi i have 3 different worksheets used during different modules. Is there a way that i can set these worksheets as public variables and then refer to them in the modules. Public ws1 as string public ws2 as string public ws3 as string sub setvar() set ws1=sheet(1) set ws2=sheet(2) set...

Hi. Have anyone experienced that codes in modules have stopped working recently?? I have a sheet with a lot of functions in different modules. Yesterday I discovered that the codes in the modules is no longer recognized by Excel. I thought it maybe could be a corrupt installation on my...

Does anyone know of EXCEL VBA freeware (not visio, not commercial) that goes through your VBA Project and documents the call stack with whatever object types, names and signitures it happens to encounter after Activate, and then, since its not possible to tell what a user will do next, at least...

Hi. Longtime lurker, first time poster.:) Due to an upcoming position change, I need to pull out all the macros and modules I've created and store them in a central location for both my future use and as a reference bank for my replacement so they don't have to create them from scratch. TIA

Hi Guys, I've hit a brick wall... I need help making a macro button in WB1 to open WB2, then to find and match a customers information (First Name, Last Name and DOB) and then mark each match as a "YES" or as "Blank" after the last cell on WB1 Here's an example of the workbooks. WB1...

Hello, I am requesting assistance from RoyUK; a lot of your post has helped me and I'm urgently needing your assistance...of course this is open to anyone else who can assist. I'm not an "expert" with VBA but know enough to be dangerous, which is dangerous :eeek: At any rate, I have a...

Could you direct me toward some class modules (VBA or VB) to calculate the moon ( and planets ) rise set altitude azimuth for locations ( Lat, Lng, Elevation ). Most I can find are about 1998 models using UDF 's on worksheets. Need to graphically present these for high school students.