1. P

    Private function not working

    I have this private function before closing a workbook: Private Sub Workbook_BeforeClose(Cancel As Boolean) Call SO End Sub Sub SO() Worksheets("setUp").Unprotect Password:="xcxcxcxc" Sheets("setUp").Visible = True If Range("NOP").Value < Now Then Range("NOC").Value = Now Else...
  2. Nelson78

    Vba: IE, closing a tab

    Hello everybody. I'm navigating a web site. I'm stuck with this (I've to close a tab): a id="zdres" class="closetab" on click="return false;"></a> The id always changes. It seems to be the only a and the only class="closetab" in the page. Any suggestions?
  3. W

    VBA to close windows explorer window

    Hi! I need to open windows explorer to access a file, and it would be nice to have a macro in that file to automatically close the explorer window (This is not Internet-explorer!) I found plenty of macros to open explorer windows (Shell) but none wich will work to close it. The path to the...
  4. D

    How to stop closing all workbook after hitting X sign on top right corner.

    I have two Excel file, the first one has no macro on it and the second one has a macro on it. First, i open the spreadsheet which has no macro on it. Then I open the second excel which has a macro on it. Now if I hit the X sign on the top right corner to close my first spreadsheet then it closes...
  5. H

    Scrape CCY previous closing from marketwatch using VBA

    Anyone has any idea how can I use vba to scrape the previous closing rate of a list of currencies to excel? <tbody> AUDUSD USDCAD USDCHF EURUSD GBPUSD USDJPY NZDUSD USDCNH </tbody> For example, if I want to check the previous closing of AUDUSD, I would need to go to the...
  6. M

    Expanded rows not saving?

    Hey guys, I just received this sheet and after widening the rows to see all text and clicking save as, closing then reopening it still shows as attached, help please?
  7. S

    Modeling inventory/stock without using circular references

    Hey guys, How are you doing? I'm preparing a financial model for my new importation business. I'm specifically having an issue with the inventory aspect of the model. My closing inventory is a sum of my opening inventory+additions of inventory in the year - sales of inventory in the year...
  8. G

    Difficult Array Formula

    Can anyone help me sort out a problem with an array formula? I get the following pop-up error message when I hit the Ctrl-Shift-Enter keys: "The formula is missing an opening or closing parenthesis." The array equation is as follows: =IFERROR(INDEX($C$3:$C$200...
  9. J

    Help needed, Workbook needs repair on every open

    Hi, appreciate any help with this: every time i open i get this: The workbook and all macros work fine, but after saving and closing, when i reopen i get same error I dont have a sheet4 any way to remove this error permanently? thanks
  10. S

    Days supply in excel - formula

    Hi, Need advise from the experts in this forum. Data is below <colgroup><col><col span="10"></colgroup><tbody> W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 Forecast 10 20 20 10 10 20 10 20 10 10 Closing stock 40 20 40 20 20 20 10 40 10 10 Week supply 2 1 3 1.5 1 1.5 0.5 </tbody> I would...
  11. M

    Excel log

    Hi all, I was wondering if there is any way to create a simple log in excel, that logs the date and time of opening and closing of Office files? Do any of you guys have any idea on how to do that? Thank you in advance Best regards
  12. Dougie1

    Clear Sheet1 on closing Workbook

    Good Morning All, After some help here if possible. Using Excel 2016. I have data on Sheet1 (sheet is actually named “Master Data Sheet”). What I would like to do is clear this sheet on closing the Workbook – except for Row A – which I would like to remain as it contains Header data. Can...
  13. R

    Error in getopenfilename when closing without choosing a file

    Hello, I have the following code in a module and works fine, the problem is when the user closes the window without choosing any file the macro crashes and displays error 1004, I tried some codes from the forum but nothing worked. Filename = Application.GetOpenFilename _ (FileFilter:=Filt...
  14. K

    Disabling the "want to save your changes?" dialogue box when closing out of Excel

    I have a workbook that is stored as read only on a SharePoint site. Users are unable to save the document (save as is allowed), but when closing out of the document, the dialogue box still shows saying "Want to save your changes to [file name]" with options of "save" "don't save" and "cancel"...
  15. J

    Workbook won't close ! (when others are still open)

    I tried to solve this question earlier but no answer helped me yet. I got a macro enabled workbook, with scripts while opening and others. Everything works fine except that it can not be closed while other excel files are open. Those have to be closed manually before closing the macro enabled...
  16. J

    Problem after Hiding Excel Workbook behind a VBA UserForm

    Sorry its a long post..... Hi All, I'm having a few problems with a UserForm I'm trying to create. This userform runs, with the excel sheet it is running from hidden behind. Below I have summarised the form itself, the problem I have encountered and solutions I have already tried. Any input...
  17. W

    Excel Crashing (Microsoft Office Excel has encountered a problem... etc)

    I have created a program in Excel (2007) to do some pretty simple things, which works quite well. When I do a Save or Save As, the file saves, but when I go to actually close the file, I get the Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the...

Some videos you may like

This Week's Hot Topics