Search results for query: *

Thanks, the Excelforum one looks like it will work for me, when combined with grabbing the default drive from the file opened. Also, if I put it in the workbook open event, that should take care of everything. Thanks!

A bit more History: Th reason for this is that I have a USB Jumpdrive. I have spreadsheets and other files that are stored on the drive that I need to be able to access while using different computers. Sometimes the Jumpdrive is the E: drive, others it is G:, etc. You get the picture. I...

Thank HitchUser, I appreciate the input. But, I was looking for something that could be done once inside Excel. I've tried: application.defaultfilepath but it still tries to open in the file path of when Excel opened.

I have an application that I want to have Excel open files in a specific directory. I don't want to hard-code the directory in the module. I tried a few things, but Excel always looks in the default directory used when it starts. ie: "c:\documents and settings\user\my documents\" How can I...

Coding in /free and using embedded SQL can be an ugly read. I like the suggestion of putting the fixed format code into a subroutine, however, that won't work when using a cursor doing the equivelant of: setll read dow not %eof <process> read enddo The record fetch has to be part of the loop.

Compile the program with the following options: COMMIT(*NONE) CLOSQLCSR(*ENDMOD) This turns off the commitment control issue you mentioned, but also closes the cursors when the program ends.