VBA

Resolved · Low Priority · Version 2007

Thu 8 Jan 2009, 16:35 Delegate Hugh said...

Hugh has attended:
Excel VBA Intro Intermediate course

VBA

bets way to make a filepath to another workbook which i can change easily

Wed 11 Feb 2009, 15:37 Edited on Wed 11 Feb 2009, 15:38 Trainer Stephen said...

RE: VBA

Hi Hugh

Thanks for your question

It is possible to create a new folder at a particular location by using the mkdir function.

For example, the following code will create a new folder in my documents. The folder's name is specified by the variable strFolder.

MkDir "C:\Documents and Settings\Development\My Documents\" & strFolder

You could also use the SaveAs method to save a file to a particular directory

ActiveWorkbook.SaveAs Filename:= _

        "C:\Documents and Settings\Development\My Documents\" & strFolder & "\" & strName & ".xls"

Hope this is useful

Regards

Stephen

Wed 18 Feb 2009: Automatically marked as resolved.

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

VBA

VBA

RE: VBA

Excel articles

Excel tip:

Screen Splitters in Excel