Automating a weekly meal planner template.

  • Thread starter Thread starter Dylan56
  • Start date Start date
D

Dylan56

I have posted to alt.binaries.freeware a template I did up. (Pls see
the second, modified version.)

For two months now have been trying to get this concept into a
template with automation. I had no luck in WP because I couldn't find
a scripting expert in the forum I went to, so was hoping to have more
luck in this Excel version.

The basic template is complete. I just need a pulldown calendar where
I can pick the start date, say today and it would dump today's date
(in the pre-configured date format) into <vStartDate> and <vDate1>.
Then for a calculation to take over and dump the next 6 dates into the
next 6 title rows that have <vDate1+1>, <vDate1+2>, <vDate1+3>, etc.
and then have the name of the last day of the week chosen not only
dump that date into <vDate1+6> but into <vEndDate>. btw, I imagine
it'll just be easier to have <vDate1> and <vDate1+6> for the top dump
instead of <vStartDate> and <vEndDate>, I wasn't thinking.

I'll go re-post a third copy <sigh>. We newbies, eh?!!!

Here's hoping someone understands enough of what I mean to make sense
of this and can come up with coding for it. I know WP coding to some
degree VB Excel scripting not at all!

Thanks in advance!! This is for medical reasons not diet loss, and
it's vital I start planning my meals better for my health's sake.
Nothing out there does the job. This will once it's automated. Make
life a snap.

Cheers!
 
I have posted to alt.binaries.freeware a template I did up. (Pls see
the second, modified version.)
Click to expand...

[snip]

At this point, there is a third copy and it's best to start with.

Thanks and sorry, hope I haven't confused anyone with all the versions
I made. The third one, I believe, is probably the best to work with.

Tx!
 
Dylan, I have not look at your sheet, can't find the newgroup
alt.binaries.freeware, but can you just type the date in your first cell,
vStartDate and put =vStartDate in vDate1 and then put a formula in the
others to "dump the next 6 dates " like this =vDate1+1, =vDate1+2 and so
on?
Click to expand...

It needs a script, Paul B. That way, whenever I can pull it up, I can
just select the first date via a date chooser box and the macro will
take care of the rest and dump the rest in.

I know I could do it manually. In fact that's what I have been doing.
It's a pain in the neck.

If you can't find alt.binaries.freeware, can you suggest another
binaries group and I'll re-post.

Thanks much!
 
Dylan, if you use the formulas the only date you will have to put in is the
first date, if you want to send me a copy of the workbook, and what you want
to do and I will take a look at it. ** remove news from my email address
first**


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Very odd, but I tried emailing to (e-mail address removed) but I get this
error message:

"Sorry! An online error occurred.
When: Sending email message "..."
Reasons: Error reported by Server: 550 relaying mail to surfbest.net
is not allowed."

I've emailed through Agent before and I believe I've done everything
right. I'm going over to the Agent ng to find out what "550" means.

Will report back.

Tx.

****************
 
Dylan, the problem might be on my end, I have not received any mail today
and just tried to send mail to that account from another account and I did
not receive it, try this address (e-mail address removed) if the link does not
work there is and underscore _ between pabr and 2001

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Same problem. Agent ng said that you've given an email account where
relaying is forbidden. I get an almost identical message for the
above email. I understand privacy issues so think it best if you just
advise me of a binaries group to post to and I believe we'll have more
success that way.

Just let me know. I'll check in during the day at some point but for
now just waiting for instructions.

Thanks much!
Click to expand...

Sheesh, awfully sorry. Hope that didn't sound bossy. It wasn't my
intention.

Just, if it's okay, let me know of a few binary ngs you can get and
I'll see which ones I get, too, and I'll post there. That okay?

Thanks!

:oD
 
Dylan, files posted to any newsgroup are generally not a good idea, takes up
space and people will sometime not look at them if it has and attachment,
but with that said and because you can get it sent the other way, if the
file is not to big and I don't think it would be the way you have explained
it, can you post and attachment to this newsgroup? Or if you have a computer
at home can you send the file from there? Please make sure the file has some
data in it the way that you need it to be and instruction as to what you
want to do. Paul
 
Dylan, files posted to any newsgroup are generally not a good idea, takes up
space and people will sometime not look at them if it has and attachment,
but with that said and because you can get it sent the other way, if the
file is not to big and I don't think it would be the way you have explained
it, can you post and attachment to this newsgroup? Or if you have a computer
at home can you send the file from there? Please make sure the file has some
data in it the way that you need it to be and instruction as to what you
want to do. Paul
Click to expand...

Paul, hi!

There are two types of ngs, this kind (only text messages) and
binaries (with can carry any type of attachment). You couldn't find
alt.binaries.freeware, so pls feel free to look for a newsgroup that
is a binaries one (but that isn't a smutty one, of course, pls) and
tell me what it is so that I can subscribe to it and post the file
there.

Oh, p.s., you'll have to use another newsserver. I just realized a
possible meaning to what you just wrote4 above. No, the MS newsserver
does not carry binaries at all; I was talking about one with your ISP.
There are hundreds, well perhaps not hundreds, but dozens and dozens
and dozens of binaries ngs. Too many carry porn headers, I know, and
we want to avoid those, but something like alt.binaries.freeware where
those of us who subscribe to alt.comp.freeware, for example, post
files all the time.

Thanks, Paul. And here's hoping you can find one that we both can
subscribe to. Makes it a lot easier than emailing, esp. when there
are email problems like in your case here. Also, anyone from the
group, then, can see the file, too.

Thanks, much!!
 
Dylan, just check on alt.binaries.startrek and I do not see it, will check
later to see if it shows up

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Dylan, just check on alt.binaries.startrek and I do not see it, will check
later to see if it shows up
Click to expand...

I just re-posted, just in case to alt.binaries.startrek. Look for
post (two actually) with subject header: "Re: Test post, pls ignore
(Dylan56)."

Thanks!
 
Dylan, found one post dated 7-16-03 @ 10:04 pm, but there was no file with
it, can you take the file to another computer and e-mail from there?

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Dylan, found one post dated 7-16-03 @ 10:04 pm, but there was no file with
it, can you take the file to another computer and e-mail from there?
Click to expand...

Boy this is turning out to be really difficult. I can't even begin to
guess why you aren't seeing the posts as both text and binary parts of
the posts are coming up perfectly fine. If you found the text
section, the binaries one is around, too. I posted several times so
you'll find several pairs of files.

And, no, unfortunately they don't allow us to do that sort of thing at
the office; it's prohibited (I'm sure you can understand why) and
that's the only other computer I have access to.

I'm ready to tear my hair out.

The only thing I can suggest is that I'll post one last time and take
care to change the preferences to post text/binaries together and then
change back (I separate because I must keep my text messages but do
not have room to keep all the binaries parts - a duplication on my
system that hogs valuable hdd space.

Here's hoping. And hopefully this works; I don't want us to waste any
more time on this. If this doesn't succeed, then I'm at a loss to
know what else to do. Anyway, here goes. (Well, I have to give us
both high points for perserverance, eh??! <g>)

Tx a million.
 
Back
Top