open

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

Good EveningEveryone :), I would like to create an AutoOpen sub that automatically opens up to a specific worksheet based upon the current month. For example, we are currently in October, so I'd like it to open up toWorksheets(4). If its November, I'd like it to open up to Worksheets(5). If...

Hi all, I'm looking some help with referencing a combo box in a outlook form. I have a total of 4 pages/tabs, the first is where the user will select from a combo box and depending on which option is selected this will navigate the user to the correct page. I've never used vba in a outlook form...

Hello, I am looking for a code to pull data (a whole row) from sheet 4 to sheet 1 based on a criteria. Sheet one should only show the entries that show status as open. This status is in the last column M of sheet 4. Data starts from A20 and should look for the open entries in the sheet 4 where...

I have a wb with a drop down menu that correctly references an external wb to get the list but the external wb needs to be open to do so. It is going to be used by more than one person and will be stored on a server. Is there a way to have the external wb open when the cell with the list is...

A friend sent me a file to open for him. The file extension has now become like this: Book1.docx.nakw From his end, he inserted a flash drive into his system and all his files got the new strange file extensions. I have come across such situations, mostly when I send an unzipped workbook...

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

I was wandering if someone could help me edit the code below to open the pdf in the file that has the letters GGS in the file name? Public Sub openJOBLIST() Dim path As String Dim PDFfile As String path = "\\hq\dfsdata\Data\UserHomes\jamey.eerson\My Documents\pdf-NEW\Latest...

Hi - Could someone please give me bit of assistance, I am trying to get an excel document to auto resize to different monitor/screen sizes so bosses do not have to scroll around document. I have tried the code below but does not work (also not sure if putting in the right place, fairly new to...

Hi Gang, I have a excel sheet that opens with a message box. The sheet is a template and is used to create other sheets with different variables. My question is this how do I have this box open whilst the sheets name is "Auto Blank feed sheet" and not open when the sheet has a different name...

Hi all, Weird question, but i love the ctrl + open bracket trick to take you to where the formula is happening, but is there a way to get back to the original cell? It can get tedious to have to trudge through several sheets or rows, especially if you are working with large file. Thanks so much!

Hello Friends, Is it possible to Open a file only for specific computers. A VBA code for let’s say 3 MAC Addresses is linked with Workbook Open Event & the file should open for those 3 computers who’s MAC Addresses are there in the code - otherwise a msg box should prompt saying that you are...

Hello People, I'm trying to figure out a code which perform this : clicking on a image to open a certain form. I tried using this DoCmd.OpenForm "NameOfForm", , , "Image1=" & Image where Image 1 is the name of the image that i want to click on to open the form. any ideas ?

Hi, I'm trying to figure out a formula that has a number of parts. Let's say that we have columns A, B and C. Column A will contain either a date, or be a blank cell. B will contain "Accepted", or a blank cell. I want Column C to return either "Open", "Approved", or be blank, depending on...

Hello, I want to create a command button in my excel find to find necessary values in an external excel file. as in many programs, I would like to click on the open file option and select the target file with the windows search interface. as an example I installed a page of a simple windows...

Hi Everyone, Hope you can help I want a macro that can open a sheet in a new window. Idealy it would do this. When macro is run open Sheet"PDF Views" in new window and if possible? place new window in middle of screen taking up about 75% of the screen make that screen not show any tabs or...

Hi I want to open a sort of Back-End-file (.xlsm-file) stored in MS Teams, edit some data and close the file with av macro from a Excel “master file”. But I can’t find out how to do it. Everything I do will open the BE-file as “read only”. Please help! I think it is the same if stored in...

I've got a list of Hyperlinks, that are all files on a sharepoint site. When I click on one, it opens Microsoft Edge and at the bottom asks if I want to open the file. When I click "Open", the file then opens in the appropriate desktop app. I'm wondering if there is a way around Microsoft Edge...

Hi all! When I open my excel book it takes forever to open due to poor coding on my part. I have a bunch of codes like the below code. What I want is instead of E:E which I believe is why it takes so long to open I only want it to check cells in the actual table or until it hits a blank. I...

Can an XLSM GUI workbook opens its own instance when another instance exists? I've been researching this and found the link below here (at the forum) but I don't thinks this quite does what I hope I can do. The issue I think is that the macro will open an instance, but I still need to give a...