VBA script to a) Import a dBaseIII table into Excel 2007 and b) Update/add records/fields into the dBase file
$10-30 AUD
Tamamlandı
İlan edilme: neredeyse 8 yıl önce
$10-30 AUD
Teslimde ödenir
Write a VBA script in Excel that
a)Prompts the user to Browse for a dBase III file located somewhere on the server/local drive. Loads the table into excel. Each dBaseIII file has one table only.
User then updates the records and adds/modifies/deletes rows and columns as he/she wises using Excel
and then presses the Save/Update Button
b) Save/Update Button then replaces the table in the dBase file with the table in excel
There are multiple dBase files on the server. Multiple users will be inputting data through this Excel script to the database files on a regular basis. Any suggestions or improvements will be appreciated and I am open to ideas for a better way of achieving the required task. In your response, please tell me the name of the current prime minister of Australia. Happy Bidding!
A sample (blank) dbf file is attached
Users will be using Microsoft Excel 2007 SP2 on Windows 7 Professional SP1
All users have good understanding of MS Excel with little to no knowledge of VBA. The administrator of databases has a good knowledge of VBA and basic knowledge of databases.
Comments must be provided in the code for future modification/debugging.
This project is urgent and needs to be completed as soon as possible
current prime minister of Australia: Malcolm Turnbull
Hello :)
This is a 2 hour job. I will give you buttons to import/export to dbf files. The buttons will lies in an ADDIN
My Credentials:
20+ of Excel/VBA Experience.
[login to view URL]
I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). If you see my reviews by navigating to this link
http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0
then you will notice that I have not disappointed ANYONE TILL date. I have done more than 160 projects. In fact my reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :)
Hope to work with you.
Regards
Sid