activeworkbook

Hi all: I have code Brown to select excel files and copy Range("C11:J34") from sheets (2) to sheet("PL2") of Activeworkbook Now I want to Brown to select excel files and copy Range("C11:J34") from sheets (2) to sheet("PL2") of Activeworkbook And copy Range("C9:N44") from sheets (4) to...

Hello, First, my apologize if this is in the wrong area and/or this has already been answered. This is my first time posting and I am relatively inexperienced with VBA. What I am trying to figure out is how to do the following: 1. Lookup user inputs on the ActiveWorkbook for new workbook...

At work we use an excel spreadsheet to keep track of which process we are at for multiple sites. As only one person can access a workbook at a time, I created multiple single user workbooks that can Sync to and from a 'Master' workbook. That part works fine. What I want to do now is when one...

Hey guys, I read quite a few posts about breaking or delinking links to external sources. I found quite a handy code, see below, to break links the easy way. However, I am stuck with a couple of annoying links to external sources: (1) Some links are stored within data validation (I copied one...

I created a personal macro that would allow me to automatically send emails using Excel. The macro works fine if I am using the actual workbook where the macro was created but not on new workbooks. I believe the macro is generating the fields to search base on the work book where the macro was...

I am having some trouble changing the lookup range from the ActiveSheet to the ActiveWorkbook. So instead of the Sub process looking on the active sheet, I am trying to have it look at each different sheet in the workbook. The error I am getting is Rumtime error 1004, No Cells were Found I am...

Hello everyone, this is my first post! I am trying to make some code to copy a module from my add-in, to the active workbook's ThisWorkbook module. I can't seem to figure out how to access it though. Here's the code I'm using: <code style="margin: 0px; padding: 0px; font-style: inherit...

Hi, First of all I'm a beginner in VBA, but thank you in advance for any help. I'm trying to create a macro to split all sheets from an active workbook into separate files. After a bit of a Google I've below the below code which works great for me. However, when I moved the code from the...

Hey all, I've inherited a macro that I'm trying to modify to capture additional info. Currently, the macro extracts data from all spreadsheets in a folder (that meet certain conditions). However, when I add in the commands to grab the filename, it causes the macro to only successfully loop...

I have the below VBA code running. However the filename SCORESHEET always changes as my staff’s are required to save the worksheet once they opened it. The macro in this sheet is activated via command button. They will save the filename something like this STAFF NAME-KPI-DDMMYY (e.g...

I have a macro that I run once a month. The macro makes the user choose which .xlsx file to use. Therefore the name of the working file varies. I'm using: Set CLOloans = ActiveWorkbook to standardize the workbook name for use in the macro but I'm not sure how to reference 'CLOloans' in a...

Hi Guys, Usually I can find answers by searching the site, but couldn't seem to find an answer to this one.. Any Ideas as to why this VB Code is resulting in the Clicked SaveAs action dumping the file into the "*******s" part of my File path rather than into "1 QUOTES" Which is where I need it...

Hello there, I hope you can help me with this, im pretty much a newb at this. I got 2 open Excel files, and I would like to press a button in 'Excel file 1' and then it saves the 'Excel file 2' with a name from a cell in 'Excel file 1' automatically (when pressing the button). Right now I use...

I'm trying to use a VBA macro to prefill the save dialogue box with the date, anytime ANY workbook is saved. The code (pasted below) is only working for the workbook containing the VBA code. I've tried inserting the code into my Personal Macro Workbook, and also saving and loading it as an...

I have been working with a simple macro that I have recreated several times. I normally put it into Thisworkbook or into its own Module for the file I'm working with. Each time I needed to check against a new manufacturer I exported my required information and retyped the macro. For Each r...

Hi, Hopefully somebody will be able to help me. I'm developing an excel addin using Visual Studio 2008. At the moment i'm trying to display a popup showing the value contained in cell A1. However, i'm getting a runtime error saying that xlWorkBook is null. I've been able to get this to work if...