opening

Hello I am trying to open and modify an Excel 2016 file using VBA in Access 2016. I pieced together the code below, but I keep getting "Compile Error: Sub or Function not defined" at the bolded section of the code below. Does anyone know how to correct this error or if there is a better code to...

Hi , I have inherited a large Excel spreadsheet (65 Mb) that crashes on opening with the single error code 400. It is believed that the file worked until the latest set of updates caused it to fall over. There are macros in the file, but there are none that run when the file is first...

Hi to all. I got a problem with my excel sheet, since today I haven't been able to open my excel document. Cause of I don't know the reason what happened yesterday. I was working some hours yesterday evening, and the file was valid. Today at opening, I see only blank screen in MS Excel. I'm...

Hi everybody! i need a macro that will hide all the sheets at the closing of the file, and it will unhide those hidden sheets at the opening. In particular, i want to protect all my sheets with a password, and the macro should auto-insert the password (that could even be the same password) at...

I am having a problem opening a SharePoint folder (not a specific file in the folder) using VBA. I have searched Mr. Excel extensively and have found MANY suggestions to try using... FolderPath = "http://nexus/sites/.../MySharePointFolder" Shell "explorer.exe " & FolderPath, vbNormalFocus...

This is embarrassing... I have a modified ridiculously large spreadsheet that someone else built pulling data from all sorts of weird locations. i did not save a backup copy.... now the file will not open and get's stuck at the filling cells part of opening. i wonder if there is a way for...

Hello everyone, I am trying to execute a macro from another workbook after opening it with Workbook.open. The macro works fine when I execute it after opening the workbook manually but whenever I open it from another workbook, I become the following error: "VBA Runtime Error 1004...

Hi all I have a workbook, where when opened, I need to log the user, date and time of opening, and then save the event. The event is written to a sheet hidden from the user named "User_Data" Simple 2 lines of code to achieve this:- Sub Workbook_Open() Sheets("User_Date").Range("A"...

Hello, I am really new with programming and this is my first job with VBA, I hope somebody can help me, because I cannot find solution for some days.. :/ In my excel are more sheets and each has 1 table objects - after opening the workbook, the macro set of its visible to false and show...

For the past decade plus, the way Excel worked for me anyway, every time you double clicked to open an Excel doc in windows explorer, if you already had another Excel doc open, it would load the new one you clicked on in the same process. Now there seems to be little rhyme or reason. Sometimes...

Hello, This is a spreadsheet I've been using for some time now and the embedded file was working. Today I'm having trouble opening the file. When I click on the file it's selected as though I want to copy of move the file to another location. Thanks bell1958

Is it possible to have a messagebox on pop up with text entry, i.e.on opening the spreadsheet it asks the user to enter their name. When they press ok, then depending on that was entered a specific message box appears, ie Opening MsgBox - "Please Enter Your Name..." (User enters "surkdidat")...

Hi, All... I'm running Office2016. When opening and closing a file that was saved in an earlier version of Excel (Office2007), I get a message of: Do you want to save the changes to 'File Name.xls'? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of...

hi all with excel when i used to have a file open and i downloaded a file on internet and opened that it would open a new workbook on the excel open. now though when i open these files it loads a new excel. is there a setting to change this back? thanks gemma

Hello everybody. I've to manage automatically the following pop up. The file you are trying to open, ‘XXX.xls’ is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the...

Hi! :-) My colleague has a problem with opening an Excel vba project. It only opens like the blue/green screen in Excel, you know, before you see the Excel workbook. However other colleagues can open the same project on the same computer. Why can't she?? Thanks!!!

Hi Sure this is a simple one . I have a workbook that is used by multiple users , It updates every 10 mins with data from another source . User have a habit of opening it and leaving it open , How can I close and save the workbook after a specified time , say half an hour

Hello I have exported some data from Magento into Excel and would like some advice on how best to tackle this problem. I have a field that lists supplier details - there are huge differences in what the field contains - there may be one contact, there may be several, some have opening hours in...

I'm running a bit of code to open all the *.xlsx files in the same folder as the *.xlsm file. But I keep getting the window that says: We can't update some of the links in your workbook right now. You can continue without updating their values, or edit the links you think are wrong. Here's the...

Hi all, I'm using a register where i want to have a messagebox upon opening the document which gives information about rows with expiring dates, but there are some rules i want to implement and i can't seem to find something working. The macro has to check the following: if the status in...