Suoritettu

Very simple job: I need to produce a VBA that will transform a series of questions into tab-separated values in TXT or XLS format

For the automation of a small machine-readable report that needs to be produced every month, I would like to create an Excel VBA Macro that asks (via dialog box) if the user if something has been changed. If not, it should yield last month's report (repeat all fields and just change the month's date).

If something has changed, then the user would need to inform in which field something has changed. Then the VBA should ask (via dialog box) what's the new value to be changed there.

Finally, the VBA should also be able to produce the report from scratch, asking the user (via dialog box) the value of each field and then delivering it as a TXT or XLS. Report has no more than 30 lines and around possible 70 fields.

Taidot: Excel, tietojärjestelmäarkkitehtuuri, VB.NET, Visual Basic, Visual Basic for Apps

Näytä lisää: txt xls, exportar xls para txt, read values txt file html, fileformat:=xltext, tab delimited excel vba, excel vba save as delimited text file, convert excel to pipe delimited text file, excel vba save worksheet as text file, excel to text file, vba code for tab delimited text file, excel vba save worksheet as tab delimited text file, data processing, software architecture, excel, visual basic, vb.net, visual basic for apps, microsoft excel, parse comma separated values within worksheet, exportar xls txt

Tietoa työnantajasta:
( 5 arvostelua ) CAMPINAS, Germany

Projektin tunnus: #17654056

Myönnetty käyttäjälle:

dangphap

Hello, I can write the macro for you at most reasonable price and satisfied result. I have years of experience programming with VBA and Python. Please pm me for further discussion. Thank you.

$15 USD 3 päivässä
(8 Arvostelua)
2.6

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

vlayausa

Hello, I am proficient with Excel and VBA and would love to help you with this project. Please contact me for more information.

$30 USD 1 päivässä
(140 arvostelua)
5.8
satishtl

Can have the Master sheet with the previous months report. - Get the user the confirmatoin if something has changed, if yes, get the last months report and allow the user to change the informatoni required. either in Lisää

$160 USD 3 päivässä
(50 arvostelua)
6.0
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. would like to see the fields list, data type of them. Sample report. Lisää

$25 USD 1 päivässä
(66 arvostelua)
5.7
archanaoswal

I can create the necessary dialog boxes to input the data and produce the output in the required format I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Bui Lisää

$80 USD 1 päivässä
(88 arvostelua)
5.9
royalcalif

Let me review the raw data and preferable report format as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured th Lisää

$30 USD 1 päivässä
(78 arvostelua)
5.5
Ahmed818

Hello, i am interested in this project as i know VBA perfectly plus i did not work with employers from brazil before i will send you now samples of my VBA work https://www.freelancer.com/projects/excel/Create Lisää

$25 USD 1 päivässä
(53 arvostelua)
5.0
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I will create a macro that ask you user inputs which is required through dialog box then manipulate rows and columns Lisää

$30 USD 1 päivässä
(66 arvostelua)
5.2
$30 USD 1 päivässä
(53 arvostelua)
5.1
TetyanaS

The examples of my codes you can see in my books. I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”

$35 USD 3 päivässä
(28 arvostelua)
4.8
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Lisää

$100 USD 2 päivässä
(28 arvostelua)
4.7
imteyazkhan85

Hi there, I am an expert VBA programmer. I can complete this, and would give you desired output. I have experience of 5 years working with Excel macro. Have few questions, let discus them

$66 USD 1 päivässä
(21 arvostelua)
3.9
dataexplorer

"Hello, I am happy to inform you that I have read your project "Very simple job: I need to produce a VBA that will transform a series of questions into tab-separated values in TXT or XLS format"" description and under Lisää

$25 USD 7 päivässä
(13 arvostelua)
3.4
nishantha041

Dear sir, I have many years of experience with excel vba programs and has developed many customized [login to view URL] i start recently in here,you can see my reviews of how clients are satisfied about my delivery.y Lisää

$13 USD 3 päivässä
(4 arvostelua)
2.9
$10 USD 3 päivässä
(6 arvostelua)
1.8
raj8586998305

Hi sir

$25 USD 5 päivässä
(0 arvostelua)
0.0
ghazal0404

I m expert in this work Relevant Skills and Experience Ms word excel

$15 USD 1 päivässä
(0 arvostelua)
0.0
vknatarajan

Hi, I come with a rich experience and expertise in VBA. I have previously worked on interactive dashboards and used VBA to represent it in PowerPoint based on any changes made by the user via dialog boxes.

$35 USD 5 päivässä
(0 arvostelua)
0.0
JohnMNE

Good afternoon dear employer, Thanks for considering my application. I work as teaching assistant on University of Montenegro, and have finished Master of Science in Automation and Power Systems. Currently i am en Lisää

$10 USD 1 päivässä
(1 arvostelu)
0.0
somcp

Hi, i have more than 10 years experience on working with Excel. more than years experience on automation with VBA. In this project i will assure for timely completion and accuracy. Thanks

$25 USD 1 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0