BookmarkSubscribeRSS Feed
A_B_C
Calcite | Level 5


Hi,

I am using the following code

 

filename flname dde "winword|C:\Users\\Desktop\Macro Test\mu166-2011-011 statistical analysis plan_final.docx!listings"

where I am getting an error:

 

ERROR: Physical file does not exist, winword|C:\Users\\Desktop\Macro Test\mu166-2011-011 statistical analysis plan_final.docx!listings.

But when I change file name to simply 'C:\Users\\Desktop\Macro Test\MU SAP.docx!listings' then it is working fine and no error.

It would be greatly helpful if someone can help me to resolve this issue.

Thank You.

1 REPLY 1
jwsquillace
SAS Alumni

Referencing the DDE External File

SAS(R) 9.3 Companion for Windows

The syntax shown for DDE in the Windows companion is:

filename test dde 'winword|"c:\temp\testdde.doc"  !NUMBER' notab;

Notice the double quotes around the filename inside the single quotes enclosing the DDE triplet.

Jan

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2716 views
  • 0 likes
  • 2 in conversation