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?
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...
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...
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
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...
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
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
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
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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.