[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 282: Undefined array key "app_rebranding_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 283: Undefined array key "app_url_scheme"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 284: Undefined array key "app_icon_url"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 285: Undefined array key "app_name"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 287: Undefined array key "app_alert_message"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 289: Undefined array key "app_android_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 290: Undefined array key "app_android_description"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 291: Undefined array key "app_banner_message_android"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 294: Undefined array key "app_ios_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 295: Undefined array key "app_ios_description"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 296: Undefined array key "app_banner_message_ios"
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
Foros Ingeniería Civil • Ubicacion de guardado
Página 1 de 1

Ubicacion de guardado

Publicado: Vie Dic 10, 2010 3:38 pm
por Icarus1985
Saludos,
Estoy realizando una macro en excel, recien estoy aprendiendo y bueno me gustaria saber como es la sintaxis de guardado ya que estoy utilizando OPEN, y bueno no se como colocar para que el archivo que se genere, sea guardado donde se encuentra ubicado el file original.

Esta es mi MACRO:

Sub Establecimiento_trabajador()
Sheets("MACRO").Activate

Const DELIMITER As String = "|"
Dim myRecord As Range
Dim myField As Range
Dim sOut As String

Open ("0601" & Range("D5") & Range("D4") & Range("F5") & ".tes") For Output As #1
For Each myRecord In Range("BQ9:BQ" & _
Range("BQ" & Rows.Count).End(xlUp).Row)
With myRecord
For Each myField In Range(.Cells, _
Cells(.Row, Columns.Count).End(xlToLeft))

sOut = "00" & sOut & myField.Text
Next myField
Print #1, Mid(sOut, 2)
sOut = Empty
End With
Next myRecord
Close #1

MsgBox " Archivo creado satisfactoriamente", , ""


End Sub

Agradezco la ayuda de antemano

Saludos