Results 1 to 4 of 4
Thread: Excel & VB Ïðîáëåì
Hybrid View
-
11th November 2010 08:34 #1Registered User
Join Date: Dec:2005
Location: sofia
Posts: 135
Excel & VB Ïðîáëåì
Çäðàâåéòå,
ñáëúñêàõ ñå ñúñ ñòðàíåí ïðîáëåì, ìîëÿ àêî ìîæåòå ïîìîãíåòå.
Ñâàëèõ îò íåòà Åêñåëñêè ôàéë ñ VB ñêðèïò çà èçâëè÷àíå íà èìåíà íà ôàéëîâå îò äàäåíà ïàïêà. Íå ìè ñâúðøè ðàáîòà è çàòîâà ãî ïðåïðàâèõ, êàòî â êðàéíà ñìåòêà íå îñòàíà íèùî îò ñòàðèÿ ñêðèïò.
Ôàéëà ñè ðàáîòè (ïðè çàðåæäàíå èçâëè÷à èìåíàòà íà ôàéëîâåòå îò åäíà ïàïêà è ãè ïîñòàâÿ â ëèñòà íà åäèí êîìáîáîêñ).
Ðåøèõ äà íàïðàâÿ íîâ ôàéë, êàòî êîïèðàì ñêðèïòà, äà àìà íå - âå÷å ñêðèïòà íå ðàáîòè è äàâà ãðåøêà "user defined type not defined".
Ðàáîòÿ ñ Åêñåë 2010, ïðîáâàõ äà çàïèøà íîâèÿ ôàéë ïîä âñÿêàêâè åêñåëñêè ðàçøèðåíèÿ - íèùî.
Êàêòî è äà ãè ñðàâíÿâàì äâàòà ôàéëà ñà åäíàêâè, ñàìî äåòî åäèíèÿ íå ðàáîòè.
Ïðè ÷èñòî êîïèðàíå íà ñâàëåíèÿ ôàéë âñè÷êî å íàðåä, ïðè ñúõðàíåíèå ïîä ôðóãî èìå - ñúùî!
Áëàãîäàðÿ ïðåäâàðèòåëíî.
-
11th November 2010 09:34 #2Mire-x
Join Date: Apr:2005
Location: Sofia
Posts: 763
Âèæ äàëè òîâà íÿìà äà ïîìîãíå: http://support.microsoft.com/kb/145759.
(10b) || !(10b)
-
11th November 2010 09:39 #3
Çà íîâèÿ ôàéë òðÿáâà äà äîáàâèø References. Tools - References âúòðå îò VB. Âèæ íà îðèãèíàëíèÿ ôàéë êîå òî÷íî òè ëèïñâà â íîâèÿ è ãî äîáàâè òàì.
i7-3930K@4.7(47x100, 1.41v), EK Supreme HF, Phobya G-Changer 420, XSPC Laing DDC Dual + Pump, Asus Rampage IV Formula, 4x2G RipjawsZ 2133MHz, GTX980Ti EVGA w/ EK-FC Titan, CM ATCS 840, Corsair AX1200, Corsair Force 3 120GB, HP ZR2740w
-
11th November 2010 10:21 #4Registered User
Join Date: Dec:2005
Location: sofia
Posts: 135
Áëàãîäàðÿ íà âñè÷êè çà îòãîâîðèòå.
Çàïî÷íàõ ñðàâíåíèå íà ôàéëîâåòå íà íèâî VB (áóêâà ïî áóêâà).
Îò áëèçêîòî ìèíàëî çíàì, ÷å run time ïðîáëåìèòå ñà áåç÷åò. Çà ìîé êúñìåò ïîïàäíàõ ïî÷òè âåäíàãà íà "ðàçëè÷èå", à èìåííî:
Project->References on the menu. Select 'Microsoft Scripting Runtime'. This will give you access to FileSystemObject.
Ïîçäðàâè.




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè