I have the code below in a workbook. When I close the workbook, it typically kills all other open workbooks of excel. However, excel has started opening a blank window (no loaded workbook) in a second window whenever opening any excel file. Anybody have ideas on both of these. Further, sometimes...
I am working on a workbook that uses random numbers that loops until a certain condition is met; a specific number.
I am wanting to be able to count how many times the loop has to cycle until the number is calculated correctly. Essentially a counter of the cycles.
Any help is appreciated.
I am trying to create a macro that opens reference files and later will pull data out to compare in primary workbook (wkb).
wkb3 is going to be the previous days file in each case, and opening the file works without issue.
I am running into an issue referencing the Workbook...
I have an Userform which starts up when Workbook is open, and the workbook gets minimized.
Userform is show modeless so other open workbooks could be handled
Private Sub Workbook_Open()ActiveWindow.WindowState = xlMinimized
Workbooks("New BOM Maker Userform.xlsm").Activate...
I was wanting to see if there was away to add some code to my personal workbook so when I open and or save a workbook where the file path is more than 218 characters I will get a prompt telling me Ive exceeded the recommended character limit.
I have a workbook that pulls data from another workbook.
At present both workbooks have to be open for the data to pull through.
What I am wanting is a way to pull the data from 'workbook1' to 'workbook 2' without 'workbook 2' being open.
I cannot use vba as I also have another workbook...
I have created an add-in that functions perfectly except for one annoying thing.
The add-in creates a new workbook by copying the add-in's first sheet. This new workbook is then populated with data from an archived workbook that the add-in has opened. This works well and I can watch the data...
I have a program that generates between one to three reports for several different departments. It then is able to save the results as an excel workbook. I have written some VBA coding that I plan to use to formats these reports.
1) Is it possible for a script to “watch” a folder so that...
Anyone able to assist a newbie on VBA coding, please.
I have learned some great stuff reading comments and watching online videos, etc.
But, I have patched together some code from various excel experts to:
1. save the file and then email as an excel attachment (.xlsx)
I am using an Excel workbook with several tables to create a Power BI Metric package that publishes to an internal SharePoint site. The employee responsible for updating the Excel workbook is not capable (via access or skill) to refresh the Power BI dataset. How can I automatically get the Power...
Good morning, - as a Lotus 123 veteran (!) I still use a lot of keyboard shortcuts within Excel such as Alt+f (File) followed by c to close the active workbook.
Whilst these work most of the time, sometimes they don't and the above sequence will result in a "c" appearing in the active cell, and...
Dear Learned people
I have a macro that, when it has run through all the code saves the workbook with a different name using "Save As" .
I added a command button "Save & New" on a user-form in a certain position in the code.
I would like for the user to save the workbook (Save As) and then...
I've been googling a way to connect an existing workbook to a sharePoint list
I have a maro enbled workbook and I'd li to connect to 5 different SharePoint lists on different sheets in the workbook.S
I am running into an interesting scenario with a VBA add-in project. I have a macro that opens up an Excel file, does some stuff, then closes the file. I am running into an issue when this macro is run immediately after someone opens up a blank Excel workbook and has not made any changes to it...
Hi would it be feasible to be able to open a workbook then by running a macro import the first sheet from multiple workbooks book1 book2 book3 book4 book5 book6 book7 add them into the open workbook and rename them sheet 1 to 7
When Excel crashes my hyperlinks placed throughout the workbook break. I am trying to create a macro that will fix the paths of all the broken hyperlinks.
This is what I have:
Dim hl As Hyperlink
For Each hl In ActiveWorkbook.Hyperlinks
I was wandering if there a way to have a hyperlink to a specific cell in a workbook?
I email hyperlinks to excel workbooks thats on my network at work all the time but It would be nice if the link actually opened the workbook and went to a specific cell or row.
I have 1 macro that I use on different workbooks to pass data into a fixed workbook.
So I want to be able to open that fixed workbook and then run my copying macro from the changing workbooks. The problem is when I use vba to open the workbook it makes it the active one and the macro copies the...
Hi, I have multiple sheets that are protected for using the standard Protect Sheet (select locked cells and select unlocked cells both ticked) but when the workbook is opened it prompts the user to provide the password to unprotect for as many instances that there are locked sheets in the...