opened

Hi, I have clicked on the SaveAs method word in some code in the Visual Basic Editor and would like to see all of the associated File Format types. After pressing F1 I expected to get context sensitive help but instead a new web browser for Visual Studio 2012 opened which doesn't seem to be...

I have a workbook that recognizes (through the registry) the first time it's been opened, generates its own folders and directories during that first time being opened, and a number of other things. I'd like a macro that basically will allow the user to drag to receive the workbook via email...

Hi Everyone, OK So heres what I need, I need two macros, 1 when the document is opened it creates a new document in the same folder called "Used" When the document is closed it deletes the docment called "Used" how can I do this. Thanks Tony

I have 2 date columns, "Opened" and "Closed". I would like a formula as part of my query that would say "If Closed is null, subtract today's date from Opened. Otherwise, subtract Closed from Opened." Any help in doing this? I am a complete Power Query noob! :(

Hello I wrote the code below to activate the second workbook. The code below is work if both workbooks 1, 2 are opened. I minimized workbooks(2) (put it in taskbar) and ran the code below, excel did not try to open workbooks(2)? It did stay in task bar (not opened), why is that? Thank you...

Hi, I currently have a workbook that when opened updates a Notepad with the users name, date & time opened. using the below code... Private Sub Workbook_Open() Sheets("Select Handler").Select Open "myfilelcation.log" For Append As #1 Print #1 , Application.UserName, Now Close #1 End...

dear all, could you please help me to correctly perform the following code: Private Sub CommandButton1_Click() If Range("E2").Value = "1" Then Rows("50:102").EntireRow.Hidden = True End If If Range("E2").Value = "2" Then Rows("32:105").EntireRow.Hidden = False End If If...

I have been requested to make changes to an existing database to monitor a field on a form. Access to our forms in our database is based off a windows user id script that runs when the database is opened. Now my boss is wanting to know when someone changes a value within a certain box on a...

I don't understand why it does that, I have a userform which inputs invoices into a table when I try to enter the invoice number (for example, 312650370010022819) it enters a changed number to the cell! (changes the example to 312650370010022000) Then I also have a feature in the initilize...

The macro below is copied from a Windows VBA tutorial. Doesn't work on my Mac. Can anyone sort out the syntax problem? It should open a dialogue box to locate the file that should be opened. I want to open a second workbook when a first WB is opened. Thanks. Sub...

Hi, I have a problem when trying to refresh Queries. I created a file, which needs some data from other files, so created a few Queries. Everything was working fine until now, when I started getting the error: [DataFormat.Error]|ErrorInfo.GetDescription failed with E_FAIL90x800004005). or...

Hi all, I have an excel file which could not be opened anymore from one day to next. The loading bar usually stops at ~80% and then excel freezes and is not responding anymore (according to task manager). CPU workload and memory usage are both below 15%, respectively. Using excel online, the...

Hi there I have 2 workbooks opened at the same time. Lets call them workbook1 and worbook2. I have workbook1 opened and I recorded a macro. In workbook1 I copy the range A2:H158 into workbook2 Here is a partial recorded code Range("A2:H158").Select Selection.Copy...

Hi All, I have two columns of dates. One is support tickets opened one is support tickets closed. Each date entry on a new row represents a ticket. When I try to put a pivot chart together the opened and closed per month figure is coming out the same which it shouldn't be. What I would like...

Hi all, I am trying to put together a macro but can not make it work. I've looked online and tried many codes that I've found but unfortunately couldn't make them work. Maybe you will be able to help and explain how it should look like. I will not paste any code here as basically I've used...

I have a text box that I want to have the values removed when the spreadsheet is opened. What is wrong with this code? Sheets("Home").ListObjects("txtActivities") = ""

hi all i have this VBA code: Dim wbk As Workbook Dim wbk2 As Workbook Set wbk2 = Workbooks.Open(Filename:=F2) Set wbk = Workbooks.Open(Filename:=F1) of course F1 and F2 is a Correct filenames with path..... My question is how to know if workbook: wbk is already opened? (for not...

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...

HI there I believe that is easily solved. All I want is an easy macro to do following. Any help would be appreciated. I have a workbook that is stored in "C:\users\Documents\my name\ Book1" This workbook is not opened I have an open workbook that I want to store the macro. So what the...

Hello, I need a help. I have an excel sheet with hyperlink pathes in Column A. (e.g.:A2, A3...etc.) My purpose is to open each of them, so loop through and when opened one check the opened one's sheet (1).Range("BP3").Value and paste it back to orginal excel sheet, just next to the path...