ext

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

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

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

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

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

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

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