Question: How do I hide the Title Bar?

Visual Basic for Applications (VBA)

Index ‹ Microsoft ISV

- Previous
  - 1
    - iexplore.exe - Application Error I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this Tag: Question: How do I hide the Title Bar?
  - 2
    - VBA Excel short Macro Ending in 1st Open Cell I recorded an actual Macro and it looks like this. Application.CommandBars("Web").Visible = False Range("A28").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Range("A29").Select ActiveWindow.SmallScroll Down:=3 What I actually have is thousands of rows populated, Three rows are visible with data in the top three rows of my active sheet, 26, 27 & 28 in this example. When I first open the spreadsheet, I need to make the WEB toolbar go away, this part is good. I then need to click on the very last hyperlink in 'A' column, I think it may be refered to something like lastused range This example is 'A28'. I then need to put the cursor in the next available empty cell past the lastused range in the 'A' column and post it in the very top left corner, (as though it was in cell A1 ready to work). This empty cell was in the fourth row so I did three smallscroll to get it to the top row in view. When I record the macro as you see above it records the actual cell number, this will not help me but I know someone here can please. I also need the macro to run slowly giving the internet time to upload the hyperlink and then revert back to finish the macro, it just zips right through it now and does not end up in the correct cell when completed. Thanks in advance for any help. Lastly, is there a way to make the WEB toolbar stay gone, it wasnt in view by default prior to some MS update I am guessing Tag: Question: How do I hide the Title Bar?
  - 3
    - vlookup Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata Tag: Question: How do I hide the Title Bar?
  - 4
    - Excel Userform - Runs fine but other users get a compile error I have a userform that is called from a keyboard shortcut. It works perfectly fine when I run it, but other users cannot run it on their machines. We all are using Excel 2003 SP3, (only one user has SP2) and all users have changed their security to allow macros. But when they try to load the form they get a compile error. The code I have for the userform is... Code Block Private Sub UserForm_Activate() TextBox7.Value = Sheet24.Range("A10") TextBox17.Value = Sheet24.Range("B10") TextBox16.Value = Sheet24.Range("A11") TextBox26.Value = Sheet24.Range("B11") TextBox15.Value = Sheet24.Range("A12") TextBox25.Value = Sheet24.Range("B12") TextBox14.Value = Sheet24.Range("A13") TextBox24.Value = Sheet24.Range("B13") TextBox13.Value = Sheet24.Range("A14") TextBox23.Value = Sheet24.Range("B14") TextBox12.Value = Sheet24.Range("A15") TextBox22.Value = Sheet24.Range("B15") TextBox11.Value = Sheet24.Range("A16") TextBox18.Value = Sheet24.Range("B16") TextBox10.Value = Sheet24.Range("A17") TextBox19.Value = Sheet24.Range("B17") TextBox9.Value = Sheet24.Range("A18") TextBox20.Value = Sheet24.Range("B18") TextBox8.Value = Sheet24.Range("A19") TextBox21.Value = Sheet24.Range("B19") uSheets = Array(Sheet10, Sheet11, Sheet13, Sheet12, Sheet14, Sheet29) a = 1 For Each sSheet In uSheets On Error Resume Next With sSheet If .CheckBox1.Value = True Then Me.Controls("textbox" & a).Text = "1" ElseIf .CheckBox2.Value = True Then Me.Controls("textbox" & a).Text = "2" ElseIf .CheckBox3.Value = True Then Me.Controls("textbox" & a).Text = "3" End If End With a = a + 1 On Error GoTo 0 Next Me.Repaint End Sub (special thanks to Cringing Dragon) And it is called from a keyboard shortcut... Code Block Sub UserForm1Open() ' ' Keyboard Shortcut: Ctrl+q ' UserForm1.Show End Sub Which is saved in a module on the workbook. When users try to run it they get a compile error on... Code Block uSheets = Array(Sheet10, Sheet11, Sheet13, Sheet12, Sheet14, Sheet29) The debugger says the "array is hidden". I have no problem running it so I'm not quite sure what to make of it, any ideas Tag: Question: How do I hide the Title Bar?
  - 5
    - Send Outlook message via VBA Macro in Excel I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(8007007e)': Automation error The specified module could not be found. Here is the VBA code in the Excel Macro. The error happens when it reaches the line that reads: Set theApp = CreateObject("Outlook.Application") . I tried to run the macro on two other Office 2003 SP2 computers and they worked OK, which shot my theory that it was strictly related to Office 2003 SP2. So far it's only one user who had this problem. Dim theApp, theNameSpace, theMailItem, myAttachment, MessageBody, subject 'create a new Outlook Application Object, 'direct it to the proper NameSpace, 'create a new Mail Item and set the attachments collection Set theApp = CreateObject("Outlook.Application") 'error occurs here Set theNameSpace = theApp.GetNameSpace("MAPI") Set theMailItem = theApp.CreateItem(0) Set myAttachment = theMailItem.attachments 'add recipients to MailItem theMailItem.Recipients.Add john.doe@hotmail.com theMailItem.subject = subject theMailItem.Body = MessageBody myAttachment.Add fName, 1, 1, subject theMailItem.Send theNameSpace.Logoff Any advice, solutions, or suggestions are welcomed and appreciated. Thanks! P.S. Here is a screen shot of the error <img src=" http://www.asi.com/vbaerror.jpg "> Tag: Question: How do I hide the Title Bar?
  - 6
    - ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where I should ask instead, please drop me a note, thanks!) On Vista, ReportFault()'s behavior changed, unfortunately. With the default error reporting settings (automatic reporting without asking the user), it sends the crash report to the Winqual site - and then terminates the application. However, in my particular case, I need to re-gain control after WER reporting in my application in order to perform additional logging and clean-up, and to provide users with an option to continue working for a limited time (for example, to try and save their current data). Since ReportFault() didn't do what I wanted, I tried the WerReportCreate/WerReportSubmit combo instead. Those APIs do indeed return and don't terminate the application - but they also don't seem to report all the crash details correctly. For example, I've never seen any indication that one of the crash reports produced by the WerReport* APIs contained minidump information (judging from the problem report history in wercon.exe). My first guess is that I'm simply not using the WerReport* APIs correctly - but after trying lots of different options and variations, I'm pretty much at a loss. Hence my questions: - Where can I find tested sample code which uses WerReportCreate/WerReportSubmit() - Is there a way to use ReportFault() under Vista without terminating the application Thanks! Claus Brod Tag: Question: How do I hide the Title Bar?
  - 7
    - how can I set all the items' subtotal as False in pivot table? Module per Plant Category Y03 Y04 Y05 Y06 Y07 Y08 Y09 Y10 Y11 Y12 CLV Export Demand 1092 757 879 977 970 1176 1188 1200 1212 1224 CLV Export Total 1092 757 879 977 970 1176 1188 1200 1212 1224 CLV FN Demand 11520 12710 11524 12392 14807 15554 15843 16154 16488 16846 CLV FN Total 11520 12710 11524 12392 14807 15554 15843 16154 16488 16846 CLV FNN Demand 2438 2251 5265 10969 12712 15161 12026 15606 15767 15930 CLV FNN Total 2438 2251 5265 10969 12712 15161 12026 15606 15767 15930 CLV Main Milk Demand 44310 52690 54759 57041 58510 60595 62078 63586 65213 66501 CLV Main Milk Total 44310 52690 54759 57041 58510 60595 62078 63586 65213 66501 CLV Main PN Demand 21527 24972 28639 29338 32507 36139 35678 36285 36911 37556 CLV Main PN Total 21527 24972 28639 29338 32507 36139 35678 36285 36911 37556 Flav/Prem Demand 0 0 0 0 21 1468 5679 7396 8186 9091 Flav/Prem Total 0 0 0 0 21 1468 5679 7396 8186 9091 HKT Main Milk Demand 24924 29638 30802 32086 32912 34085 34919 35767 36682 37407 HKT Main Milk Total 24924 29638 30802 32086 32912 34085 34919 35767 36682 37407 HKT Main PN Demand 50230 58267 59200 64414 65971 66033 67170 68344 69560 70816 HKT Main PN Total 50230 58267 59200 64414 65971 66033 67170 68344 69560 70816 HKT Minis Demand 12765 19848 17643 15091 13721 14768 17926 18880 19969 21210 HKT Minis Total 12765 19848 17643 15091 13721 14768 17926 18880 19969 21210 (blank) Demand 235 20 64 0 0 0 0 0 0 0 (blank) Total 235 20 64 0 0 0 0 0 0 0 Grand Total 169043 201152 208775 222307 232131 244979 252508 263218 269987 276581 Hello, Above is my pivot table. I want to set all the subtotal as False for my table. Can you help me on this Thanks so much! B.regards/Yaping Tag: Question: How do I hide the Title Bar?
  - 8
    - iexplore.exe - Application Error I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this Tag: Question: How do I hide the Title Bar?
  - 9
    - Why the do while loop does not work? Hello, Below is my code, the lastrowGSVGrowthRate is 101, I expected result is to copy all the "AFFILIATE" items. While with my code, it only copied the first "AFFILIATE" item. I do not know where I did wrong. Thanks so much! B.regards/Yaping raffiliate = 1 rowaffiliate = 1 Do While raffiliate <= lastrowGSVGrowthRate If cells(raffiliate, 1) = "AFFILIATE" Then MsgBox raffiliate Range(cells(raffiliate, 1), cells(raffiliate, lastcolumnGSVGrowthRate)).Select Selection.Copy worksheets("AFFILIATE").Activate ActiveSheet.cells(rowaffiliate, 1).Select Selection.PasteSpecial Paste:=xlPasteAll rowaffiliate = rowaffiliate + 1 Else End If raffiliate = raffiliate + 1 Loop Tag: Question: How do I hide the Title Bar?
  - 10
    - iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :( Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x Tag: Question: How do I hide the Title Bar?
  - 11
    - VBA macro for Excel for extracting and 'depositing' text between brackets... I am trying to create an Excel macro that will 'look' at the text contents of a given cell (say A1), copy any text that occurs within brackets, and then deposit this text into an adjacent cell (B1). For example, if A1 contained the following: "This is <just> a test", the word "just" would be extracted and deposited into B1. Ideally, I would like to be able to run such a macro on a specifed range of rows... Could anyone suggest any possibilities Many thanks... Josh Tag: Question: How do I hide the Title Bar?
  - 12
    - Command for insert picture Hi , could someone pls advise the command for to insert picture to excel using vb command. Dim img as image how to mention location of file name , path directory . what if the file name and path... pls advise Tag: Question: How do I hide the Title Bar?
  - 13
    - Run-time error '13': Type Mismatch i always get this error when i try to run...does anyone know what's the problem Code Snippet Option Explicit Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "Research & Development" cbxDept.AddItem "Finance & Control" cbxDept.AddItem "Human Resource" cbxDept.AddItem "Globe & ISIT Services" End Sub Private Sub cmdPrevious_Click() If txtRow.Text > 1 Then txtRow.Velue = txtRow.Value - 1 UpdateData End Sub Private Sub cmdNext_Click() If txtRow.Text < Range("Database").Rows.Count Then txtRow.Value = txtRow.Value + 1 UpdateData End Sub Private Sub txtFName_AfterUpdate() Range("A2")(txtRow.Text).Value = txtFName.Value End Sub Private Sub txtLName_AfterUpdate() Range("B2")(txtRow.Text).Value = txtLastName.Value End Sub Private Sub cbxDept_AfterUpdate() Range("C2")(txtRow.Text).Value = cbxDept.Value End Sub Private Sub txtRow_AfterUpdate() If txtRow.Text < 1 Then txtRow.Text = 1 ElseIf txtRow.Text > Range("Database").Rows.Count Then txtRow.Text = Range("Database").Rows.Count End If UpdateData txtFName.SetFocus End Sub Private Sub UpdateData() txtFName.Text = Range("A2")(txtRow.Text).Value txtLName.Text = Range("B2")(txtRow.Text).Value cbxDept.DropButtonStyle = Range("C2")(txtRow.Text).Value End Sub thanx Tag: Question: How do I hide the Title Bar?
  - 14
    - Sorting cells in a spreadsheet by colour My apologies if I am asking this question in completely the wrong forum. I am trying to create a VBA macro that will order data in an Excel spreadsheet according to colour (so that like colours are all grouped together). I wonder if somebody would be kind enough to spend some time explaining how to do this to a more or less complete VBA novice! Many thanks... Josh Ord-Hume Tag: Question: How do I hide the Title Bar?
  - 15
    - ACCESS - You do not have exclusive access to the database I have an ACCESS application that is running locally on a user's machine. When they log in, they get the error "You do not have exclusive access to the database", then they have to click "OK" 21 times before the application will open up for them. The .mdw file is named different from the .mdb file, so they aren't locking each other out. Any ideas Tag: Question: How do I hide the Title Bar?
  - 16
    - 0x01ef852e referenced Memory error I'm not sure if this is the right place to post this...but here it is anyway... When trying to run Everquest with windows Vista I've received this error: The instruction at 0x01ef852e referenced memory at 0xfffffc. The memory could not be read. I have no clue what it's for or means or how to fix it...if anyone has a clue PLEASE let me know. After receiving the error the game patcher etc all crashes. I can not get it to load past the patcher which completes and is fine until clicking the PLAY button. Please help! Tag: Question: How do I hide the Title Bar?
- Next
  - 1
    - Reversing a lists order in excel for my macro Hi there. I have a macro that im building within excel, but am stuck on an excel function. Does anyone know how to reverse the order of a list ini excel. I have a column set up of names. How can i select this list and have it reverse the list in a separate column. I dont want it reversed alphabetically, or numerically... my example would be this... Cell A1 - A5 Paul Barry John Steve Jim i would like to either select the 5 cells and have click a button to reverse this order, or have it return the reversed order in column B1 - B5... giving me the result of Jim Steve John Barry Paul The only way ive seen how to do it is with the offset function but ive had alot of trouble with that for some reason and hoped someone had another idea. Thankyou! Tag: Question: How do I hide the Title Bar?
  - 2
    - SQL code Hello, I am trying to find out how to write code in Visual Basic that will update a table in SQL. I already have the database in SQL open, but the problem I have is the actual update portion of the code. Can anyone help me Here is a sample of my code: Function update() 'This function allows you to update and change specified records and columns in tables in 'the databases provided ' These variables store the text of the file. Dim FHA_Case As String Dim SeqNumber As String Dim SSN, LName, FileNum, FName As String Dim name, Street, City, State, Zip As String Dim SQL1, SQL2 As String Dim rs1 As New ADODB.Recordset Set rs1 = New ADODB.Recordset Dim rs2 As New ADODB.Recordset Set rs2 = New ADODB.Recordset Dim cnn As New ADODB.Recordset cnn.Open "Provider=SQLOLEDB.1;Password=simple;Persist Security Info=True;User ID=sa;Initial Catalog=HUDGUISQL;Data Source=HOST\SQLEXPRESS;" With rs1 .CursorLocation = adUseClient .CursorType = adOpenDynamic .LockType = adLockPessimistic End With SQL1 = "Select * from [ToHUD-FISR1132C-CD57];" rs1.Open SQL1, cnn, adOpenKeyset, adLockPessimistic Do While Not rs1.EOF FHA_Case = rs1![CaseNum] SeqNumber = rs1![SeqNum] If Not rs2.EOF Then rs2.Edit rs2!BatchID = rs1!BatchIDNumA rs2!ClmntSSN = rs1!ClmntSSNEIN rs2!ClinType = "CC" rs2.update End If rs1.MoveNext rs2.Close Loop rs1.Close cnn.Close End Function The error that I am getting says "Method or data member not found" for the line: "rs2.Edit" Tag: Question: How do I hide the Title Bar?
  - 3
    - Pivot table updating How do I get my pivot table to update when I update data in my spreadsheet Tag: Question: How do I hide the Title Bar?
  - 4
    - MS CRM 3 and outlook I have MS CRM installed and I have offiice 2k3 installed and windows is fully updated, but I keep getting a message when I load outlook that ms crm server is unavailble, but my we client works well. Tag: Question: How do I hide the Title Bar?
  - 5
    - VBA Excel, AND/OR condition behavior. Hello guys, I just need a quick answer to comfirm the AND/OR behavior. Some languages stop evaluate the condition is the condition is already met, like is False AND Null will give you False, and True OR Null will give you True. Instead of doing that, it seems like VBA will evaluate the full statement. Like False AND Null = Error. Is this correct Thank you. Tag: Question: How do I hide the Title Bar?
  - 6
    - MS Office document and image writer print driver Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Tag: Question: How do I hide the Title Bar?
  - 7
    - How to implement DirListBox and FileListBox in VBA forms? Hi, I am working with VBA in Bentley Microstation 8.0. I wanted to know whether there is a way to implement the DirListBox and FileListBox (that are present by default in VB 6.0 toolbox) in VBA forms I think people from the VBA team in Microsoft can only answer this. Any help from any corner would be great. Regards, shiva Tag: Question: How do I hide the Title Bar?
  - 8
    - Report stolen product keys? Is there any way to report stolen product keys that can be marked as such Someone got a hold of one of my MSDN licenses for Vista and is going to use it for their own personal use. Thank you. Tag: Question: How do I hide the Title Bar?
  - 9
    - Locking clickable labels Can you lock a label like you can a toggleButton I have some code as follows; If toggleButton1.value = True Then togglebutton2.locked = True Else togglebutton2.locked = False End If But I also want to temporarily lock some clickable labels, but there is no ".locked" function for labels. How do I stop a label's click action from being allowable under certain circumstances Thanks. Tag: Question: How do I hide the Title Bar?
  - 10
    - Connecting to Access Database via ADO from Excel Hi, I am new to this ADO querying.... Basically what I am trying to do is take a range of data from a defined Range on an excel sheet and import that into a table already set up in a Access Database. From reading some details on this I understand that an ADO Connection is the way to go. My problem now is understanding what I need to write as my VBA code to do this. Can anyone help Thanks, Jez Tag: Question: How do I hide the Title Bar?
  - 11
    - Office 10 \ winword.exe runtime error I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe. Tag: Question: How do I hide the Title Bar?
  - 12
    - Determine if and where the .NET Framework is installed using VBA I have an Excel spreadsheet that needs to determine if the .NET Framework is installed as well as the path to that install. How can this be acomplished in VBA code Tag: Question: How do I hide the Title Bar?
  - 13
    - Learning VBA I signed up for an independent study in VBA. The textbook, Course ILT MS VBA Programming was written in 2001. I am using MS Office 2003. There must have been changes VBA; I cannot find Auto List Members nor can I find Auto Quick Info which are supposed to be in the Options tool box. I would really appreciate any help. thank you Tag: Question: How do I hide the Title Bar?
  - 14
    - Can anyone tell what is wrong with this? Excel is saying there is "run time error '1004' Autofill Range Class of Method Fai Sub Test() ' ' Test Macro ' ' Keyboard Shortcut: Ctrl+t ' Selection.AutoFill Destination:=Range("C4:T4"), Type:=xlFillDefault Range("C4:T4").Select ActiveWindow.ScrollColumn = 13 ActiveWindow.ScrollColumn = 12 ActiveWindow.ScrollColumn = 11 ActiveWindow.ScrollColumn = 10 ActiveWindow.ScrollColumn = 9 ActiveWindow.ScrollColumn = 8 ActiveWindow.ScrollColumn = 7 ActiveWindow.ScrollColumn = 6 ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 Range("C7").Select End Sub Tag: Question: How do I hide the Title Bar?
  - 15
    - Corrupt email causes Outlook Express to freeze Today when I brought my email in, the computer got stuck at some point. It wouldn't react to anything, not even Ctrl+Alt+Del. I've been trying many things for hours and hours, but the problem remains. As soon as I stand on this particular email where the above happened, OE freezes. As long as I work around it, all goes well. How can I delete this corrupt email If you want to send me an answer here that would be great. If you could send it to this email address, even better: consulti@xs4all.nl Thanks! Caroline Tag: Question: How do I hide the Title Bar?
  - 16
    - Execute a Macro at Print Event in a Mail Merged Document. (New instance named Letter1 gets creted) Hello All, I want to execute a macro on a mail merged document at a Print Event . Some Info reg my dev. My program is in SAP-ABAP. It transfers its data to word file in a mail merged manner. In this process it creates a new instance of a document and this is "Letter" document. Through ABAP i can print the whole "Letter Document" but not the partial print. So i write a macro (with the help of previous posts) which can do the partial printing with the data from ABAP. Now the problem is that the macro do not trigger when i am printing this "Letter Document". I am really stuck here. I have tried no of ways to trigger this macro automatically like writing it on Document Open, Writing the macro in Normal . dot file , but this doesn't workout. Kindly let me know if there is some other method through we can execute a macro on this document. Please bear with me if am asking silly question/s. Thank you, Vinod. Tag: Question: How do I hide the Title Bar?

UA Jeremy

Howdy...

I'm writing a program in Excel and I was wondering how to hide the Title Bar. The one with "Microsoft Excel" and the min., restore, and close button.

If that's not possible, is it possible to deactivate the close button

Top

Re: Question: How do I hide the Title Bar?

element109

Set the forms borderstyle property to none.

Top

Re: Question: How do I hide the Title Bar?

UA Jeremy

I'm not working with Forms....I want to hide the application title bar.

Top

Re: Question: How do I hide the Title Bar?

Andy Pope

Hi,

Have a look at Stephen Bullen's FunForm workbook.
http://www.oaltd.co.uk/Excel/Default.htm

I know his code is designed to apply the formatting to a userform. But by changing the code in the class to use the application window handle rather than the userform the effects still work.

But be very careful when playing around with application setting. Make sure your code returns the enviroment to the same state you found it in. Nothing worse than using somebodys code only to find it leaves excel in an unusable and re-arrange state.

Top