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 Westi 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. reimbursement

    How can I stop my command Buttons from shifting?

    Here is the macro the button calls in. I am running Excel 2002. Range("A3").Select Application.CutCopyMode = False ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True The other button does not cause the buttons to relocate.
  2. reimbursement

    How can I stop my command Buttons from shifting?

    I have two command Buttons on a spreadsheet. After I click on one of the buttons the buttons reposition themselves to the right. How can I stop the buttons from moving around. Thanks!
  3. reimbursement

    vba Connection issue for query table

    I need to be able to be able to change the file location of a .prn file to represent where the user may have it mapped on their computer. With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;I:\PROJECTS\waytd.prn", Destination:=Range("A1")) Using the thisworkbook.path does not work...
  4. reimbursement

    opening microsoft outlook on a citrix server from excel

    I have a program which I am wanting to send an automatic email. Our Microsoft Outlook is located on an offsite Citrix server. Has anyone worked with this type of event? If so how do I open this from VB?
  5. reimbursement

    listbox default selection

    I have multiple listboxes on a userform to get the users input on what to include in a autofilter list. The listboxes allow for multiple selections. Is there a way to set the first item in the list as the default if nothing is selected?
  6. reimbursement

    Auto fit to window - Word (Excel Pasted table)

    I am copying text from Excel(2002) to word. When I try to record a macro to paste and resize to fit window, the option to autofitwindow is grayed. However, I can complete the autofitwindow after stopping the macro record. Any help would be appreciated. The text being copied translates into about...

Part and Inventory Search

Back
Top