workbook

Greetings, 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 Debug.Print hl.Address...

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...

Hello, I found a code online that is very useful for one of my purposes but it is throwing a Mismatch error when I am attempting to use it. The code is placed in 'ThisWorkbook' to start calculating the time someone is in a workbook- to eventually kick them out automatically (with a different...

Has anyone written a script that would save the 4 sheets of a workbook as a 4 page PDF and then email that PDF to a specific address from my gmail address? Ideally I would like that PDF file to have today's date in the name.

Hi, I am creating a summary sheet book with hyperlink icon or hyperlink formula to the another workbook “datasheet“ however i found the below issues. 1. For the right click and create hyperlink, it is easy to do but when I save as the summary sheet workbook and the another workbook "datasheet"...

Fluff very kindly posted the following code to enable the automation of advanced filtering from one worksheet to another in the same workbook for variable criteria without having to reinput the criteria each time. But how would this be done from another workbook? The data is in a workbook...

Hi All, I am using below code to save the current file in another location and also want a pop up message if user want to save a copy of file or not ? but every time I am closing the workbook the message box pop up twice. Can anybody help me out what mistake I am doing ? Private Sub...

My company has completely locked down the C drive of my new laptop. I cannot copy my macro workbook to XLSTART. Is there any way to change the location of the XLSTART folder?

All, I developed a process for a small data set and it now needs to scale to cover large data grabs from outside of the workbook (in closed workbooks on a drive) then have the macro deposit the output into new workbooks in a different file folder (currently my code drops the new workbooks into...

Hi, I want to send an Outlook email from my workbook with: 1. a PDF attached = from one workbook sheet called "DbD Month". 2. a picture of a table in a range in the sheet called "Pickup". The current challenges are: 1. My current Macro pastes the "pickup" table in the Body but the size is...

I am trying to use a macro across a number of worksheets in a workbook I am not very good at writing VBA so just record it but from some reason the macro just references the one sheet how do I change it so that it doesnt just look for the same sheet all the time? Also the number of rows varies...

is there a way to dynamically change the workbook name in a Formula vba statement? I'm looping thru multiple workbooks based on the filename found in the directory and each passthru of the macro would have to reflect the workbook just opened. first pass workbook name is "Servers with...

Hi, Thanks for looking at my question. I am working in Excel 2016. I want to look up a specific cell value from among a range of worksheets (in the same workbook) and have it return the worksheet name the value is found on. The sample page from the workbook is in the link below, i tried to...

Hi, For now, I go to print, select entire workbook, choose double sided, next page, rinse and repeat. The problem is I have 50 pages to do, is there a way to print the entire workbook double sided automatically? Thanks.

Good day to all, As I’m fairly new in VBA.. Appreciate if you could help me on this! So I have this excel workbook with a set of raw data (workbook1) which i wanna automate to import/copy&paste the data to another workbook (to open workbook2 with dialogbox). Eg: Cell (A1:J1) (Workbook1) copy...

I don't know if anyone out there has experienced the error message when opening an Excel workbook. I have a workbook with 37 worksheets. A few of them have Tables, not Pivot Tables but regular Tables with drop down arrows. I also have many macros and most of them create the Tables for me...

I am trying to copy two worksheets to a new workbook and rename/save that new workbook. When I copy the worksheets over - the queries are copying with it...which is causing issues when I try to save the new workbook. To get around this, I am having to delete the queries / connections...then...

Afternoon, I would like the userform to open when i open the workbook. At present i have the following which works fine when i navigate worksheet to worksheet but need some advice please for it to run when i open the workbook. Private Sub Worksheet_Activate() If Range("A2") = "" Then...