1. A

    My codes to open password protected workbook doesn't work

    Hi everyone, Below is my codes. It does try to open the file, but it keeps asking me for password although I already include the password in the codes. What have I got wrong? Sub openfile() Dim wb As Workbook Set wb = Workbooks.Open(FileName:="C:\...", Password:="password") End Sub...
  2. A

    Application.Ontime switching workbooks

    This is a continuation of a post that is now buried. Application.OnTime continuously opening my workbook The Code @AlphaFrog helped with is working perfectly. Each instance of save, the workbook comes to the foreground and then to the background again after the save is completed. While this is...
  3. P

    Workbooks.Open in VBA - Getting Password Popup Window

    I have the below code, which I will use to open a file. I will then gather data about the file and report back in a master workbook. My issue comes when I am trying to open a file which has a password: The first Workbooks.Open method presents me with a pop-up window, which I expect, although I...
  4. S


    How to open a xla file easily?
  5. R

    Opening Hidden Columns in Excel Sheet

    I tried to open an old Excel sheet, and columns A through AM were hidden. I cannot open the hidden columns by using the Unhide action (highlighting the entire sheet). Any suggestions that would enable me to open these hidden columns would be appreciated. Thanks.
  6. S

    how to get a worksheet to update without opening another workbook and without using vba

    Hi All, 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...
  7. S

    Slight alteration to VBA code for renaming sheets

    Hi - hoping someone better than me can help with a slight adjustment to the below code. I think its easy for someone with the skills. So it currently opens all the files in a picked folder and renames the sheet to Sheet1, so long as there's only one sheet. Problem is I have a combination of...
  8. L

    log date when the file is open

    Hi I want to log the date that a file is opened. For example, If I open the file today and I entered case#2 then the date should be today date in date column but if I open this file tomorrow for case#3 then tomorrow date should be in date column at the same time case #1 and 2 date should not...
  9. S

    Open Another Application by Excel with VBA

    Signal is generated in Excel Either Buy or Sell. The Vba should Open the Another Application Perform Functions Like enter amount, name,.....From Excel Only then Submit and Close. Wait for next Signal and Repeat the same Process Again.:)
  10. S

    VBA to copy/paste data from already open chrome web page

    Hi, I have been searching with no luck to find a solution to copying/pasting data from an open chrome web page. I have chrome web page open (the web page has a title, so hoping to use the title). On the page there are columns with headers and columns of data. I'd like to select certain columns...
  11. V

    Vba macro to open workbook and then activate the workbook from which the macro wss started

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

    VBA AutoOpen sub to worksheet # based upon the current month

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

    Using VBA in outlook form

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

    VBA Code to pull data from one sheet to another in excel

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

    Can you open an external wb, retrieve a drop down menu then close it

    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...
  16. kelly mort

    ENC file problem- don't know how to open it

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

    Open userform when worksheet opens advice

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

    VBA: Open PDF with GGS in filename

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

    Auto Resize to fit different monitor sizes

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

    Opening a Message based on file name

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back