dest

  1. G

    How do I break links

    Hi I have part of a macro shown below that moves files into a new subfolder that ive created in a folder called backup. It saves the workbook as NEWSUMMARY1.XLS no problem but im then trying to break the links after the file moved. Any Ideas? Sub PERIODEND() Dim sName As Variant...
  2. G

    Macro has a compile error and cant work out why

    Hi I have the following macro and keep getting a compile error. Any Ideas? Sub test() Dim sName As Variant, bFolder As String, dest As String sName = InputBox("Subfolder name") If sName = "" Then Exit Sub bFolder = "X:\backup" If Dir(bFolder & "" & sName...
  3. D

    Linking connectors by a larger connector

    Hi all, I'm trying to find the lines of code to link the little connectors to a single one. Here is what I have currently, where the cells above represent the items b of a listbox 2, with a connector for each item, then below there is a cell that contain the value of a textbox. Currently...
  4. W

    Column width in VBA

    Hi I have a VBA script were a range of cells are saved in a new xlsx file. The VBA script works fine on only one thing. How do I save also the column width and row height from the original file to the saved file? At this moment I have this script: Option Explicit Sub SaveXLSX() Dim...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top