Write
is a special statement designed to generate machine-readable files that are later consumed with Input
.
Use Print
to avoid any fiddling with data.
Print #2, "Start postion = "; StarRange
Print #2, "End position = "; EndRange
More Related Contents:
- to make this code simpler
- VBA code takes long time to execute in excel
- Wait until ActiveWorkbook.RefreshAll finishes – VBA
- Pop up the Excel Statusbar?
- Excel VBA deleting rows in a for loop misses rows
- What is the lifetime of a global variable in excel vba?
- Download attachment from Outlook and Open in Excel
- What is the most efficient/quickest way to loop through rows in VBA (excel)?
- Embed picture in outlook mail body excel vba
- How to check for empty array in vba macro [duplicate]
- Use autofilter on more than 2 criteria
- What is the function of FormulaR1C1?
- Compiler Error: User-defined types not defined
- Open a workbook using FileDialog and manipulate it in Excel VBA
- Vba Excel do vlookup from a closed file
- excel hyperlink to nothing
- How to add headers to a multicolumn listbox in an Excel userform using VBA
- How to send files via HTTP_POST with Excel using VBA?
- VBA to open Excel hyperlink does not work when hyperlink generated with a formula
- How to Add Date Picker To VBA UserForm
- Vba macro to copy row from table if value in table meets condition
- Difference between Thisworkbook.name and Activeworkbook.name in VBA
- Set a cell value from a function
- How to determine if a date falls on the weekend?
- What are the differences between using the New keyword and calling CreateObject in Excel VBA?
- Excel VBA wildcard search
- VBA Check if file (from website) exists
- How to have vba execute every 10 minutes?
- Read and write from/to registry in VBA
- Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text