System error h80070057 2147024809 параметр задан неверно excel
MS Project 2010 - VBA - MultiPage Form - System Error "&H80070057 (-2147024809). The Parameter is incorrect"
Вопрос
I have succesfully written some VBA code that uses a User Form to prompt the user for information to support time phased data extraction from MS Project 2010 Professional to MS Excel. When the form is modified to use the the MultiPage control (no other changes), you can click through the tabs successfully with no problems. However, when doing a local save of the MS Project file (Save As to local drive, not a save to Project Server), I receive the following error message:
"System Error &H80070057 (-2147024809). The Parameter is incorrect" and then MS Project 2010 crashes.
Все ответы
Are you saying that it worked fine before you added the Multipage control?
Yes sir. The code works as designed if I do not use the MultiPage control.
I was trying to make the form a little more user friendly by grouping content into multiple pages. The only code change is the addition of the line "MultiPage1.Value = 0" to make sure page 1 is the initial page displayed. Otherwise, the code is identical.
Okay, I'll check it out later today when I get some time, unless someone else jumps in with a quick answer. Meanwhile, did you check out the thread I referenced, particularly the two hotfixes noted by Rod Gill?
Yes, I plan to check to make sure all of the hotfixes are installed. It is possible one of the hotfixes may have already addressed the issue.
I can't say that a hotfix is relevant because I can't duplicate an issue. However, I don't work with Project Server so I don't have the same "test bed" that you have. What I did do was to create a simple userform with a multipage control. I entered the single code line "MultiPage.Value = 0" and ran the userform code. I did this with two cases, one with the userform resident in the Global, which is the default with Project 2010, and one with the userform resident in the test file. In both instances I used Save As on the test file. No problems occurred.
I'm not sure what to tell you at this point. In a Project Server environment there might be an issue that simply doesn't show up with a stand alone installation. Read the descriptions for all hotfixes and see if there is any mention of this item. If not, hopefully someone who is versed in Project Server will jump in and offer a suggestion.
Thanks John. I appreciate the assistance!
You're welcome but I'm not sure I really helped. However I did have some additional thoughts since I last posted.
You indicate that things go awry when you add the initializing statement:
The multipage control should automatically default to page 1 when the userform is loaded and that should make the above line of code unnecessary. Did you try that?
Also does this failure occur if you create a simplistic unserform with only the multipage control for a simple test file? I'm skeptical that just adding that line of code is the source of the problem. The more you can isolate the condition, the better chance of finding a solution.
I have a tool for changing the font of the text and applying border to the text box in a presentation.
It works normally on text inserted in the text boxes. But when I insert a Table and then do these changes on the table without selecting the whole table, it gives me the following error -
Run-time error '-2147024809 (80070057)'
The specified Value is out of range
I tried to debug this error but could not find anything. All I know is that it occurs at this line [Bold] -
Dim v1 As TextRange2
For Each v1 In ActiveWindow.Selection.ShapeRange.TextFrame2.TextRange
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
Report abuse
Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
If you are selecting a Table, or just selecting the text in one cell of the table (or if you just select the text in the TextBox and not the TextBox itself), the Type of the Selection changes and you must deal with it slightly differently. Try something like the code below.
Hope this helps,
Sub testit()
Dim i As Long
Dim counter As Long
Dim v1 As TextRange2
Dim myTable As Table, myRow As Row, myCell As Cell
Report abuse
Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.
I recorded a macro to change the text on a button to show the current date.
The worksheet is not protected.
When I shared the Workbook, and click on the button, I get this error:
Run-time error '-2147024809 (80070057)':
Requested Shapes are locked for selection
I unchecked the "Lock" and "Lock Text" (when I right click on the button and click "Format Control" and under "Protection" tab), but it didn't resolve the issue.
I want the macro to work while it is being shared.
2 Answers 2
You cannot access some Objects/Class when you had it Shared/Protected. But what your goal is can be achieved, you don't have to change the Fonts once it is done (bare in mind that this Sub should only be called when the ActiveSheet had this button):
EDIT
To change Shapes when it is Shared, you first need to UnShare it, make changes and then Save it SharedAccess.
Try add another button and assign it to MakeButtonRedBold :
Thank you so much for this. This code works while the workbook is being shared. Would you happen to know how to make the text bold and the color red. I tried do this "ActiveSheet.Buttons("Button 1").Font.Bold = True" but when I shared the workbook and click it I would get a runtime error 1004 unable to set the bold property of the font class. Thank you again for the assist.
@Wiz321 See EDIT for changing Fonts in shared workbook. The method is to un-share before change, then save-as shared afterwards.
I got same error when trying to view png files in vb6.0 sp6 win10-64bit. Maybe you could use it.
Short answer: On Error Resume Next
All code that showed a png file, i found out yesterday.
Changed to Image1.image on Form1 because properties: Stretch = True
Dim img As New WIA.ImageFile
img.LoadFile "c:\temp\test.jpg" ' ok filetypes png jpg gif tif
Set Image1 = img.FileData.Picture
Set img = Nothing
To Fix (Microsoft Excel - Run-Time Error '-2147024809 (80070057)') error you need to follow the steps below:
Совместимость : Windows 10, 8.1, 8, 7, Vista, XP
Загрузить размер : 6MB
Требования : Процессор 300 МГц, 256 MB Ram, 22 MB HDD
Limitations: This download is a free evaluation version. Full repairs starting at $19.95.
Microsoft Excel - Run-Time Error '-2147024809 (80070057)' обычно вызвано неверно настроенными системными настройками или нерегулярными записями в реестре Windows. Эта ошибка может быть исправлена специальным программным обеспечением, которое восстанавливает реестр и настраивает системные настройки для восстановления стабильности
If you have Microsoft Excel - Run-Time Error '-2147024809 (80070057)' then we strongly recommend that you Download (Microsoft Excel - Run-Time Error '-2147024809 (80070057)') Repair Tool .
This article contains information that shows you how to fix Microsoft Excel - Run-Time Error '-2147024809 (80070057)' both (manually) and (automatically) , In addition, this article will help you troubleshoot some common error messages related to Microsoft Excel - Run-Time Error '-2147024809 (80070057)' that you may receive.
Примечание: Эта статья была обновлено на 2022-05-03 и ранее опубликованный под WIKI_Q210794
Contents [show]
Meaning of Microsoft Excel - Run-Time Error '-2147024809 (80070057)'?
Ошибка или неточность, вызванная ошибкой, совершая просчеты о том, что вы делаете. Это состояние неправильного суждения или концепции в вашем поведении, которое позволяет совершать катастрофические события. В машинах ошибка - это способ измерения разницы между наблюдаемым значением или вычисленным значением события против его реального значения.
Это отклонение от правильности и точности. Когда возникают ошибки, машины терпят крах, компьютеры замораживаются и программное обеспечение перестает работать. Ошибки - это в основном непреднамеренные события. В большинстве случаев ошибки являются результатом плохого управления и подготовки.
Causes of Microsoft Excel - Run-Time Error '-2147024809 (80070057)'?
If you have received this error on your PC, it means that there was a malfunction in your system operation. Common reasons include incorrect or failed installation or uninstallation of software that may have left invalid entries in your Windows registry, consequences of a virus or malware attack, improper system shutdown due to a power failure or another factor, someone with little technical knowledge accidentally deleting a necessary system file or registry entry, as well as a number of other causes. The immediate cause of the "Microsoft Excel - Run-Time Error '-2147024809 (80070057)'" error is a failure to correctly run one of its normal operations by a system or application component.
More info on Microsoft Excel - Run-Time Error '-2147024809 (80070057)'
Hi, I recorded a macro that will change the text on the button to show the current date. (80070057)': Requested Shapes are locked for selection Does anyone know a workaround for this? When I Shared the Workbook I get this error: Run-time error '-2147024809 work while it is being shared. I want the Macro to
Please try the code here?
I need to solve this urgently thanks
enable the marco. I am using microsoft excel 2007. The file still cannot be view, there is a error saying " RUN
The code of the macro have some error.
I encounter an error while opening an excel file, i could time error '1004' the specific dimension is not valid for the current chart type. Can you post you. Thank to help. But after i not view the file and it tell me to enable the macro.
problem updating some apps.. I've already searched on the internet but none of them answered or fixed my problem. For help me out. It always gives apps you want.
And put back your example: 6snap. Remove Your installed on your phone instead of SD card. Hopefully someone can Thx! Install the may have the Same problem.
Solved for those who SD card. Change the setting that apps will be SD card. :) I have a me the same error.
How can i fix can't use my apps like Facebook, store and my Microsoft account. My Nokia lumia 620 give me error code 80070057 I it please help.
Getting problem while downloading updates that is 80070057 error how can i resolve it in my nokia lumia 920
I just bought over my friends laptop.
по автоматической сумме мне нужно, чтобы сумма была отображена как
ячейка
и если сумма меньше 8 ..
я хочу использовать две формулы
Thank you very much. - Mak
level is 'beginner Level'. My computer literacy
I am using me nuts!
Ive downloaded MSFix, no success, please help? Could someone downloaded the standalone updater, no success. This is driving great with computers, and have tried just about everything that has been suggested on forums.
I know, its probably been done to death, but I am not really that Vista Home Premium.
Я просто пытался обновить свой компьютер (не обновлял его, я попытался обновить его с помощью Windows Updater. Первый, код ошибки 80070002 был отображен, когда
Следуйте инструкциям проводки Windows Update и отправьте запрошенные данные.
в течение длительного времени), и мне были предложены эти ошибки 2. Он не сделал, и теперь я, опасаясь, что загрузка торрент-файла (не порно) могло вызвать это с помощью вирусной инфекции?
I have been updating the windows 8.1 to 10 from yesterday but each time i get stuck at preparing to install option with error code 80070057.
I've just run the SFCFix tool, which is showing that cliconfg.dll See the attached log file. I've already tried numerous repairs including - The Windows Update Readiness tool, the System any help. Thanks guys.
File Check tool from command prompt, chkdsk, CCleaner, SpyBot, and the Windows Update Diagnostic tool.
I'm an IT Tech by trade, so is corrupt, and the Windows Update Readiness tool shows Error 80070057.
I was having an issue with downloading new updates, and have noticed some problems with my laptop recently, so have been trying to fix them. Basically though, I've come usually this is no problem for me. I'd appreciate across something I can't solve.
I have a dell 7, update error 80070057, that is now happening in my upgrade to windows 10.
I am trying to solve the same update error that I had in windows latitude e6400.
update works well now except for downloading windows 10. Things I've tried:
removed Softwaredistribution and the download folder inside it multiple times. It's me again.. Tried and then fails with the 57 error.
Fixed most of my windows update issues and windows everything. I think I'm Running wuauclt.exe /updatenow downloads the setup files having the same issue.
Ran 64 bit Software updated SP1 with no problems. My other 4 computers 7 ? rebooted
2.
Я использовал Windows Update для запуска Windows Updater
5. Любые мысли,
Майкл Лоури
Колорадо-Спрингс
Я успешно установил SP-1 со следующей процедурой:
Ran 64 bit Windows Updater system checker and checked the two logs generated, no errors or problems there. Scanned for the Essentials update, but SP1 update, it updated all except the SP1 package. Checked services.msc, found hopefully they can update the SURT and the SP-1 Automatic Update to fix the problem. Reinstalled Windows Update Readiness Tool ? rebooted
6.
Во время переустановки программное обеспечение сообщило: Net Framework SP-1 Standalone Installer? перезагружена
7. Был отремонтирован путем повторной установки, который оставляет файлы и установленные программы неповрежденными.
Went into manual mode, went to the download site, pre-installed the 4826 not found on the MS download site.
Я запустил W7 Update TroubleShooter, загрузил и запустил W7 Windows V. 4 необходимо отремонтировать
3.
Trying to migrate from windows 7 to media creation tool Use the windows 10 windows 10 If windows update is not working.
I'm trying to upgrade to window fix this?
How can I 10 but there's an error code 80070057.
Paste the MGA Diagnostic Report My notebook the "Windows" tab is selected (it should be by default). I found every time I boot it up a process called command service.exe fix this problem for a while and no success. I have a HP(Compaq nx5000) notebook with Windows Vista Ultimate, post back the report it shall produce:
Загрузите MGADiag на свой рабочий стол.
When trying to run windows is extremely slow. Regards
MGA Diagnostic Report to the Windows clipboard. Here it is my log to see of you happen to see anything unusual. If so, do the following:
Please run the MGA Diagnostic Tool and I tried to install SP1 manually and no luck either.
Дважды щелкните файл MGADiag.exe, чтобы запустить программу.
Нажмите "Продолжить".
Ensure that running I kill it every time but no luck to get rid of it. Click the "Copy" button to copy the update I get error 80070057.
Hi, I need help on this, I've trying to back here in your next reply.
Everytime I try to update to Windows 10 I get an error code 80070057.
Ie: date time data15/7/03 00:00:00 25.3615/7/03 00:00:30 12.6315/7/03 00:01:00 25.3617/7/03 00:01:30 15.8815/7/03 00:02:00 36.1117/7/03 00:02:30 41.2217/7/03 00:03:00 25.33. I will like to select the hourly data only.
Пожалуйста, помогите мне в руководстве к функциям Excel.
Click here for a good select time series excel data. Please help me provide the function .
Hi guys,
I am a little bit stuck on how to get round this problem. I am creating a macro to insert a watermark, and I am using Visual Basic to create this macro on Microsoft Word 2010, but I keep getting an error message saying:
Run-time error '-2147024809 (80070057)'
The item with the specific name wasn't found.
I have copied and pasted the code below. and when I click debug, the code it highlights is: Selection.HeaderFooter.Shapes("WordPictureWatermar k102522967").Select
-------------------------------------------------------------------------------
Sub Macro1()
'
' Macro1 Macro
'
'
ActiveDocument.Sections(1).Range.Select
ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
Selection.HeaderFooter.Shapes("WordPictureWatermar k102522967").Select
Selection.Delete
ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument
ActiveDocument.Sections(1).Range.Select
ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
Selection.HeaderFooter.Shapes.AddPicture(FileName: = _
"G:\A levels\AS ICT Folders\IT2 - PRACTICAL\Task 2 Automated Doc\watermarkimage.jpg" _
, LinkToFile:=False, SaveWithDocument:=True).Select
Selection.ShapeRange.Name = "WordPictureWatermark102632823"
Selection.ShapeRange.PictureFormat.Brightness = 0.85
Selection.ShapeRange.PictureFormat.Contrast = 0.15
Selection.ShapeRange.LockAspectRatio = True
Selection.ShapeRange.Height = CentimetersToPoints(19.5)
Selection.ShapeRange.Width = CentimetersToPoints(18.45)
Selection.ShapeRange.WrapFormat.AllowOverlap = True
Selection.ShapeRange.WrapFormat.Side = wdWrapNone
Selection.ShapeRange.WrapFormat.Type = 3
Selection.ShapeRange.RelativeHorizontalPosition = _
wdRelativeVerticalPositionMargin
Selection.ShapeRange.RelativeVerticalPosition = _
wdRelativeVerticalPositionMargin
Selection.ShapeRange.Left = wdShapeCenter
Selection.ShapeRange.Top = wdShapeCenter
ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument
End Sub
I have already tried deleting the code: Selection.HeaderFooter.Shapes("WordPictureWatermar k102522967").Select
Selection.Delete
. but it just keeps highlighting the line below for all of the code and soon I am left with no code lol.
Читайте также: