Can QV Externally Update Excel Data?

[#1]

Hiya Guys,

I have an issue where I would like to import Excel data into QV using a Load Script, then change the data in some of the cells in the Excel Spreadsheet, and then import the new data.

We have a spreadsheet which has many dependent formulae on it - and manually changing just one cell updates the whole spreadsheet.  Instead of having to do this manually - is it possible to automate the process from a QV Load Script?

Cheers,

Steve.

[#2]

Thanks flipside,

Looks like a useful VB Script!  I haven't tried it but it's very useful to know that a solution is (may) be possible  🙂

This is exactly what I've done, although I think I was trying to just add another (unnecessary) step!  🙂

I would like to create a Subroutine/Function within the Load Script which accepts parameters... is this possible?

Cheers,

Steve.

[flipside]

Do you mean like this (which works) ...

sub TestMessage(txt)

    x = MsgBox(Upper(txt));

end sub

call TestMessage('HelloWorld');

flipside

[#4]

Thanks flipside,

However, I could not get this to work for some reason... I could not call the Function from another tab (or from within the same tab - for that matter!).

Cheers,

Steve.

[flipside]

Strange!

Are you talking about the TestMessage sub which should be in the Load script or the earlier function which resides in the Module script?

[#6]

I'm refering to this example, above:

sub TestMessage(txt)

    x = MsgBox(Upper(txt));

end sub

call TestMessage('HelloWorld');

I have tried this in the Load Script and it works... however I cannot get the same results when attempting to use the Excel function.  It must be something I am overlooking, not to worry!  😄  I appreciate all your help.

Cheers,

Steve.