Search results for query: *

I borrowed this code from the help file, which correctly identifies the drive and path of a specific file, where the (drvpath) parameter is passed to the module from a previous module where I had to specify drvpath=Z:\data\cms\importfiles What I would like to me able to do is have the system...

Is it possible, or is there a function which will look at the OS and tell you which Drive (be it Local C: or Network Z:) you are on. I have had a look through the Help! file but the only options I could find related to being able to isolate or establish the user drive and path, when you supplied...

Hi there, I was wondering if anyone knows how to stop the message 'Do you want to Save <filename>', when you close a file from within a macro. Up to now I have just had to let the user say 'Yes' or 'No' but it would be nice to just be able to do it without confusing the user. Thanx in...

Thanks for that, but as part of the process I do save the file as I need to keep the new information. As that is the case I can always save it in a different location, but it doesn't stop the fact that I would still like to be able to delete a/the file on the fly. Seeing that Activate, Close...

As part of a small application where I open a number of different files and extract some data, I then save the newly created sheet. As the VBA code is static in this sense, I need to be able to delete the newly created file. If the processed file is opened using - Workbooks.Open...

I want to be able to utilise a procedure across multiple form modules, but find that when I try this, there is no way the procedure is recognised in other sections of the code within the pjoject. Can this be done or is it a limitation of VBA? Many thanx