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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by borman2005

  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.
See more

Part and Inventory Search

Back
Top