Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SpaaamCatcher

    Run-Time Error 1004 - Version Problem?

    It is being called by another sub, which is initiated by a form button. But - if I just run it from within VBA, it still fails, so I suspect it's not related to how it's being called. Any chance there's something corrupt in the template?
  2. SpaaamCatcher

    Run-Time Error 1004 - Version Problem?

    HELP! This is too simple to drive me crazy ;-) The 'Activate' statement seemed like it would be perfect, so I tested it out in a clean workbook and it worked fine. Take the same code and paste it into my workbook and it fails! WHY would such a simple statement (see below) result in a run-time...
  3. SpaaamCatcher

    Run-Time Error 1004 - Version Problem?

    I have created a fairly complex spreadsheet, but one of the most simple pieces of it is failing at the client machines. The whole thing works perfectly on my machines (office 2K or XP), but I'm not equipped for regression testing and the machines having a problem are 97. An example of the line...
  4. SpaaamCatcher

    Running Code from Shared Workbook

    Thanks for your response. There is only one person who generates the file, once all the managers have entered their data (by noon), so I think your original idea of copying the data into a new workbook and saving it off may be the cleanest solution. Thanks for sticking with me on this! Jamie
  5. SpaaamCatcher

    Running Code from Shared Workbook

    Sure! Thanks for your help. We're implementing a data warehouse to better handle this data, but in the interim (and during testing)... We need to allow multiple departments' managers enter their statistics once a day. For this reason it needs to be shared. I then programmatically manipulate...
  6. SpaaamCatcher

    Following is an extract of the scri

    YES! Yes! It works, you rock. Thanks so much. If you get a second, oh VBAjedi mastah, check out my other (more urgent, even) problem in thread707-697129. I've got a some code that works perfectly until the workbook gets shared... Jamie
  7. SpaaamCatcher

    Running Code from Shared Workbook

    Hi, Richard. Holiday time in Belgium? I'll come on over and join you... I remarked out: ActiveWorkbook.SaveAs FileName:=CompleteFile, _ FileFormat:=xlTextPrinter and, although it doesn't generate the text files I need, everything runs through fine. Help! Jamie
  8. SpaaamCatcher

    Following is an extract of the scri

    IF the value in cell A1 = "C:\Folder1\Folder2" and Folder1 exists, the code will generate Folder2. HOWEVER, if Folder1 does NOT exist, I get a 'PATH NOT FOUND' error and nothing gets created... jem
  9. SpaaamCatcher

    Following is an extract of the scri

    Geoff, I am trying to do what Mike was: create a directory structure that may be longer than one folder. I was hoping to do it in one pass, but based on this trailer it looks like I won't be able to. I tried to translate this code to be applicable to my situation, but haven't been able to. Can...
  10. SpaaamCatcher

    Just Create the Dang File!

    I was so hopeful! But no luck. I did a basic test: MkDir "C:\Folder1" and it worked. But if I say MkDir "C:\Folder1\Folder2", I get the same 'path not found' error. Any ideas? This seems like it should be basic, but clearly I'm missing something... jem
  11. SpaaamCatcher

    Just Create the Dang File!

    Hi, there. I want to programmatically create a folder path that has been defined in a particular cell in Excel, and it works, but not all the way. If the user enters a value in cell A1 equal to: "C:\Folder1\Folder2", I want to check if this path exists and then create it if it...
  12. SpaaamCatcher

    Running Code from Shared Workbook

    Thanks for your response (and your sig-brought me a smile). Although I can't use the 'stop' method you were talking about (since in shared mode the VBA editor will not open under any circumstances), I will step through (unshared) to take a look at the value of the CompleteFile variable. However...
  13. SpaaamCatcher

    Running Code from Shared Workbook

    Hi, there. Okay, I did a little testing. I made visible the two that were hidden and removed the protection from all of the worksheets so there shouldn't be any problem with security, but I still get the message: RUN-TIME ERROR '1004'; Method 'SaveAs' of object '_Workbook' failed. This works...
  14. SpaaamCatcher

    Running Code from Shared Workbook

    Hi, Richard. Thanks for your response; sorry for the delay in mine. It is difficult to identify exactly where the code is crashing, since I can't step through it when it is in shared mode and I don't have the problem when it's not. There are five sheets in the workbook, three of which are...
  15. SpaaamCatcher

    Running Code from Shared Workbook

    Hi, there. I need to find a way to run code from a shared workbook whereby one of the spreadsheets is saved off in text format. We will be doing parallel integrity testing for a new system for several months and I'm trying to make it easier by programmatically generating a text file from an...
  16. SpaaamCatcher

    Running Code from Shared Workbook

    Hi, there. I need to find a way to run code from a shared workbook whereby one of the spreadsheets is saved off in text format. We will be doing parallel integrity testing for a new system for several months and I'm trying to make it easier by programmatically generating a text file from an...
  17. SpaaamCatcher

    Excel VB error

    RUN-TIME ERROR '1004'; Method 'SaveAs' of object '_Workbook' failed We will be doing parallel integrity testing for a new system for several months and I'm trying to make it easier by programmatically generating a text file from an excel spreadsheet which is shared. My understanding is that you...
  18. SpaaamCatcher

    Dynamic Relative Linking-Formula

    Well, thanks for your response, I think. I did not architect nor implement this solution, so take it easy. Considering that I'm an Oracle DBA (and NOT an Excel guru), I'm quite familiar with good and bad DB design techniques, so your oh-so-helpful comments don't apply here, since it's not in a...
  19. SpaaamCatcher

    Dynamic Relative Linking-Formula

    Hi, there. I have a series of spreadsheets which I am linking to and summarizing in another workbook; all of these files are in the same folder. I would like to be able to replicate this folder for each pay period and automatically have the summary spreadsheet look in its current directory for...

Part and Inventory Search

Back
Top