Run Time Error 1004
in [Visual Studio]
|
From: GS on 14 Jul 2010 13:48 As already suggested by others, this is MSO VBA and not VB6. <FYI> You can't 'Move' all the sheets in an Excel workbook because a workbook must always contain at least 1 visible sheet. That suggests that you must adjust your isheetcount variable to be less than the number of sheets in the workbook, OR add a blank sheet if you need to move all the sheets to new workbooks. Another approach is to just use 'Copy' and a new workbook will be opened automatically with just the copied sheet. Then just save it as you are doing. HTH -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc
From: Auric__ on 15 Jul 2010 10:46 On Wed, 14 Jul 2010 15:13:02 GMT, Nobody wrote: > "Auric__" <not.my.real(a)email.address> wrote in message > news:Xns9DB54FCAE25FCauricauricauricauric(a)85.214.73.210... >> If that doesn't fix it, I suggest you try asking in an Excel-specific >> group. >> microsoft.public.excel.programming is the best, if Google carries the MS >> groups (which it *should*; if not, try something besides Google). > > MS removed the Excel group, but here is a free news server that still > carries it: Many (most?) free servers carry microsoft.*. For that matter, many pay servers do, too. -- - What do you call a person who keeps on talking when people are no longer interested? - A teacher?
From: Viken Cerpovna on 15 Jul 2010 18:42 "Mayayana" <mayayana(a)invalid.nospam> wrote in message news:i1kdqd$93b$1(a)news.eternal-september.org... > Is that VB.Net? Or maybe MS Office VBA? > Whatever it is, it's not VB. This group is > for VB (VB5/6) questions. > Mayayana, Could you point to where this is stated? I haven't been monitoring this group for very long but I thought it was just for Visual Basic in general. Why would VBA or the other versions of Visual Basic not be discussed here? Thanks, Viken
From: dpb on 15 Jul 2010 19:16 Viken Cerpovna wrote: > "Mayayana" <mayayana(a)invalid.nospam> wrote in message > news:i1kdqd$93b$1(a)news.eternal-september.org... >> Is that VB.Net? Or maybe MS Office VBA? >> Whatever it is, it's not VB. This group is >> for VB (VB5/6) questions. >> > > Mayayana, > > Could you point to where this is stated? I haven't been monitoring this > group for very long but I thought it was just for Visual Basic in > general. Why would VBA or the other versions of Visual Basic not be > discussed here? Can't, 'cuz it isn't. The hierarchy precedes .net by quite a long time ('95 or thereabouts iirc) but was envisioned and chartered to support all of the MS VB visual products at the time. > II. The COMP.LANG.BASIC.VISUAL Charter: > > COMP.LANG.BASIC.VISUAL is an unmoderated forum to share > information about Microsoft's Visual Basic for Windows and > MS-DOS, as well as the new "Application Basic" embedded in MS > applications such as Word for Windows, Excel, and Access. > > Microsoft provides no Internet support channel for Visual Basic, > so this group will let Visual Basic users get together to help > each other, without requiring them to filter through unrelated, > broader Windows programming issues. .... > VI. The COMP.LANG.BASIC.VISUAL.MISC Charter: > The .misc group is required by Usenet guidelines, and will be a > place for any discussions of topics which are not covered by the > other three groups. Topics might include queries on Visual Basic > methods, or API commands, applications of the standard set of > controls, general use of the BASIC language, general discussion > about programming techniques, general concepts of event-driven > programming, etc... > > The .misc group would basically replace the current > comp.lang.basic.visual discussion group where all of the above > topics (and more) are being discussed daily. The split of the > other groups should drastically reduce the amount of volume in > this "catch all" group. Since then, of course, there's been much that has changed but the charter has never been formally updated afaik. <http://www.faqs.org/faqs/visual-basic-faq/general-info/> I'd say it would be better for .net-related version queries to go to a hierarchy for them but don't know where that would be other than the MS fora. --
From: Viken Cerpovna on 15 Jul 2010 22:22
>>> Is that VB.Net? Or maybe MS Office VBA? >>> Whatever it is, it's not VB. This group is >>> for VB (VB5/6) questions. >>> >> >> Mayayana, >> >> Could you point to where this is stated? I haven't been monitoring this >> group for very long but I thought it was just for Visual Basic in >> general. Why would VBA or the other versions of Visual Basic not be >> discussed here? > > Can't, 'cuz it isn't. > > The hierarchy precedes .net by quite a long time ('95 or thereabouts iirc) > but was envisioned and chartered to support all of the MS VB visual > products at the time. > >> II. The COMP.LANG.BASIC.VISUAL Charter: >> >> COMP.LANG.BASIC.VISUAL is an unmoderated forum to share >> information about Microsoft's Visual Basic for Windows and >> MS-DOS, as well as the new "Application Basic" embedded in MS >> applications such as Word for Windows, Excel, and Access. >> >> Microsoft provides no Internet support channel for Visual Basic, >> so this group will let Visual Basic users get together to help >> each other, without requiring them to filter through unrelated, >> broader Windows programming issues. > ... >> VI. The COMP.LANG.BASIC.VISUAL.MISC Charter: >> The .misc group is required by Usenet guidelines, and will be a >> place for any discussions of topics which are not covered by the >> other three groups. Topics might include queries on Visual Basic >> methods, or API commands, applications of the standard set of >> controls, general use of the BASIC language, general discussion >> about programming techniques, general concepts of event-driven >> programming, etc... The .misc group would basically replace the >> current >> comp.lang.basic.visual discussion group where all of the above >> topics (and more) are being discussed daily. The split of the >> other groups should drastically reduce the amount of volume in >> this "catch all" group. > > Since then, of course, there's been much that has changed but the charter > has never been formally updated afaik. > > <http://www.faqs.org/faqs/visual-basic-faq/general-info/> > > I'd say it would be better for .net-related version queries to go to a > hierarchy for them but don't know where that would be other than the MS > fora. Yeah, that's what I thought. I was thinking more about VBA than .NET, since there isn't really any difference that I am aware of between the Office programming language and VB 6.0. COM libraries are not part of the language. Seems to me that any "Visual Basic" would be fair game to discuss here though. Thanks, Viken |