Käynnissä

Excel Macro to Generate an Output File

Hi,

We have data that gets exported from our accounting system to excel. We need to add two buttons to this spreadsheet to do the following things:

1. Validate the data (IE, the lengths are correct, or the date is not blank, etc..)

2. Generate a TXT output file.

The output file basically strips down the DATA, places the data in the right order, Example 20090901 for date. This data is to be read by another system and the results have to be exact.

IF IT MAKES THE PROJECT ANY EASIER, please note that we already have the finished product, but we have it in two files and would like to integrate into one containing Sheet1 and Sheet2.

Taidot: tietojenkäsittely, Excel

Näytä lisää: generate data excel macro, excel macro generate output file, macro generate output excel, generate project file macro, we excel, excel macro example output file, excel macro output, macro generate file excel, validate excel, spreadsheet excel and accounting, spreadsheet (excel) and accounting, macro excel, macro + excel, Excel accounting, do excel, accounting spreadsheet, excel macro add, excel macro txt, excel macro read data files, project macro, macro spreadsheet, excel order system, system data file, add excel macro, excel macro read txt

Tietoa työnantajasta:
( 5 arvostelua ) Aurora, Canada

Projektin tunnus: #500372

51 freelanceria on tarjonnut keskimäärin 58 $ tähän työhön

svet63

Excel developer since 1997. Can do. Regards, Svet.

60 $ USD 1 päivässä
(64 arvostelua)
6.6
wsh2

Greetings Canada from the USA.. Hello my name is Bill.. I am a MsAccess, MsExcel, VBA, VB.Net, VBA, VBScript, VB6, SQL, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at [url removed, login to view] and w Lisää

99.95 $ USD 2 päivässä
(28 arvostelua)
5.8
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

65 $ USD 1 päivässä
(45 arvostelua)
6.1
nagybatonyi

This kind of job fits my daily work, please see PMB! Regards!

30 $ USD 1 päivässä
(57 arvostelua)
5.7
spawar

Hi, Very good command on xls macros, I will do this work for you, ready to start it immediately, interested to work with long term, daily available for communication.

100 $ USD 3 päivässä
(21 arvostelua)
5.5
agihcam

Please refer to PMB.

50 $ USD 1 päivässä
(40 arvostelua)
5.1
xamdam91

Looking forward to working with you.

30 $ USD 0 päivässä
(25 arvostelua)
4.7
pyazlm

You may check PMB.

30 $ USD 2 päivässä
(30 arvostelua)
4.4
SoftSandila

send me both the two files . i can embed it in one file for u in just an hour. thank you imran

69 $ USD 0 päivässä
(9 arvostelua)
3.9
johnsinit

Dear ImNet! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

48 $ USD 2 päivässä
(14 arvostelua)
3.9
KellogITSolution

Hello Please see ur PMB for details. Thanks

30 $ USD 0 päivässä
(8 arvostelua)
3.6
MustafaSR

Pls check PMB

40 $ USD 2 päivässä
(9 arvostelua)
3.6
nmppatel

I am a VBA expert. I have very good experience with VBA Excel/ Macros. I have completed many projects on GAF in this skill i will provide quick & professional service.

100 $ USD 1 päivässä
(9 arvostelua)
3.7
qtorixsystems

I have completely understood the complete scanerio. I can help u asap!

200 $ USD 5 päivässä
(3 arvostelua)
3.4
guoxinliu917

Hello, I can do it for you. Thanks.

50 $ USD 1 päivässä
(2 arvostelua)
2.9
edataworker1

ANYTHING WITH EXCEL. PLEASE CHECK PM.

90 $ USD 3 päivässä
(4 arvostelua)
2.7
refractocd

This can be done using Excel VBA. Please refer to PM

50 $ USD 2 päivässä
(3 arvostelua)
2.5
tindz99

please have a look at pm for details

30 $ USD 2 päivässä
(3 arvostelua)
2.2
zszabo

Hello Waiting for source files and instructions. Have a nice day ! Zoltan

50 $ USD 0 päivässä
(3 arvostelua)
2.2
win4t4

I don't really understand what you needed 1. You needed an application that can get information from your accounting system and put it into excel file 2. You needed an application which can read 2 excel file and mer Lisää

50 $ USD 1 päivässä
(1 arvostelu)
1.9