opening

Hey guys! I'm trying to get this COUNTIF function working properly to calculate how many of my employees I have closing on each day of the week. It already works properly for those who are OPENING each day, but I can't figure out what the issue is. All of my cells are formatted as TIME. My...

I know how to open a document. I want the VBA to allow the refresh upon opening to complete before saving and closing the workbook. Workbooks.Open Filename:="Folder Location"

Hi to all of you, I would like use a vba code so that to run through col. “F” and where the find the text like “Opening Balance” then to move the mentioned text from col. “F” 1 cell offset back in col. “E” and its numbers which are in col. “J” 2 cells offset back in col. “H” either positive or...

Hi, I have a several file that have a lot of formulas and worked fine before on another computer (older) and probably with a slightly older version of excel. When opening on my new laptop all of a sudden I'm getting circular reference error notices that I've not seen before and now my formulas...

How can I set Excel to open spreadsheets in separate windows when opening new/previously saved spreadsheets? Currently I have two work laptops, main laptop opens each spreadsheet into its own window. Alternate opens each spreadsheet into one window, main laptop is running Office 2013 alternate...

For some reason, my Excel 2016 (64bit Office Professional Plus) is acting funky- recently redownloaded (new SSD in computer) 1. Whenever I open a workbook, excel opens but there is no workbook loaded or spreadsheet for that matter- so once it's open I either have to open a new sheet or open a...

Hi I have macros that are shortcuts to books that numerous people use. I know how to record the macro to open the book but dont know what to add when its opening as a "READ ONLY" as in the message box warning it read only. Can anyone help?

Hello all, new to the forum. I have an issue with powerpivot/DAX that I have not been able to solve. I hope someone is up for the challenge... The problem is calculating a YTD monthly Inventory closing position while ignoring cumulative negatives if there is no stock to satisfy the forecast...

Can journal detail from 10 divisions in excel exceeding 100,000 lines each be exported into access, so that all data can be viewed in one database at one time instead of opening 10 different worksheets?

I'm automating the import of a particularly large CSV file. This file is generated by the user, and I want to validate that it is in the correct format (column order & names) before continuing the macro. Ideally, I'd like to read the header row from the file before committing to opening the...

I have used a SUMIFS function in workbook A to look up a value from a different workbook (workbook B) based on a three criteria. The formula works perfectly as long as the other workbook (B) is opened. When I close workbook A and reopen it with out opening workbook B, I get a "VALUE" until I...

Hi everyone, The subject pretty much explains the issue, but for more detail, I am using 365, and below are the variations. How can i make it so that all minimized windows STAY MINIMIZED when opening a new workbook?? ... This is so annoying!!!! If 1 workbook opened and minimized, then try...

When opening an .asc document, its not opening te normal way, but you can divide the text in different cells. But when I do this the values change, but why? <tbody> +8.0032788e+03 +7.9059053e+03 +7.8009893e+03 -8.9554429e-02 +3.3130959e-02 </tbody> These values change to...

Please could someone give me the code for opening up a userform upon opening an excel sheet. Userform is called MainUF1. Then i need to put in a username and password. Any help would be appreciated.

Hi all, I am currently in the process of trying to create a macro to run from my current workbook (file1) and be able to open an excel file from SharePoint (file2) to refresh and update using the data from (file1). The only problem I am running into so far is when opening (file2) it is...

Hello everybody. I have a folder. C:\Desktop\Monday This folder contains 1 or 2 workbooks in format .xls The workbook named "today.xls" is always there. Sometimes you can find another workbook named "today1234.xls" (figures following "today" could be different depending on not controllable...

Hi Can I do exactly the same as below (assign password to a file) without opening it? I do not want to open it. Is that possible? Thank you so much. Sub myopening() Dim x As Workbook Set x = Workbooks.Open("c:\testing.xlsx") x.Password = 123 End Sub

Hi I understand the code below, thanks for you help. but I am wondering if I can do the same without physically opening the file? is that possible? Sub openandpwd() Dim x As Workbook Set x = Application.Workbooks.Open("C:\abc.xlsx") x.Password = InputBox("enter pass") x.Close End Sub source...

Hello I know I can do this Set myworkbook = Application.Workbooks.Open("c:\abc.xlsx") So I want to assign abc to myworkbook without opening the file. Is that possible? Thank you so much.

Hello, I recently had a difficulty in creating links of formulas from one excel file to another. For example vlookup. When I use the started using the formula it does not connect the second file. After searching online, I should have opened the excel files using the CTRL+O and not just...