Makro: Overfør tekst

I NEVER use macro's so Ican only suggest making a function which does it for you. Then if you must you can make a macro which calls the function.

Docmd.TransferText acImportFixed,"Spec name goes here", "Table Name Goes Here", "File Name Goes Here"

And a Happy New Year to you too.

Tak for hurtig svar, men har prøvet med function.

Docmd.TransferText acImportFixed,"HVAD SKAL DER STÅ HER?", "Table Name Goes Here", "File Name Goes Here"

De andre har jeg styr på !

I'm assumimg that you have saved your export as a specification.

"HVAD SKAL DER STÅ HER?" = "Status Sammenkædningsspecifikation


Taken from Help
SpecificationName  Optional Variant. A string expression that's the name of an import or export specification you've created and saved in the current database. For a fixed-width text file, you must either specify an argument or use a schema.ini file, which must be stored in the same folder as the imported, linked, or exported text file. To create a schema file, you can use the text import/export wizard to create the file. For delimited text files and Microsoft Word mail merge data files, you can leave this argument blank to select the default import/export specifications

Den kender ikke "Status Sammenkædningsspecifikation" i koden ? den melder fejl. Filen er adskilt af tabulator.

Har løst det. Lavede en import og gemte den med navn.

Tak for hurtig hjælp.

Rigtig godt nytår

Sorry for not getting back, went to see a bit of TV.

Great to hear you found a solution.

Rigtig godt nytår til dig også.