J
John Alexander
Hello,
I am linking to many tab delimted text files, which are
not always consistent (i.e.-sometimes columns will be
missing altogether upon refresh, causing problems with
the linked data).
I may have found a solution by using the "send keys"
action Macro. This seems to work perfect all the way up
to the very end, when the final confirmation
message "finished linking table..." appears. I have
tried everything I can think of to either eliminate the
pop-up (set warnings on to "No") and hardcoding the final
{enter} or ~ to emulate clicking "OK". My understanding
is that the final message halts the macro, so a
knowledgebase article suggests moving the {enter} or ~ to
BEFORE the key which causes the confirmation pop-up. I
tried this...still doesn't work. I feel that I am SO
close with this solution. Here are the keys I am sending
after setting warnings to "No":
%fglc:\data\mel\excel stuff for john a\Pitch 35P.txt%
kdnrn%nPitch 35P%fy~
The final "~" is to simply enter "OK" after the
confirmation, but it wont work.
Please help...
I am linking to many tab delimted text files, which are
not always consistent (i.e.-sometimes columns will be
missing altogether upon refresh, causing problems with
the linked data).
I may have found a solution by using the "send keys"
action Macro. This seems to work perfect all the way up
to the very end, when the final confirmation
message "finished linking table..." appears. I have
tried everything I can think of to either eliminate the
pop-up (set warnings on to "No") and hardcoding the final
{enter} or ~ to emulate clicking "OK". My understanding
is that the final message halts the macro, so a
knowledgebase article suggests moving the {enter} or ~ to
BEFORE the key which causes the confirmation pop-up. I
tried this...still doesn't work. I feel that I am SO
close with this solution. Here are the keys I am sending
after setting warnings to "No":
%fglc:\data\mel\excel stuff for john a\Pitch 35P.txt%
kdnrn%nPitch 35P%fy~
The final "~" is to simply enter "OK" after the
confirmation, but it wont work.
Please help...