Recent content by whoffman

Sorry, I misunderstood the tagline on your signature. I really appreciate your help but it appears MS will not allow what I want to do. I thought by using the FileSystem procedure I could somehow enumerate through the various properties such as flename, date created, file type, etc. and that...

I would never ask a question without trying to find out if it has been answered before (that's just rude). I searched the forum with "xcel file attributes mp3" and a lot of other terms, but no luck. I checked out the kb you sent but it doesn't pertain to what I need to do (or I just don't...

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...

Thanks so much for the code! I modified it a bit and it works great for me. I'm an old VB programmer, so this SAS stuff is confusing the heck out of me. Things that used to take a few statements, now take ten times that! I really don't think it was meant to be a data manipulation language -...

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...

There is no specific code that causes this to occur. It happens with a great variety of SIMPLE macros. These macros call no user forms. They do have For-Next loops and sometimes Do Until loops. Basically, I start the macro with a step into (F8) and step through inspecting values, then stop...

It was one of the first things I did. Started Task Manager, Processes, and searched for it, or anything that would clue me into what was going on. I have rebooted, gotten a list of processes running, then started my excel thing (the debug stuff). When it started acting up, I got a new list and...

How about thread707-873846 ?

Evidently, the forum goofed. I searched for the problem I was having and found it. The forum stated to reference this thread in any new posts, and it would be included. I did a copy and paste, so how could I have mis-spelled it? Oh well. I doubt if anyone has found the answer yet - it's...

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!

Thanks to all! Thanks George! After tweaking it a bit (I don't have the same (or any) Global.bas file) it worked fine. Much slower than I thought it would be to read 34 MB but its tolerable. Thanks again!

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...

Thanks! I haven't personally worked with the software as far as setting up a project, but I have had to update my actual hours against tasks. I just had to be sure what I wanted to do was possible before we "tweaked" our legacy system to add the necessary projects and tasks. I appreciate your...