editing a value within another excel (or non-excel) script.

[Kramxel]

Hi There,

I have set up some scripting within excel to automate some report production, getting data from a call solution called CMS. It works great so long as the data I require is from yesterday. It kinda falls down when I need data from 3 or 4 days ago. I have around 15 scripts set up (each getting a specific piece of data) that all contain the following entry to specify the date its requesting data for:

Please Login or Register  to view this content.

where -1 indicates the previous day.

I also run the following code to run through each of the scripts sequentially (means I only have one click or task to schedule rather than dozens).

Please Login or Register  to view this content.

What I would like would be a "pop-up" box open that will allow me to enter a value that replaces the "-1" in each of the scripts it then opens and runs. I could enter -3 or a specific date in the fomant "DD/MM/YYYY".


Is this possible?

your help is greatly appreciated.

[tandwfund]

Hi Kramxel,

A couple of options.

1. Select a specific cell (could be in this workbook or not) for your -1 or -3 entry and reference that range in your Date code. Whatever you type in this cell will be reflected in the date.

2. I use a calendar form and have specified a specific cell to place the date that is picked from the calendar and then reference that range in my code. You can set the date format to be compatible with your scripts.

T

[Norie]

Can you actually read/write from these scripts?

[AlphaFrog]

Maybe something like this...

Please Login or Register  to view this content.

Not sure if CDate(d) is an acceptable data type for the Rep. property

[Norie]

Is this in the script(s) you are running or in VBA?

Please Login or Register  to view this content.

[tandwfund]

Hi Norie - I use the calendar and a company list box to create a dynamic URL that I call from the macro by setting the range cell - E30.

Excel formulas and formating get the URL in order then the macro copies and pastes special the URL in E30.

Please Login or Register  to view this content.

[Norie]

tandwfund

Are you sure you are in the right thread?

[tandwfund]

Norie - thought you asked me a question in #3.

[Norie]

That was a question for the OP, Kramxel.

[tandwfund]

Norie - sorry for the confusion.....

[Kramxel]

Is this in the script(s) you are running or in VBA?

Please Login or Register  to view this content.

this is in the script i'm running.

[Norie]

So can you read/write these scripts?

[Kramxel]

Apologies for the late reply - had a bout of sickness and just couldn't bring myself to sit in front of a computer, until a couple of days ago. A few days off and I managed to solve the problem when I got back. Having solved this problem I now have another that i'll post in a seperate thread.

Thank you and apologies all rolled into one.