Search results for query: *

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

SOLVED!!!! I found that another program I installed is causing the problem (while it is running). It is called EZCapture Pro which allows you to take screenshots of screen areas defined by your mouse. It starts automatically and sits in the icon tray. A user defined/assigned hotkey causes it...

I assumed that if the names are the same in both systems for the resource (employee) and the named project and task are the same, that would be the only fields needed (and obviously the date). If you are saying that MSProject can only use its unique identifier for these fields and these...

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

The option of "Break on unhandled errors" is selected. This only started recently, after my OS upgrade from Windows 2000. I now have XP Professional. I can't figure this out for the life of me. Thanks for your quick response!!!

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