workbooks

Can someone help me find an Excel VBA solution to step through my open workbooks to find the one with a name (always) formatted as "mmm-dd (ddd) Data.xlsx", and return the name of that file? I have 3 open workbooks and I need to find the file name of the one, for example, named "Jun-24 (Mon)...

Can someone help with a macro to consolidate data from several workbooks into one workbook. I recorded a macro by copying and pasting the data from their workbooks into the required worksheet in the new workbook. But my mind is saying that there is another way to do this; is there?

hello all, I have a template and a workbook with a list of names. I need a macro to use the template to create workbooks named from the list of names in another workbook. Template name= v4 Template List of names workbook= Roster (on data tab) Thanks in advance Rod

I have a folder with many excel workbooks containing the same set of sheets with in them. In few of them in sheet1 & cell B10 i need to insert text "NO". The few workbooks where i need to do this is separately provided in a list. I need a macro coding were it picks Workbook name from the list...

While working on a spreadsheet at work, I was getting the error "method open of object workbooks failed", but when I got home, the same file was not giving me any errors. Any ideas why?

on excel 365 how do I share a wb so several ppl can view it at the same time?

Hi No one talk about "Workbooks.close" --> collection leve<collection level="">. I did google search and they are all talking about "Workbooks("name").close" <-- workbook level<workbook level=""> The code below, will close the first workbook no matter how many workbooks are open. My questions...

Newer to macro/VBA... Need a macro to pull data from "Log" sheet from all workbooks in a specific folder

So I was trying eliminate the need to link two cells from separate workbooks because both workbooks are password protected and its an issue to have to enter both of the passsword everytime i open the single workbook. So i was trying to make a button or even perhaps a constantly running macro...

Greeting Everyone, Long time lurker, first time poster. Thought I'd reach out for once. I understand VBA okay enough to figure out most issues on my own. I'm not a beginner, but I would't say I'm at a solid intermediate level either. I’m having trouble finding good code examples for this...

Hi all, I am updating around 90 workbooks for year end by adding an extra named range to an existing formula I will be doing this by looping through all of the workbooks to add the 18/19 spend in year to 15/16 16/17 17/18 Range("HRPreviousYearsSpend").Select ActiveCell.Replace...

hi all i need to combine multiple workbooks with password into one, but while someone is opening one of it, it shows error, i would wanna know how to fix it, thanks:rofl:

Is there a way to have an add-in module deactivated for one workbook, but still active for all other workbooks? The only way I know of to deactivate an add-in is File | Options | Add-Ins | Manage | uncheck the add-in in the list. This procedure causes that add-in to unchecked for all workbooks...

i have multiple workbooks with same type of data. i want all this workbook to be consolidated to one workbook.

I have written code to close all workbooks except the current workbook where I run the macro The Macro closes all the workbooks, but I want to suppress all messages including any message box that pops up in the workbook to be closed Sub CloseOtherWorkbooks() With Application...

Hi, I have a bunch of workbooks, now I want a extra sheet copied in all my existing workbooks. Is that possible via VBA?:confused::confused: Appreciate the help..;)

Hi VBA Community, Need your Help..!! I have more than 20 workbooks which contain data in multiple sheets. I need to copy only data from Sheet 2 from all workbooks to my Master Workbook. In addition I need pop up to select the files path to copy data to Master Workbook.

Is there a way to embed multiple workbooks each with their multiple sheets into one workbooks where the tabs would correspond to the inserted workbooks. Clicking a tab in this workbook would open up a workbook and not just a sheet. Seems very handy and general purpose. Joe

Hi I want to ask user to enter workbook number to close and then close that workbook accordingly. So I wrote the code below, but did not run. Any help would be appreciated. Thank you. Sub mywb2() Dim x As Integer x = InputBox("which workbook") "workbooks" &x.close End Sub