Search results for query: *

Is there a way to programatically list the various descriptors available and their values on the files within a directory? I know the standard ones are available (filename, date created,etc), but how about the others (camera for JPG, artist, genre for MP3) ? Do a right click while in the...

I created an external storage for department compiled macros, and I cannot compile into this directory while someone has SAS running on their desktop. Is this normal? Is there a share command I can issue or something? NOTE: The SAS System was unable to open the macro library referenced by the...

Help. I'm new to SAS and I have written a macro to process against several external Excel files. I cannot figure out how to pass the different filenames to the macro to process one at a time. I have a SAS dataset (180 observations) with the variable "fn" that contains the filename I want the...

I am building an app in VB6 that utilizes drag'n'drop for items in a listbox. It works great with the standard ocx, utilizing the OLE functionality. The main drawback is I'd like to display individual items in each list in a color font based on some criteria. I found a free list OCX that...

In reference to archived posts, thread222-6296, has anyone figured out a solution? It is driving me nuts! I have to reboot every time I debug an Excel macro. Thanks in advance!

Hopefully someone can enlighten me. I am trying to read a large (33MB) text file created in a Unix environment. It has no line feeds, just carriage returns (or the other way around). I am trying to read into a user defined type. That doesn't work and the error code is cryptic, at best. I...

Is there any way to import actual hours (by project,task, and employee) into MS Project via a CSV or XML file from a legacy time tracking system. It seems wasteful to have to input hours twice into two systems and hope they agree. Thanks

After "upgrading" to XP, I have noticed that whenever I process a macro and it breaks with a message asking me to end or debug, no macros will run smoothly from then on. Even closing Excel and starting with a different spreadsheet, the macro will 'break' at various points and ask me to end or...

I recently upgraded OS and Office to XP and I am having great difficulty getting old Excel macros to work. One especially troubling one is the filesearch(). I have a directory with at least one *.zip file but I cannot get it to enumerate with the following code: Dim fnmes(10) Set fs =...

This has to be a simple thing but, when I paste into a column from another source, and change the format (from dd-MMM-yy to mm/dd/yy hh:mm, for example), the change will not appear unless I double click each cell! Is there a way to force the change to appear?

I have tried everything and looked everywhere but can't find the answer to this one. I am trying to copy a chart in Excel and paste it into a Powerpoint slide (using macros, of course) and I can't see a way to do it. DDEInitiate fails on my machine, it asks if I want to start MSProf.exe - when...