open

One of my regular (almost daily) excel (.xls) files will not open today. I get this message: "Sorry, we couldn't find D:\Daves Data\....blah.xls. Is it possible it was moved, renamed or deleted? When I ran CHKDSK the result for the file in question says that "first allocation unit is not valid...

what is a correct way to access a open workbook.sheet that is currently open when linking to a subroutine or a function? ie.. i open two workbooks in the main routine and the based on a condition in the main routine i link to a subroutine. I can't figure out how to read a value on the open...

Hi, Is it possible with VBA to open a new window (specific worksheet) maximized on to the 2nd monitor with no gridlines?

I've been running the same macro-enabled spreadsheet almost daily for years...well, this one happens to grab NHL stats. I'm using Office 365. Last night I had run a different spreadsheet using the fuzzyvlookup function that's been posted here for years, copying a formula down some 2500 rows...

I would like to open two windows folders on the screen and have them appear side by side on the monitor. I have the code below to open both folders and that part works fine. I just need to know how to size them and move one to the left side of the screen and one to the right side of the screen...

Can you close one form from another? I know you can close the form you're on by using DoCmd.Close , "". How do I close another form. I need to make sure its not open when I run code. Thanks

Hello, I know that I can open a drop down list with Alt-Down arrow, but I can't navigate the list by pressing a the first letter of an item in my list when it is open -- When the list is open and I press S, nothing happens. What am I doing wrong or a parameter to add? Thanks in advance for...

I've got 2 files, one with a sheet linked to the other so that they are the same sheet. The sheet linking to the other one is "Forecast - 8 - Output - 2020-23.xlsb" On sheet Constants, the formula in cell M22 is ='[Forecast - 1 - Assumptions - 2020-23.xlsb]Constants'!M22 That file is open. The...

Dear Experts, I've problems modifying below codes as they codes cannot finish to the end : 1. I've in folder many project files for current month and last month 2. Each file name has a standard format like 02015-201909-Flex*.xlsm (this month), and 02015-201908-Flex*.xlsm (last month), while *...

hello friends, i wish to do following steps with vba code 1. open an outlook application and then go to subfolder of inbox , open one email with perticular subject and then open csv file attached to it please help me with that rest thing i will manage as there is further process involved...

Hi Can I say workbooks.add is the same if you open Excel program -->New ? same thing workbooks.open is the same if you open excel program --> Open Also, workbooks.close is the same thing if you click on [x] to close Excel program? Thank you.

I'm attempting to use the BeforeClose event to open another workbook, gather data, and then place it into the original workbook. However, once the workbook is open, the code fails to manipulate it. The ribbon and tabs don't seem to be visible and when the code tries to activate the new...

Hi all, I have a userform that opens automatically and hides the workbook when I open the file. It all works perfect - and I have it as vbModeless in order that I can use excel for other things. Problem is, when I close the other workbooks, it also closes the userform and workbook that I want...

Good Afternoon, My question is related to an XLSM file that is shared on a network drive. I have built a Purchase Requisition form in vba that creates an auto-updated number. Currently when one user opens and starts to complete the form, another user can open and it would have the same...

Hello Friends, I am using the below code to open folder 1 Sub OpenFolder()Dim str_folder As String str_folder = "C:\Users\i ' M\Desktop\Folder 1" Call Shell("explorer.exe " & str_folder, vbNormalFocus) Copy End Sub I want to open folder 1 > copy all files from this folder to folder 2...

Hi, I have a set of .csv file with date time format in a specific folder. I have to open an excel workbook using a date and time picker with start and end date. What all steps should be carried out for this. Anyone...... please help....!!!!

Good day all I'm trying to add a clause to a formula. What I want is to check cell L2 and only if it finds the word "open" then run the following formula. Any help is greatly appreciated. TIA =IF(ISNUMBER(SEARCH("Not used",E2)),"",IF(TODAY()=E2,"Today",IF(TODAY()>E2,"Past...

I have an excel workbook with 2 views open (View/New Window). When I close the second window (the workbook remains open) it triggers the before close event. Is there anyway of closing the second window with triggering the before close event? I only want the before close event to trigger whe the...

Morning, My goal is when i open the workbook i should see INCOME (1) open & either show the userform or not depending on cell value in B1 What i see happening is if i was last on worksheet INCOME (3) then i save & close the workbook when i next open it the code runs BUT when i close the...

Hi - any idea how to vlookup or sumif or ... from multiple .csv files into one master file? The master and .csv files would be saved in the same location, and the filename of each .csv would be stored in a cell in the master file. The .csv files would not be open when the master is open (and...