Rank: Advanced Member
Groups: Registered
Joined: 8/16/2019(UTC) Posts: 337  Thanks: 70 times
Was thanked: 21 time(s) in 17 post(s)
|
Hi all I hope you're well. I have tired everything I can think of to get my Excel sheet to automatically move to the next cell using triggers (without using auto next from the start); I wish to delay for 2 minutes and then automatically turn On Auto Next.
I thought the DataSourceAuto NextOn would do the trick but no matter what combination I place in the Data source box nothing works. I've followed the so called 'example' but this doesn't work either!
Could someone here please explain in simple English how to set up the correct Excel sheet , thanks in advance.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 3/20/2014(UTC) Posts: 2,721   Location: Bordeaux, France Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
|
for the delay you can either do it manually (having a shortcut to turn the auto next feature on) when desired or with a script with a sleep command
DataSourceAutoNextOn
then the correct command is DataSourceNextRow
with excel make sure to use this syntax 'Excel/CSV,Sheet1' with no spaces and it is case sensitive
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,072  Location: Belgium Thanks: 283 times
Was thanked: 920 time(s) in 759 post(s)
|
Originally Posted by: Simsyuk  I wish to delay for 2 minutes and then automatically turn On Auto Next.
Code:Sleep (20000)
API.Function("DataSourceAutoNextOn",Value:="Excel/CSV,Sheet1")
Replace Excel/CSV with the name you gave in the datasource setup Replace Sheet1 with the name of the sheet in your Excel File Quote:Could someone here please explain in simple English how to set up the correct Excel sheet , thanks in advance. ????? ; Standard like when you create a new excel
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/16/2019(UTC) Posts: 337 Thanks: 70 times
Was thanked: 21 time(s) in 17 post(s)
|
Thank you gentleman, I noticed my error (hangs in shame), I put 9,000 instead of 2,000 no idea how I missed that, but the script idea is better so will implement that.
Still so much to learn in vMix.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
