Posts

Showing posts with the label How to Make an Excel Fixed Width File from SWMM 5

How to Make an Excel Fixed Width File from SWMM 5

Image
How to  Make  an  Excel   Fixed   Width   File  from  SWMM   5 You can use this macro for MATLAB or some other DOS based program by using the Tools command of  SWMM   5  and configuring the  EXCEL   file  option.  If you use the  EXCEL  tool then your  SWMM   5  input  file  will be opened up in  EXCEL  and you can use this macro to  make  a  fixed  format  file  for  SWMM   5 .  Note,  SWMM   5  does not use  fixed  format but other programs may need it for reading,  You adjust the column widths in the macro for your program. Here is the macro, which is placed  in  Excel  using these command: Copy the code above. Open  Excel . Alt + F11 to open the Visual Basic Editor. Click Insert-Module from the menu. Paste the code into the window that appears at right. Option Ex...

How to Make an Excel Fixed Width File from SWMM 5

Image
How to Make an Excel Fixed Width File from SWMM 5 How to Make an Excel Fixed Width File from SWMM 5 by  dickinsonre How to Make an Excel Fixed Width F ile from SWMM 5 You can use this macro for MATLAB or some other DOS based program by using the Tools command of SWMM 5 and configuring the EXCEL file option.  If you use the EXCEL tool then your SWMM 5 input file will be opened up in EXCEL and you can use this macro to make a fixed format file  for SWMM 5.  Note, SWMM 5 does not use fixed format but other programs may need it for reading,  You adjust the column widths in the macro for your program. Here is the macro, which is placed  in Excel using these command: Copy the code above. Open Excel. Alt + F11 to open the Visual Basic Editor. Click Insert-Module from ...