Show Bid Request
Owner
Bid Request Id: 9594
|
|
|
|
Posted by: |
jmg092548 (2 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Unverified
|
|
Approved on: |
Feb 25, 2002
9:07:06 PM EDT
|
|
Bidding Closes: |
Feb 27, 2002
6:00:00 PM EDT
|
|
Viewed (by coders): |
657 times
|
|
Deadline: |
2/27/2002 1:00:00 PM
TIME EXPIRED
|
|
|
|
|
Description:
I'm a programmer, experienced in application development and coding, but a rank beginner to VB. I need someone I can ask questions of about VBA for Excel and Access.
I'm mostly self-taught and I learn quickly, so I probably won't need highly detailed explanations. Mostly my questions would be like "How, in general, does one do X in VBA?" and then I could probably figure out the details myself.
Ideally I'd like someone who I could consult with on an ongoing basis by telephone or email (although I don't know if that kind of arrangement would fit in with the auction structure here.)
Following is my initial question, along with the programming task that prompted it:
How does one run a system command (or "shell escape") from within VB? Is this possible from within VBA?
The programming task that prompted this is as follows:
I want to feed data from Excel worksheets into another application, in batches. The simplest way to do this (from the standpoint of the other application) is via space-delimited data (although CSV-formatted data would also work.)
It's obviously easy to write a macro that will save the data from one worksheet to a space-delimited *.prn file. However, I want to save data from several worksheets before it's processed by the other application (in a batch.)
If Excel's "Save As ..." command had a flag for _appending_ its output to a file, that would solve my problem. But that doesn't seem to be an option.
Presumably it'd be pretty simple to write VB code that would append to a file, but I don't know how to write this in VB, and I'm not sure I want to bother learning, just for this task.
So the simplest thing for me would be to do the "Save As ...", followed by a system command that would append the newly-created file to the target file.
(If the above sounds like the thinking of someone more used to working in Unix than in Microsoft apps ... it is ... :-)
Deliverables:
If you want to bid on this "job" (more consulting than programming), my requirements are to comment on the above, specifically the following:
- are shell excapes possible from within Excel, and if so, how;
- if not, how could I get a unique filename for each *.prn file created by several instances of "Save As ...";
- or would it be simple enough in your opinion to just write the VB code that will take the contents of the Excel cells and append them to the target file.
I realize that these are not exactly tight specifications, so I suppose a certain amount of trust is required on your part, that I'll be satisfied with a reasonable depth of knowledge.
On the other hand, if you already know this stuff, it won't take much of your time to tell me about it, particularly since I'd be glad to accept a reply via phone (toll-free from the US or Canada.) And if we find it easy to work together in this way, I'll need other similar help in the future, and will possibly even have some small jobs to contract out.
Any help appreciated, all bids considered.
Platform:
Win 98 or above; Excel 97 or Excel 2000
Must be 100% finished and received by buyer on:
Feb 27, 2002 1:00:00 PM EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$4 (USD)
|
Feb 25, 2002
10:42:58 PM EDT
|
10
(Excellent)
|
|
|
Hi,
4 dollars is for the initial question. We could arrange a system of 'bonuses' for subsequent help.
I beleive that the easiest thing for you to do would be simply to code the output in VBA. Excel's automation object gives you access to the values in each cell in each row in each sheet. Using the FileSystemObject and a TextStream (You must add a reference to Windows Scripting runtime), you can output to a textfile with ease.
As for a longer term relationship, I've been helping people with Access and Visual Basic for years now, and do both types of work every day. Please see my resume for details of what I've done.
You'll find me personable and easy to work with. However, given that I live in Australia, we'd have to confine our correspondence to email and chat.
I hope to work with you in the future,
Avi |
|
|
|
|
|
|