FAO EXCEL WIZARDS
#1
BANNED
BANNED
Thread Starter
Join Date: May 2003
Location: Mongsville, wiping Jimbo.'s spastic arse.
Posts: 23,032
Likes: 0
Received 2 Likes
on
2 Posts
FAO EXCEL WIZARDS
right, you can create macro's to open any spreadsheets you need that are saved on your system.
for example, rather than keep going to file / open / etc for a file that you use all the time, you can create a macro icon, apply the macro to the button so it opens the file on the click of the said button..
but..
how do you create links to folders? and attatch it to an icon?
for example, rather than keep going to file / open / etc for a file that you use all the time, you can create a macro icon, apply the macro to the button so it opens the file on the click of the said button..
but..
how do you create links to folders? and attatch it to an icon?
#2
I've found that life I needed.. It's HERE!!
Join Date: Jun 2003
Posts: 1,464
Likes: 0
Received 0 Likes
on
0 Posts
Dave
You need to first open microsoft power point and make some buttons using the bit on the bottom left
Autoshapes open the list up and create a button
Then right click it and click on the hyper link and select edit hyperlink
Click on where it says other file and find the one that you want
This will now be a MACRO to that file and will open it for you
Right click on the button and CUT
paste it into any MICROSOFT documnet word etc and it will open the file you said
So you could have a word document with loads of buttons to your fave common files or pics etc
Nige
You need to first open microsoft power point and make some buttons using the bit on the bottom left
Autoshapes open the list up and create a button
Then right click it and click on the hyper link and select edit hyperlink
Click on where it says other file and find the one that you want
This will now be a MACRO to that file and will open it for you
Right click on the button and CUT
paste it into any MICROSOFT documnet word etc and it will open the file you said
So you could have a word document with loads of buttons to your fave common files or pics etc
Nige
#4
Or, its a billion times easier to create a new module in word/excel whatever and paste the following as a macro:
Option Explicit
Sub test()
Dim davesFolder As FileDialog
Set davesFolder = Application.FileDialog(msoFileDialogFolderPicker)
davesFolder.InitialFileName = "C:\daves_useful_folder\"
davesFolder.Show
End Sub
Cheers.
Option Explicit
Sub test()
Dim davesFolder As FileDialog
Set davesFolder = Application.FileDialog(msoFileDialogFolderPicker)
davesFolder.InitialFileName = "C:\daves_useful_folder\"
davesFolder.Show
End Sub
Cheers.
Thread
Thread Starter
Forum
Replies
Last Post
nicodinho
Ford Non RS / XR / ST parts for sale.
6
07-10-2015 12:56 PM