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!

Register Log in
  • Congratulations gkittelson 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. borman2005

    Custom toobar, assigning icons under VBA control.

    No problem. Glad to help.
  2. borman2005

    Custom toobar, assigning icons under VBA control.

    This works for me in 2003: Set myBar = Application.CommandBars("Testing") Set myControl = myBar.Controls _ .Add(Type:=msoControlButton, Before:=3) With myControl .FaceId = 2950 .OnAction = app & "!rowdn" .DescriptionText =...
  3. borman2005

    Custom toobar, assigning icons under VBA control.

    Is it for 2003 or 2007?
  4. borman2005

    Copy files into a current user profile folder using VBA

    I've searched the use of %userprofile% variable with VBA, and apparently it's not supported.
  5. borman2005

    Copy files into a current user profile folder using VBA

    Thank you so much! I'm familiar with FileCopy, but am not sure how to specify a variable in a destination path, so it would work for the currient user. I know that %userprofile% wouldn't work here. Any suggestions? Thanks again, Borman2005
  6. borman2005

    Copy files into a current user profile folder using VBA

    Thanks for the fast reply! I really appreciate your help! So, if for example, I'm logged in as "JDoe", and I want the macro to copy "C:\test\test.doc" file to "C:\Documents and Settings\JDoe\Test", how would I use it in that code? Borman2005
  7. borman2005

    Copy files into a current user profile folder using VBA

    Can someone help me with VBA code to have an Excel macro to copy files into a folder within a "current user" folder? Basically, when current user would click on a macro button, it would copy files into a specified folder within his\her userprofile.

Part and Inventory Search

Back
Top