dat

Hi All, Is there a macro to save multiple excel worksheets to .dat files, and name the files with the same name as the worksheet. Please help. Thank you very much in advance.

With this code i take out the birthday date from a socialnumber (personnummer in sweden) Sub GetBirthdayDate() Application.Echo False On Error GoTo PROC_ERR Dim dat Dim year Dim mounth Dim day Dim age year = Left(Form_Profile_Form.txtProfilePersonnummer, 2) mounth =...

Why does the debug.printout generate an error (run time 5: Invalid procedure call or argument)? If I print a single item in the array it works. If I use a static array the debug.print works. Also is there a solution to get the printout to show as date, it now prints f.e. 42837 instead of...

Hello there I have a vba code which works perfectly... it opens and copys all data from any DAT file located in a specified folder (C:\Junk) to a worksheet called 'download' and also stores the name of any DAT file it has processed in a worksheet called 'Processed_Files' However I need the...

Sub Opendat() Dim MyFolder As String On Error GoTo Errorcatch Dim MyFile As String MyFolder = "C:\Documents and Settings\Xxxxx\Desktop\" 'put your folder here MyFile = Dir(MyFolder & "\*.dat") Do While MyFile <> "" Workbooks.Open Filename:=MyFolder & "\" & MyFile MyFile = Dir Loop...

Hello, I have created a macro that pastes a range of excel data (via a loop function) into a .dat file, which is later FTP'd to another team. The only issue that I'm running into is that they cannot accept the file with a space at the end, which is unfortunately automatically entered into the...