PDA

View Full Version : خروجي گرفتن اكسل بانام تاريخ جاري سيستم



twofan
شنبه 25 آبان 1392, 16:38 عصر
سلام خدمت اساتيد
من مي خواهم خروجي اكسل بگيرم از كوئيري ولي نه بنام خود كوئيري بلكه به تاريخ جاري سيستم
ممنون ميشم از راهنمايهاتون

bita_ziba77
پنج شنبه 30 آبان 1392, 12:45 عصر
با سلام
با كمك كد ذيل

Docmd.TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)


http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqMAAAAhCAIAAAB iGjXFAAAOsklEQVR4nO0dPY/cupG/JkWSareS/kWqAKriIkLuD7jc69xKjWtvleb1fM1rNu5dBXChxgcHcBHECGA gLgxDKURyPklxv25XOhKDw0Incr7ImSE5Is1YytqLMebWJJRSy nHl8+fP4zj+N6/s9/uHh4epyvT3b395+Pe//vPPf3wM8L9v33//uz+8evXq9evXb968efv27bt373755Zdff/31/fv3Hz58+Pjx46dPn758+fL169dv3759//79x48fP3/+vLEgSinlEsWM4/i5lFJKKaWUUkpZY3l4eHCefhyfChQoUKBAgQIrg+LpCxQoUKBA gTVD8fQFChQoUKDAmiHq6Yd+a0Rp7cUQ23ZqcZ/x8r4FEhp7ZYnYNsbmoa+3/XByy4e+RsTbxtSPQ5CDMX/+60bI+/LMDp3DUnWH/JevStJomxNbzq5oW8JDDu83F8s9aupcOHSVMdVueBZ0QSax4dx VQbz3YmG6atOdYWG6qrF6Z7ik6R7HaegdKaisKrdShIp3OerIg Pk5fbxfngP7NleRh74GAoZ+OznIq0lk35qYO8+nWQPv2sfxaRw ea/db2L5hV53tihLC7Krjh9D1SaqqjTHHDqr8ipTrLHbcKL2tWO5M U2fDsKtMZnB/pui83GwT7x5hOB+6ClmYbnPlWGTfzpN0EtiGUX4d0+1YqI7zgj lVbqWIGN6lqCMLZj095dY2pn3sa8Pmo8j77tv6cXCTreAyIWJq 7dM4PNYoeoLFg2ACCBYmbu+JbVP3+76m2Cl5Sss6zeHhtrePtU NHaR6de7auTSBJxcIfBpbbPVkbELZvCgChQwy7ypi221UeKZqe +mFjG2NMax3Bvq6bssCbEy5EFQo2iRfE6ARJNDQJ9DuNU8JUFB SGbmNMYye8MAwE8bkVnzAlJGBnfcCzIOSJovt2r73wQjWVAF1E UhG2MVMg4rTmRd3uQwv4TdkmIKJ8eTmgAnKLsDPsKt2gewdgm6 rbO9UEdLYx7S4IFoSmWhhk6P3DTWd3VdTC7KpqZ12byMJoWPjD 0GfgHcwXcWa2NVV30BmMoGNDr+oO1G8JXuargKB8bHpDRWh4F6 KOTJjz9DD7fBqdA3Neaui3AbdtTd0fYIhOw6zfTg/hv4Pzo+FfaI4Oc3eMxeuGz7Pxw9A+J09tWdCM3ty3BoIYRvNom 7oGsmfoFw+hl+PJvTP9jC9hLolbQg6J9PLGooe2Db1zGoSOhYB u6DakqUksFJ1KEmoZfk/jp7UkdtFREPDP6WRUJz6jInJ1aE4cHMzIWVDlidvUX3hZmsILm 4ZZvTSnTBHh4YSuqhorl9BBJpxIQISVzuQgO1JkXjj5Hl2V4qG zxURQePIHhnvoNtjCQC2IKoBHR8DgXY5tqmoTqoi6FIt4yKeME MrQ//rnUQZFy2LoOW1iAXJeMqp4QYELvIkiYnjvXh14hjAfCsx5etuw KMn5PwrEa/r34bdtjCEVPZ90qdzjUrD4GD/MV8iWuVJRb1mjmbwJ/U+jWUQJKhb1IRCMucP9FSkPhoreBcObvIuwh1z33KCjPiSaipL EGqm6A50+ht86ihQ9SLzpjhupmMAiwylmj1BdEX5pjb8sTeVBq Ks3okQbhOZAhkYkWf2Ky4HoLnCtUMsNsbAwZI8WWRg0AVVeYCh 8BEPDL2RheADKnZOKRX0oNpUpScFXecZVBueZGroNzFjwKmxc1 EoVPSC4kSJ0vMtQRz7MePqh3+I1VexfWZaTD2TIC8K8Tv/17ZA1umDv4olvw2NtfIiAd+uFN420rNGMZ9giyFBoHufo11HDp qCQIVs4Eu5E7OKLlg0JVCFSDoVP7Hg7JmGg+VwWjClsgmruVkc hWtaddDoxJ1Ixsg2cErIiT7rkq73wwjQ1M6dXONUVoTpyRA/U0ogkLjwaUkjdHZf7BlX2LZMkM99HWRg6mRPLSyH4CyT536dYG BAFD2Um1QTJSwYjTBEl4uWT5JJSqorYw765IgTeRajjCEh7eup 08Uo+cZBhFovZcw/ZLL/uD9AO9bIKlrByHuQ1tUb3FJx7jpKHxCdpJg/dYrtCM2fNL7HOYJFMsXbS6Xh0KRXtjIARFyuZrPtOM1o+n9NTt 7Q1dvmmGwyHrpI2Gv2eyw6zwoFIp46Iz6ioYxROkfg/IU8xuRcvvDhNpWCWU0oMd+RCJmzFnqUXwIKnbErqOicdT0wu3a qvWGt16QW4cemryEPYZmYRodu/CBbGTe8iFmYGCxIveShCmWFXVbtOLBoTBuccsBh6flOG8zJTRZ me3kgRUbwLUMclV+9lOh6yZd6fofkHddLBnaOZSt0fUDtoods2 JrheNHT7Gk+y9y3YaJ+F1G+13hNpWaUZ7ffDm4xmlTUVywxTSK TCIKpJXvFNaAgz2YYuCa5VA6ouVmsGWi59u0VRnPSO9krRinFy PVxPRYwTn1FRbmOH5C94n29OC3miRiIvvDBNJWFWhqAIjXhMM4 hCJxLa1Dfsxyfm+LU9GqQvJF7WArcwYZ2AWxgsVe5L6KoM7L8i HsHCcO9FsgUFlhhqnl2hLb2QMEgwqKNDLajeS/IyWwX8a5D/jRQRw3v/6jgSkp5epOOJlW1jjKnbppYKQL8hrJsMKG4HFijAc9NNerJ4GI xC3T+26YqiZZ1mlCdft01NQgEUKNkG05ygX38IUx++xTCbjqdl pG/a1llAvNOPTBsJ9yLzSJEuq1n5+H4wN6md8vlyLCOXO06KXSM+q yJZSSYZW0ZtUJEnPAyLw/yFF6WpWYiISCgisC+8O5IDSlFUiIQ2Y4Gg0F2INkQahCpeTFjV 7biFYRPWpIWp2qYitts/JB4Iacc20Dj9LbEkLYyXlbK5QzqwZDCKzstWdjmkR9LTZqtox0 XcRhEq3rtXx9GwxDPyyBf2iwPa188K024E08DAm1gn53AVuCos UVOXIhKn4+07saScNCCxtPMlA10rXQiDS6FzAepYoqcXKyHLAk gqmYK1JTn7ECnz6eAZqSIFrgGL1dQFiKS8y0OQ3NCL29aFWxhV pDwpdREMLoXOBahjiZ6+QIECBQoUKJALxdMXKFCgQIECa4bi6Q sUKFCgQIE1Q/H0BQoUKFCgwJrhIp4+faLZhSGeN3uZW2WvcF3vwd3Ec8kGGaeH vqWHBrLvUsQdgKmvjRVcjgX1LOTA4OZPfzxCdPL0jAwl2tYIRs 5RepSXNKd1f+BHgpBPKJfCxd+VjnTkIErKIUab8l/yydZ1hXM5pUerPB9J9BhTIsl8wEZPqYu+9iaE6UO4wD3C+Z5+j bfKjk/jSQMmTvNFAyB6zoEbe/DtJpwFpN61c5yaEK64weUM5ohOWiiNNQaHvm5aQsZV0lYzOE3i XTAXx1JyPOW6cMK4fibhnCQuEaOIQzxvT9Lx4iKhFZw4TlRTUy yesFXmxq8TUp4eAljlgld8lwz7YGDpt8o+Cb6Imwwn/SkMquh008aO0MHn9JFYPnKrLz2Anb2vchFCGRyhE6HB3J0cASF P92PAGVQcv9Dpoa+3fd8kWItJ0uIjkkggIrDMcqd3jwxOVZ3ic yEXykWaksigSxxone69yrh+PuFQRrK6txoY8ZE7d4V3eLOxqME TNagcvob/xXiMqINpkM7UpxPJLL+jNhZnFLhTiHp69YJXdL0P9DB0DQwAfm iXdavsBOJofWbaogzKOXRsjcs99+cvauKN0e/toDstODaHpnP3Q1+btocZ/yiEFowCFiDIOTJP5acTypuOhU7pZ9MggbTinMTwRMqfVxi7Q3m WOwVLDqeqThExS+XCP4kNfzno0nJI9F51XD+PcBRGThJXaDz/Cm/Cdb2tQ/XTNCjf8URKHrPsHm8TDJEWey37ELMXBVmr93D2eyzG9BvD4bKp 5d4qq5IUOrofGCqDOlPxvb1DX2/rWhgdgGiD7HDZKcNAUwp9jhYP4kIjvwFXfE+O05N8E4ygdtCyT V5n7F9L2ik9MFW5i3TCDE7VezvwfxfBRWZKCnNd6pHYmhzSvVc f188nHLYFfpq4NE9M4n68tCNMhCf+LA2yjXwyYAmPeXZv5Esyy vCH38XTLwainp6NYXfZQHpzdw23yjrgu8hhqgHxuGBQbzm1wEX m3OoyWk6DWuwv05qmSKInpkETGvkND/VtdV5ReVPRqfaOt++J64zRtqXoURqWOe4iWDI4VXUq/rsALmTImKAkPehEI+neGxnXzyMcwUhW98YxB8t0UcWlXOEtAlx/ictpGlSDfhHKm4QolLQnFKAgK6e6/7J6vxyIeHobueCVxZgrvFU2IFK8aS/W8AmDeiSU3GwzYGv0pdR5UmVFmqAHuNSbhZO/T0nHE6sdyu3GzMf45+nrjBUKvSXSscxxF4lcT03HE0JbHhdqm/vo9dNpOaR7rzaun0c4GiMn5L7R7Zh52lRrpgQ9x2gwGvQrPOpY ZLRHNxNJCdu1HumVExILXBDmPT18jgV6DZfJru9W2UCeyHMxNL VQMqi2HN1sc7IiW25cvDmkstifaYTqJRAc8hC1mJ3k7uWk4yVE p+p0xJv0dEcG0M1Icui3be9Rx3pOmrto95jjlLNMUSyIC7nqk6 BEHXQJOaR7rzqun0c4kpGTxAXT+iNoA3pm7EbeiMObF2SY6zxK LGxHD00SopMfmkUY2V8ocG8wv3qvX/BKvbtYtlrurbJP46i6Z77BJhlMtUzKth/2Lfl4AQ9+Kl7RoNiZo3F9+Igg4PrtseZf5aKALJL0Hk3H0+KMR DqerlPbmHYv04DT1xlz1APhK4YlwZ2OJYNTuTmKe91SuEirUh2 JbNCl5TDbe5Vx/TzCkdbjJHGp099Z2gI92JqdqEE3/GG067tmArWWvuPpR6m++mf6JB2vLN0vBq5xRt4a0zTIeFsjg3P sh7ikj2UArQPWwek6uFi1uFjK0T2QdJSs9DivwL3CNTz9yo5T2 C/2zseLgJs0+AQoxjj+79JhHZyug4t1iotk70fXve9Wg4C6rNsvD sq59wUKFChQoMCawXn6h1JKKaWUUkopZaXl/x6YAXZrBle9AAAAAElFTkSuQmCC
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqMAAAAhCAIAAAB iGjXFAAAOsklEQVR4nO0dPY/cupG/JkWSareS/kWqAKriIkLuD7jc69xKjWtvleb1fM1rNu5dBXChxgcHcBHECGA gLgxDKURyPklxv25XOhKDw0Incr7ImSE5Is1YytqLMebWJJRSy nHl8+fP4zj+N6/s9/uHh4epyvT3b395+Pe//vPPf3wM8L9v33//uz+8evXq9evXb968efv27bt373755Zdff/31/fv3Hz58+Pjx46dPn758+fL169dv3759//79x48fP3/+vLEgSinlEsWM4/i5lFJKKaWUUkpZY3l4eHCefhyfChQoUKBAgQIrg+LpCxQoUKBA gTVD8fQFChQoUKDAmiHq6Yd+a0Rp7cUQ23ZqcZ/x8r4FEhp7ZYnYNsbmoa+3/XByy4e+RsTbxtSPQ5CDMX/+60bI+/LMDp3DUnWH/JevStJomxNbzq5oW8JDDu83F8s9aupcOHSVMdVueBZ0QSax4dx VQbz3YmG6atOdYWG6qrF6Z7ik6R7HaegdKaisKrdShIp3OerIg Pk5fbxfngP7NleRh74GAoZ+OznIq0lk35qYO8+nWQPv2sfxaRw ea/db2L5hV53tihLC7Krjh9D1SaqqjTHHDqr8ipTrLHbcKL2tWO5M U2fDsKtMZnB/pui83GwT7x5hOB+6ClmYbnPlWGTfzpN0EtiGUX4d0+1YqI7zgj lVbqWIGN6lqCMLZj095dY2pn3sa8Pmo8j77tv6cXCTreAyIWJq 7dM4PNYoeoLFg2ACCBYmbu+JbVP3+76m2Cl5Sss6zeHhtrePtU NHaR6de7auTSBJxcIfBpbbPVkbELZvCgChQwy7ypi221UeKZqe +mFjG2NMax3Bvq6bssCbEy5EFQo2iRfE6ARJNDQJ9DuNU8JUFB SGbmNMYye8MAwE8bkVnzAlJGBnfcCzIOSJovt2r73wQjWVAF1E UhG2MVMg4rTmRd3uQwv4TdkmIKJ8eTmgAnKLsDPsKt2gewdgm6 rbO9UEdLYx7S4IFoSmWhhk6P3DTWd3VdTC7KpqZ12byMJoWPjD 0GfgHcwXcWa2NVV30BmMoGNDr+oO1G8JXuargKB8bHpDRWh4F6 KOTJjz9DD7fBqdA3Neaui3AbdtTd0fYIhOw6zfTg/hv4Pzo+FfaI4Oc3eMxeuGz7Pxw9A+J09tWdCM3ty3BoIYRvNom 7oGsmfoFw+hl+PJvTP9jC9hLolbQg6J9PLGooe2Db1zGoSOhYB u6DakqUksFJ1KEmoZfk/jp7UkdtFREPDP6WRUJz6jInJ1aE4cHMzIWVDlidvUX3hZmsILm 4ZZvTSnTBHh4YSuqhorl9BBJpxIQISVzuQgO1JkXjj5Hl2V4qG zxURQePIHhnvoNtjCQC2IKoBHR8DgXY5tqmoTqoi6FIt4yKeME MrQ//rnUQZFy2LoOW1iAXJeMqp4QYELvIkiYnjvXh14hjAfCsx5etuw KMn5PwrEa/r34bdtjCEVPZ90qdzjUrD4GD/MV8iWuVJRb1mjmbwJ/U+jWUQJKhb1IRCMucP9FSkPhoreBcObvIuwh1z33KCjPiSaipL EGqm6A50+ht86ihQ9SLzpjhupmMAiwylmj1BdEX5pjb8sTeVBq Ks3okQbhOZAhkYkWf2Ky4HoLnCtUMsNsbAwZI8WWRg0AVVeYCh 8BEPDL2RheADKnZOKRX0oNpUpScFXecZVBueZGroNzFjwKmxc1 EoVPSC4kSJ0vMtQRz7MePqh3+I1VexfWZaTD2TIC8K8Tv/17ZA1umDv4olvw2NtfIiAd+uFN420rNGMZ9giyFBoHufo11HDp qCQIVs4Eu5E7OKLlg0JVCFSDoVP7Hg7JmGg+VwWjClsgmruVkc hWtaddDoxJ1Ixsg2cErIiT7rkq73wwjQ1M6dXONUVoTpyRA/U0ogkLjwaUkjdHZf7BlX2LZMkM99HWRg6mRPLSyH4CyT536dYG BAFD2Um1QTJSwYjTBEl4uWT5JJSqorYw765IgTeRajjCEh7eup 08Uo+cZBhFovZcw/ZLL/uD9AO9bIKlrByHuQ1tUb3FJx7jpKHxCdpJg/dYrtCM2fNL7HOYJFMsXbS6Xh0KRXtjIARFyuZrPtOM1o+n9NTt 7Q1dvmmGwyHrpI2Gv2eyw6zwoFIp46Iz6ioYxROkfg/IU8xuRcvvDhNpWCWU0oMd+RCJmzFnqUXwIKnbErqOicdT0wu3a qvWGt16QW4cemryEPYZmYRodu/CBbGTe8iFmYGCxIveShCmWFXVbtOLBoTBuccsBh6flOG8zJTRZ me3kgRUbwLUMclV+9lOh6yZd6fofkHddLBnaOZSt0fUDtoods2 JrheNHT7Gk+y9y3YaJ+F1G+13hNpWaUZ7ffDm4xmlTUVywxTSK TCIKpJXvFNaAgz2YYuCa5VA6ouVmsGWi59u0VRnPSO9krRinFy PVxPRYwTn1FRbmOH5C94n29OC3miRiIvvDBNJWFWhqAIjXhMM4 hCJxLa1Dfsxyfm+LU9GqQvJF7WArcwYZ2AWxgsVe5L6KoM7L8i HsHCcO9FsgUFlhhqnl2hLb2QMEgwqKNDLajeS/IyWwX8a5D/jRQRw3v/6jgSkp5epOOJlW1jjKnbppYKQL8hrJsMKG4HFijAc9NNerJ4GI xC3T+26YqiZZ1mlCdft01NQgEUKNkG05ygX38IUx++xTCbjqdl pG/a1llAvNOPTBsJ9yLzSJEuq1n5+H4wN6md8vlyLCOXO06KXSM+q yJZSSYZW0ZtUJEnPAyLw/yFF6WpWYiISCgisC+8O5IDSlFUiIQ2Y4Gg0F2INkQahCpeTFjV 7biFYRPWpIWp2qYitts/JB4Iacc20Dj9LbEkLYyXlbK5QzqwZDCKzstWdjmkR9LTZqtox0 XcRhEq3rtXx9GwxDPyyBf2iwPa188K024E08DAm1gn53AVuCos UVOXIhKn4+07saScNCCxtPMlA10rXQiDS6FzAepYoqcXKyHLAk gqmYK1JTn7ECnz6eAZqSIFrgGL1dQFiKS8y0OQ3NCL29aFWxhV pDwpdREMLoXOBahjiZ6+QIECBQoUKJALxdMXKFCgQIECa4bi6Q sUKFCgQIE1Q/H0BQoUKFCgwJrhIp4+faLZhSGeN3uZW2WvcF3vwd3Ec8kGGaeH vqWHBrLvUsQdgKmvjRVcjgX1LOTA4OZPfzxCdPL0jAwl2tYIRs 5RepSXNKd1f+BHgpBPKJfCxd+VjnTkIErKIUab8l/yydZ1hXM5pUerPB9J9BhTIsl8wEZPqYu+9iaE6UO4wD3C+Z5+j bfKjk/jSQMmTvNFAyB6zoEbe/DtJpwFpN61c5yaEK64weUM5ohOWiiNNQaHvm5aQsZV0lYzOE3i XTAXx1JyPOW6cMK4fibhnCQuEaOIQzxvT9Lx4iKhFZw4TlRTUy yesFXmxq8TUp4eAljlgld8lwz7YGDpt8o+Cb6Imwwn/SkMquh008aO0MHn9JFYPnKrLz2Anb2vchFCGRyhE6HB3J0cASF P92PAGVQcv9Dpoa+3fd8kWItJ0uIjkkggIrDMcqd3jwxOVZ3ic yEXykWaksigSxxone69yrh+PuFQRrK6txoY8ZE7d4V3eLOxqME TNagcvob/xXiMqINpkM7UpxPJLL+jNhZnFLhTiHp69YJXdL0P9DB0DQwAfm iXdavsBOJofWbaogzKOXRsjcs99+cvauKN0e/toDstODaHpnP3Q1+btocZ/yiEFowCFiDIOTJP5acTypuOhU7pZ9MggbTinMTwRMqfVxi7Q3m WOwVLDqeqThExS+XCP4kNfzno0nJI9F51XD+PcBRGThJXaDz/Cm/Cdb2tQ/XTNCjf8URKHrPsHm8TDJEWey37ELMXBVmr93D2eyzG9BvD4bKp 5d4qq5IUOrofGCqDOlPxvb1DX2/rWhgdgGiD7HDZKcNAUwp9jhYP4kIjvwFXfE+O05N8E4ygdtCyT V5n7F9L2ik9MFW5i3TCDE7VezvwfxfBRWZKCnNd6pHYmhzSvVc f188nHLYFfpq4NE9M4n68tCNMhCf+LA2yjXwyYAmPeXZv5Esyy vCH38XTLwainp6NYXfZQHpzdw23yjrgu8hhqgHxuGBQbzm1wEX m3OoyWk6DWuwv05qmSKInpkETGvkND/VtdV5ReVPRqfaOt++J64zRtqXoURqWOe4iWDI4VXUq/rsALmTImKAkPehEI+neGxnXzyMcwUhW98YxB8t0UcWlXOEtAlx/ictpGlSDfhHKm4QolLQnFKAgK6e6/7J6vxyIeHobueCVxZgrvFU2IFK8aS/W8AmDeiSU3GwzYGv0pdR5UmVFmqAHuNSbhZO/T0nHE6sdyu3GzMf45+nrjBUKvSXSscxxF4lcT03HE0JbHhdqm/vo9dNpOaR7rzaun0c4GiMn5L7R7Zh52lRrpgQ9x2gwGvQrPOpY ZLRHNxNJCdu1HumVExILXBDmPT18jgV6DZfJru9W2UCeyHMxNL VQMqi2HN1sc7IiW25cvDmkstifaYTqJRAc8hC1mJ3k7uWk4yVE p+p0xJv0dEcG0M1Icui3be9Rx3pOmrto95jjlLNMUSyIC7nqk6 BEHXQJOaR7rzqun0c4kpGTxAXT+iNoA3pm7EbeiMObF2SY6zxK LGxHD00SopMfmkUY2V8ocG8wv3qvX/BKvbtYtlrurbJP46i6Z77BJhlMtUzKth/2Lfl4AQ9+Kl7RoNiZo3F9+Igg4PrtseZf5aKALJL0Hk3H0+KMR DqerlPbmHYv04DT1xlz1APhK4YlwZ2OJYNTuTmKe91SuEirUh2 JbNCl5TDbe5Vx/TzCkdbjJHGp099Z2gI92JqdqEE3/GG067tmArWWvuPpR6m++mf6JB2vLN0vBq5xRt4a0zTIeFsjg3P sh7ikj2UArQPWwek6uFi1uFjK0T2QdJSs9DivwL3CNTz9yo5T2 C/2zseLgJs0+AQoxjj+79JhHZyug4t1iotk70fXve9Wg4C6rNsvD sq59wUKFChQoMCawXn6h1JKKaWUUkopZaXl/x6YAXZrBle9AAAAAElFTkSuQmCC