opened

I’ve noticed that when some users are entering information into a form that the corresponding table cannot be opened until the other user has saved or exited the form. Is there a way around this? What causes this?

Hi, does anyone have a code that can go through a list of hyperlinks and check if they can be opened or not? Some may be corrupt which is the reason they cannot be opened. This is what I have so far but the error command doesn't seem to work. The aim is to delete the hyperlinks that cannot be...

is there a way to delete or restrict a file by using VBA code from a certain date when it's opened? I need to make users use a new file

Hello Team, I'm opening excel file from command prompt using below command: start excel.exe "D:\Temp\MyFile.xls" /e/%SR%-%CR% SR and CR are two arguments being passed. When Excel files open, I'm checking if it is being opened by command prompt or by user manually. This helps me decide if to...

I am using the following code to basically catch any workbooks opened while my main workbook is opened. And it converts it to read only then closes it and starts it under its own instance of excel. It helps to keep my workbook seperate from all other ones. The problem is if the workbook being...

I found the option to change the number, but nothing of the default order that seems to be alphabetical, can I change it to start with the most recently opened or most commonly opened listed first? Anything beyond pins? :eeek:

Noticing some issues lately; wondering if anyone else noticed. Previously, I could load a user form project, leave it up and running overnight (forget to close it) and arrive back the next day and still be able to use the form and it's controls. Now what I'm noticing, is when a period of time...

I thought this was working to give today's date when they updated the form, but then when they opened it =IF(OR($E24<>"",$F24<>0),NOW(),"")

Hi, I'm looking for some code that will take a screen dump of an IE window that is already open and copy it to the clipboard. So, the code mimics me moving from Excel to the IE window (that is already open and maximised), doing a printscreen/copying the whole page, and then pasting it into the...

Hi all, I did some research but it sound is not possible...so I wanted to be sure with the excel experts :). I have a file in excel and I would like it can be opened automatically when I start the computer (first if this is possible) with a VBA, then it is better if this file can be opened...

How can I tell when an excel file was opened and closed and the session time?

Hi All, Anyone here can help on a VBA script to copy 1st and 2nd sheet from a closed workbook to currently opened workbook overwriting and contents of sheet 2 and 3? The 1st and 2nd sheet names of the closed workbook changes dynamically so please don't rely on the sheet1 and sheet2 names. The...

I have 4 to 6 workbooks opened in which there are sheets , the sheet names have no duplicates names across the workbook opened . I looking a macro that copy all sheets in the opened workbook to current book . The current workbook has only one sheet named master1. I got some similarities...

I am researching currently if I can Open Excel without having any excel Opened. Is there something in Windows that can trigger excel opening, like can i press two keys together to get the excel opened which i want ? Not sure If this can be done:confused::confused::confused::confused:

I have a column, which I enter in a percentage (formatted that way) if I add 100, it used to appear as 100% which is how I want it, now though for some reason it shows as 10000%, this has only happened recently and seems to be happening to all workbooks opened on this PC which makes me think a...

Hi All Please can you help me the best possible way to ensure I capture this I have a workbook that I send out via email to people. In this workbook, in the workbook open code, I keep a log and update another excel file with the userid and timestamp regardless of whether the workbook I sent is...

My module opens a xlsx workbook that can be updated. I want to disable the Close X on the opened workbook so the user must use a userform to close & save the opened workbook. How do I disable the X on the opened workbook from my original module?

- If I open a .xlam file, I can modify it and save it without a problem (from VB Editor window and File-Save) - But if I have a regular .xlsx opened too, and go to the VB Editor, the File-Save does not save my .xlam file. If I try (or simply clicking on the save icon) the screen flashes but...

Hi, I would like to auto-run a macro when Excel is opened and cell C4 contains the word "pallet". I have tried to put this macro in the PERSONAL.XLSB directory and then in "This workbook", however the Macro starts before the spreadsheet is opened.. I did this with a Private Sub Workbook_Open()...

Hi all, I recently discovered EnableCalulation T/F option and thought my issues were solved. The 2 issues I have is that EnableCalculation defaults to True when the workbook is opened and the Calculate Sheet option doesn't work when EnableCalculation is False. I need just 1 sheet in the workbook...