|
|
|
Excell
|
|||
|---|---|---|---|
|
#18+
Pomogite, pojalista... Zadacha takaya, If Target.Address = "$A$1" And Range("A1") <> "" Then Workbooks.Open Filename:="C:\" & Range("A1") vot a esli net file to togda nado sohranit kak, to est Workbooks.SaveAs Filename:="C:\" & Range("A1") mojete pravilno napisat ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 02.11.2006, 07:22 |
|
||
|
Excell
|
|||
|---|---|---|---|
|
#18+
RouzePomogite, pojalista... Zadacha takaya, If Target.Address = "$A$1" And Range("A1") <> "" Then Workbooks.Open Filename:="C:\" & Range("A1") vot a esli net file to togda nado sohranit kak, to est Workbooks.SaveAs Filename:="C:\" & Range("A1") mojete pravilno napisat ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 02.11.2006, 07:39 |
|
||
|
Excell
|
|||
|---|---|---|---|
|
#18+
Workbooks("workbook.xls").SaveAs... ActiveWorkBook.SaveAs... Workbooks(1).SaveAs ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 02.11.2006, 08:13 |
|
||
|
Excell
|
|||
|---|---|---|---|
|
#18+
orunbekWorkbooks("workbook.xls").SaveAs... ActiveWorkBook.SaveAs... Workbooks(1).SaveAs problema, esli net faila, to rugaetsya, dalshe ne idet ... to est poisk faila, esli est otkrit, esli net sohranit kak.... esli est fail, to otrkrivaet, esli net dalshe ne idet, Pomogite , pojaluista ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 02.11.2006, 08:30 |
|
||
|
Excell
|
|||
|---|---|---|---|
|
#18+
Воспользуйтесь объектом FileSystemObject из библиотеки Microsoft Scripting Runtime. В форуме и в сети найдете океан примеров. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 02.11.2006, 15:20 |
|
||
|
|
start [/forum/topic.php?fid=60&msg=34101274&tid=2165043]: |
0ms |
get settings: |
6ms |
get forum list: |
15ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
156ms |
get topic data: |
8ms |
get forum data: |
2ms |
get page messages: |
32ms |
get tp. blocked users: |
1ms |
| others: | 206ms |
| total: | 430ms |
| 0 / 0 |
