Home >

vba 2147417851 open workbooks

Advertisement
  • VBA: Track when workbook was refreshed (F9) through time stampJanuary 20

    Still quite new to VBA, so sorry if the question is stupid. I try to track the actuality of my worksheets and the references, with which my workbook is interlinked. For that, I use a code to get the time, when a sheet was refreshed the last time (by

  • how to close a workbook using vba from another workbookFebruary 1

    I had opened a second workbook when user clicks new workbook command button in userform, the problem is when user clicks logout button on this userform the newly created workbook should be closed.how to achive this?? --------------Solutions----------

  • Excel VBA to Work Across WorkbooksJanuary 25

    I am very new to VBA coding and don't have very good understanding of what I am doing to be honest. But here I go. I am looking to see if: Can VBA codes have dyname values? So instead of the code saying execute on a set sheet (e.g "Sheet1") that

  • How can I set Excel to always import all columns of CSV files as Text?

    How can I set Excel to always import all columns of CSV files as Text?July 5

    Though I try to avoid it, I occasionally have to open a CSV file in Excel. When I do, it formats columns containing numbers, which makes them useless for my purposes. As far as I can tell, the only way to prevent this from happening on import is to r

  • How do I install an Excel add-in?

    How do I install an Excel add-in? July 5

    Though I try to avoid it, I occasionally have to open a CSV file in Excel. When I do, it formats columns containing numbers, which makes them useless for my purposes. As far as I can tell, the only way to prevent this from happening on import is to r

  • MS Excel 2010 - Unprotect Grouping ControlsFebruary 24

    I have an Microsoft Excel 2010 spreadsheet that I want to share with my team on a read-only basis; I want to prevent them from modifying it, so that I keep control of changes. It's quite large, and I've grouped detail columns up, so that they can be

  • How do you write an Excel formula that will paste a specific value in a different cell?May 31

    So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the formula to exist in the cell I want to paste a va

  • I need help writing a macro that will check a condition, and then paste a value into a different cell May 31

    So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the formula to exist in the cell I want to paste a va

  • Remove duplicate entries in one cellSeptember 11

    I have data imported from a literature database (.txt format) into Excel. Unfortunately, in most cases, the authors are listed double in one cell, e.g.: Smith, Miller, Patty, Smith, Patty, Miller As you can see, the order of the names changes as well

  • Automatically save attachments from mail on a network driveNovember 5

    Every morning I receive an automatically generated e-mail from a server, it includes a spreadsheet attachment. I made a rule in outlook that captures these emails. Now, I would like to make a macro to rename the attached file (. Xls) to =today() and

  • Compare two columns in two sheetsJanuary 23

    I have another question, even though the last one i asked is still pending. I have a large data of over 100,000 records. I am using the code below to loop through the data so that any duplicate record will have the background colour turned to red. Th

  • Representing Specific Data from a Dynamic Database (Array) in ExcelMay 1

    I have a "database" in one sheet of an excel workbook. Specifically I have roughly 130 columns, each of which contains a unique value for each row. I.E. each row contains an "entry", with the different quantities of that entry recorded

  • Excel update pop up, what is the root cause

    Excel update pop up, what is the root causeOctober 14

    Recently when I open my XLSM files (Excel 2013, Macro enabled workbooks) I see this popup. Can anyone please tell me what is the cause for this pop up? I am not referring to any URLs using VBA in my workbook. --------------Solutions------------- When

  • Printing an Excel spreadsheet created by someone else even if saved with a different filenameMay 15

    Why can I not print an Excel spreadsheet (in Excel 2013) created by someone else even if I have saved it with a different filename? --------------Solutions------------- The only time I have ever seen this is when someone used a piece of VBA to block

  • Different Excel notifications on opening very similar files

    Different Excel notifications on opening very similar filesNovember 19

    Template files were prepared and sent to users. The files are essentially identical (both have identical VBA code, the same passwords on VBA, sheets and workbook structure), but it's evident that one user changed the file somehow so that now I am una

  • Count rows starting in the middle of worksheet

    Count rows starting in the middle of worksheetJanuary 27

    I have a question about the cell count in vba for excell workbook. I am trying to write down text selected in combobox to a proper row (row 26 in the picture) in excel with changing it if it is full (move to next row) till row 32. If it reaches row 3

  • Can I make an Excel VBA macro available to all workbooks?September 25

    Is it possible to write a VBA script in one workbook, and use it in other workbooks in the machine? I guess I'm looking for a way to write a macro package. EDIT Following the instruction in the link given by Lance, I managed to create the addin, but

  • Excel Workbooks and VBAOctober 21

    I have an Excel workbook that I need to put some VBA code into. Unfortunately, our security policies are to disable macros with notification. However, when I put the code into the Workbook_Open() event, it isn't triggered when I tell it to enable the

  • "The visual basic for applications (vba) macros in this workbook are corrupted and have been deleted"January 17

    Recently, I found an Excel 2007 Macro Enable Spreadsheet are keep getting the following error message: The visual basic for applications (VBA) macros for this workbook are corrupted and has been deleted. The macros corruption most likely exists in th

  • Recovering VBA modules from corrupt Excel workbookOctober 10

    I have a workbook that suddenly got corrupted. I am trying to recover the VBA code from it. I can open the workbook in Protected View by opening a blank Excel instance and then using Excel to open the workbook, but when I click "Enable Editing"

Copyright (C) 2018 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 11 q. 0.382 s.