ext

  1. kelly mort

    Need help to fix Dir error (Run-Time error 5) - Invalid Procedure or argument call

    I have tried to add some pieces of codes together to produce this piece of algorithm for myself. When I run it and it does not kill nor move any file, then it reports the error message, Run-Time error 5 invalid procedure or argument call then it highlights the line: OriginalFile = Dir The...
  2. V

    Power Query in Excel refreshing after small changes in queries and very slow

    All, If I even change a name of a query or something in the last step, the query refreshes all previous queries and it's very slow. Is there a way to stop this behavior that doesn't result in me just completely forgetting to refresh older ones? It's 3-4 minutes I have a few joins which make...
  3. P

    Help on single and subsequent ranges within groups with vba

    Hello, I am trying to get records placed into two different columns depending on each grouping of ranges on dn1 and Ext in table example below: If dn1/ext is asingle range then needs to be separated with a comma ',", else is in subsequent ranges then separation with a dash "-" Results would...
  4. C

    Finding duplicates based on two columns and changing values VBA

    Hi Guys, I have a range of data. I need help writing a VBA code to see if the code column matches more than one name then if it does to only change the value of that code to the ext code. So in this case it will only change Data 2 and data 3 as they both have the same Code numbers. Any...
  5. D

    write to Xml

    what wrong I have Public Sub Creat() Dim docPropsXML As String Dim docPropsFolder As String 'Creating the Document Properties FilePath = ThisWorkbook.Path & "\" RootFolder = FilePath & "root" docPropsFolder = RootFolder & "\" & "docProps" If Len(Dir(RootFolder, vbDirectory)) = 0 Then...
  6. L

    Backup copy in a different location

    I'm using the following workbook code to frequently save a timed and dated copy of the file in a backup location elsewhere before saving the file at it's normal location. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim fn As String, ext As String, ipos As Long...
  7. C

    how to save file as 97-2003 xls not xlsx in vba

    Hi there, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’ve got a file which from a macro sorts the data then splits it into sections, then creates a new workbook for each section, renames the tabs and and saves the new files as the tab name, for us to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top