Topic: EXcel macro

[David Bethel]

I don't if this is a proper thread for this forum.

If so, I need to export multiple cells ( all strings ) in a 2013 excel spreadsheet to pre determined file name in true ASCII text, overwriting the entire file if it exists.

Could some one give me a push in the right direction? 

Thanks!  -David

ie cells ct3 thru ct29 AND dt3 thru dt26   to   c:/acad/proj.dat

[Matt__W]

The simples way would be to link the cells to another worksheet then create a macro (you could use the macro recorder for this) to export the linked cells to your proj.dat file.

http://smallbusiness.chron.com/multiple-cells-excel-another-worksheet-35868.html

[David Bethel]

Thanks! I'm looking into it.  I've used very old MS spreadsheets for add formulas to.  I'll try the learning curve here.  It seems to be worth it.  I'll probably ask more newbie questions.  thanks  again!  _David

[Keith™]

What is the output format? If comma delimited is ok, just save it as a CSV file ...

Saving the data to a file is relatively simple, but you must know what format you want .. simple ascii isn't specific enough ... do you need the contents one item on each line or all on one line. Are you using spaces between the data?

Number 5 needs more input

[David Bethel]

OK I got a new worksheet linked and the data is there.

Ouput file:

1 line per cell
there may be spaces in the data, but the program reading the data can compensate
no blank lines

ie
type1:electric
type2:right
type3:na
name1:me
anme2:you

[David Bethel]

So now I have

sheet4
cells a1:a50

Now I have to find the macro reorder.  You'd think that would a prominent button a ribbon  ( I hate ribbons )

[Matt__W]

You have to right-click on ribbon and select customize.  Then toggle on the developer tab.

[David Bethel]

Found it !


Know learning how it works.  I would personnlay rather write the code than use a recorder.  But that's a long way off.

-David

[Matt__W]

Found it !


Know learning how it works.  I would personnlay rather write the code than use a recorder.  But that's a long way off.

-David

The recorder will get you started. 

[David Bethel]

So far so good

Code: [Select]

Sub Macro5()
'
' Macro5 Macro
'
' Keyboard Shortcut: Ctrl+k
'
    Sheets("Sheet4").Select
    Application.Goto Reference:="R1C1"
    Range("A1:A50").Select
    ActiveWorkbook.SaveAs Filename:="C:\acad\proj.txt", FileFormat:= _
        xlTextMSDOS, CreateBackup:=False
    Sheets("Sheet1").Select
End Sub

How to prevent the over write dialog boxes from coming up ?

Thanks!  -David

[Matt__W]

I believe this will prevent the overwrite dialog box from showing up.

Code: [Select]

Application.DisplayAlerts = False

[David Bethel]

I believe this will prevent the overwrite dialog box from showing up.

Code: [Select]

Application.DisplayAlerts = False

Yep  it DID!

Getting very close to what I need  Tthanks!  -David

[David Bethel]

Okay,  the thing that I don't like now is when you go back to sheet1, the saveas command goes to a dos txt file type not a xlsm file type that it needs,.  Any ideas?  -David

[David Bethel]

OK  I I've searched pretty hard now.

Is there a decent 'Function Reference' site for excel macros.  Microsoft vacuums when it comes to help or reference materials.

At least AutoLISP has some human readable sites.  thanks -David