The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro's

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Macro's

Resolved · High Priority · Version 2007

ReplyThu 26 Nov 2009, 14:10Delegate Paul said...

Macro's

Designed macro to enable data formatting from a csv file to be maintainined when saved as excel file ... for the specific file name.
Want to be able to enter in a new csv file name which can be saved into excel.
Simon said he had an associate working on a similar request - the solution on this would be most appreciated!

For upcoming training course dates see: Pricing & availability

ReplyFri 27 Nov 2009, 15:52Trainer Simon said...

RE: Macro's

Hi Paul,

Thank you for your question.

I believe the code I was referring to was to open a dialogue box to choose a file.

My colleague won't be able to send you the code until Monday.

I hope this is ok.

Regards

Simon

ReplyTue 1 Dec 2009, 16:44Trainer Stephen said...

RE: Macro's

Hi Paul

As requested please find below the code that will open a dialog box so that the user can open a file.

I'm not sure what exactly you want to open, or whether you wish to save an already open file. The code below can be adapted to do all of these things let me know if you need any more help

    Dim objFilter As FileDialogFilters

    Dim strExcelFile As String



     With Application.FileDialog(msoFileDialogOpen)

        

        Set objFilter = .Filters

        objFilter.Clear

        objFilter.Add "Excel 2003", "*.xls" 'allows for main types of excel workbook

        objFilter.Add "Excel 2007", "*.xlsx"

        objFilter.Add "Excel 2007 Macro Enabled", "*.xlsm"

               

        .Show

        

        strExcelFile = .SelectedItems(1) 'Picks up path and file name

        

        Application.Workbooks.Open (strExcelFile)

            

        

    End With

The filters above specify the type of file that the dialog box will display

Regards

Stephen

Tue 8 Dec 2009: Automatically marked as resolved.

Excel articles

· Excel 2010 A Glance Into The Future
· Joseph And His Chart Of Many Colours
· Reporting and Analysis with Excel
· Do You Really Need Excel VBA Training?
· Creating Tables Automatically In Excel 2010

Please browse our web site to find out more about
excel training seminar and other Microsoft training courses.

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips

Could you please provide a full list of short cut keys?