Change Default Folder Location For Hyperlinks

Feb 24, 2008

When someone right clicks on a cell and chooses "Hyperlink" current folder is being displayed as a default.

is there a way to change this for a particular workbook through VBA or API calls ?

I would like to always have "c:" as the default folder no matter where the workbook is stored.

View 9 Replies


ADVERTISEMENT

Change GetOpenFilename Default Location

Oct 29, 2008

When I use the GetOpenFilename() method, it seems to default to the particular users My Documents. Is there a way to force it to default elsewhere like a share drive, or the users desktop?

In the same line of thought, if I have a file named TestFile.xls. and I want to try to open it from the users desktop if they have it, how can I do this, since their desktop location is different than mine?

View 12 Replies View Related

File Browsing In Macro - How To Change Default Start Location?

Sep 28, 2008

I use an image analysis program ImagePro which can call Excel within it's macro language (which seems to be visual basic). I looked up on this site how the change the drive (ChDrive command). But still when the Excel section (after With oExcel) executes the default file location in the browser is in My Documents on the C: drive.

Prior to this code Excel has been launched by this ImagePro macro, and a file Cumberland Template has been opened from the C: drive. Now I would like to do a Save As, but have Excel start at the I: drive location.

View 7 Replies View Related

Change The Folder Location

Dec 14, 2006

which part of this macro I need to edit to make it open a folder I want?


Sub OpenFolderRequest()
YesNo = MsgBox("Would you like to open the folder to see" _
& vbCr & "which files are currently there?", vbYesNo + vbQuestion, "Open Folder?")
Select Case YesNo
Case vbYes
myval = Shell("c:winntexplorer.exe c:winnt", 1)
Case vbNo
End Select
End Sub

I have tried changing the (c:winntexplorer.exe c:winnt) to the location name of the folder I want to open (S:Stock ControlSTOCK CONTROLOrder Confirmation)but it doesn’t seem to work.

View 9 Replies View Related

Hyperlinks Won't Work When Save File To Another Location On Computer

Jan 8, 2014

I've created a spreadsheet of clients and info; I want each client name to link to their specific folder on my computer for easy referencing. I entered in all the links and they work just fine; however, when i tried to save the file to another location on my computer so it could be used by another employee (same terminal, etc, just in another folder) the hyperlinks stopped working.

View 5 Replies View Related

VBA Macro To Follow Hyperlinks & Save Files To Another Location

Jan 16, 2010

I am attempting to write an Excel macro that will be stored in a file called MacroFile. The purpose of the macro is to

1. Follow a hyperlink to an Excel file saved in a SharePoint type enviroment
2. Save the file to my laptop directory My Documents.

Below is the code I have written. The code is following the hyperlink and saving a file but is the focus file is incorrect.

Here is what happens:

1. Open up MacroFile and run macro
2. Hyperlinked file LinkedFile_1.xls is opened
3. File NewFile_1 is saved but contains the info from MacroFile
4. Hyperlinked file LinkedFile_2.xls is opened
5. File NewFile_2 is saved but contains the info from LinkedFile_1
6. Hyperlinked file LinkedFile_3.xls is opened
7. File NewFile_3 is saved but contains the info from LinkedFile_2

The files created are named correctly but have the wrong data in them. I need to know how to control which file is considered ActiveWorkbook.

Sub LinkAndCopy()
Application. ScreenUpdating = False
Application.DisplayAlerts = False
'**** Copy LinkedFile_1..................

View 2 Replies View Related

Default File Location

Mar 26, 2007

I have had my server removed that I had my default file location, when I go in to change any of my options the first thing it does is go look for this file location and brings back an error stating it cannot find the server. I cannot find anywhere else that I could change it.

View 9 Replies View Related

Default GetOpenFilename Location

Sep 10, 2009

I have the following code, is it possible to direct to a default directory that the file might be in? So when I open the dialog box it will automatically redirect a directory that is stored in VBA.

View 4 Replies View Related

Choosing A Textbox For Default Cursor Location

Dec 11, 2005

On my user form, the cursor blinks in the second text box down.

How do I change it to be blinking in the first (top) text box? This is the first box that data will be entered.

Is this an option in the properties box of the textbox?

View 9 Replies View Related

Excel 2010 :: Default File Location Not Working?

Apr 19, 2013

I'm using Excel 2010. When I go into the Excel Options, to the Save option and try to type in a specific network drive in the Default File Location: box, I click OK and then it doesn't save the changes. I close Excel down all the way and then restart a new Excel session and it keeps going back to "LibrariesDocuments..."

It doesn't seem to be just related to Excel...having the same issue in Word and Access 2010 as well.

View 3 Replies View Related

Open Windows File Chooser At Default Location

Feb 14, 2012

Is there any way of making the default directory location for application.getopenfilename work properly with shared locations?

Presently I use ChDrive then Chdir but I cant use ChDrive if workbook is opened from a link in email for example. Please see below

I have a VBA routine that asks the user to load an existing file on startup.

I want the window for the file selection to open at the same folder every time. (the folder is on a shared drive)

The workbook to run the code will always be located on this same share at a fixed location.

My present code builds the path to the desired opening folder by collecting the drive letter from the current working directory (which has to be done as everybody maps there shares to different letters here, its not guaranteed to be the same! )

then i ChDrive to this letter.

Then I ChDir to letter plus myKnowndirPath

This works fine, the window always opens at my required folder. But only as long as the user has navigated to the folder containing the spreadsheet and then ran it from there. Because that way a drive letter is available.

However i found that if i sent a link to the workbook or its home folder. And the user opens the link or a windows explorer from that link and then runs file from there.

Then it stops working beacause there is no local drive letter in the working directory path. i.e. working directory shows as

'network \shareddrive
ootafolderanother arget

instead of something like
J:afolderanother arget

View 2 Replies View Related

VbA Code To Automatically Put Date Filename And Default Save Location

Aug 11, 2008

I have a spreadsheet that from a button I want to run a macro that will input todays date, the value in cell A1 as the filename into a default dialog box that is at a default file path. I have been trying to do this for several hours and can not completely get it done.

View 9 Replies View Related

Get Current Folder Location In VBA

Apr 20, 2012

How to query the current folder location in VBA?

The macro will need to import text from a file (file.out) located in iteration folders (iteration_001, etc) but I need to start by seaching the location that the excel file has been saved in.

View 5 Replies View Related

Generate A Folder Within A Specific Location

Nov 12, 2008

I am trying to generate a folder within a specific location (For now lets call it C:Jobs) that will be named as per the adjacent cell (Column H on attached)

Obviously if the folder already exists I want the code to stop.

But this code will have to generate a different folder for each row within the spreadsheet.

View 8 Replies View Related

Macro To Copy Folder From One Location To Another

Jul 12, 2012

I'm trying to write a set of macros and one of the macros needs to move a folder with subfolders from P:CJ to P:WO

Now I've been using the CopyFile State. Is there something similar because in my search they talk about using FileSystemObjects and I have now clue how to use those.

View 1 Replies View Related

Button Icon Folder Location

Oct 10, 2007

I am running WinNT and need to find the folder containing the default icons available for use on buttons in the toolbar window. I can copy the image but it saves as a picture (device independent bitmap). I want to be able to send the icon to other people so they can put it in their directory and choose to select it.

View 3 Replies View Related

Copying Data Irrespective Of Folder Location

Jun 4, 2012

I have a folder "Macro" in the below location in my PC:

C:UserskkumarDesktopMy WorksMacro

There are 4 excel files in this folder:
Sales.xls, Quantity.xls, Forecast.xls and Macro.xls.
Macro.xls has 3 sheets: Sales, Quantity & Forecast.

I want a macro which will pull all data in:
Sheet1 of Sales.xls to "Sales" sheet of Macro.xls
Sheet1 of Quantity.xls to "Quantity" sheet of Macro.xls
Sheet1 of Forecast.xls to "Forecast" sheet of Macro.xls

Also one additional requirement is if I copy the Macro folder to some other location in my PC the macro should still work.

View 3 Replies View Related

Change (Browse For Folder) To Automatically Locate Sub Folder

Jul 23, 2012

I am creating a document for work that automatically generates hyperlinks to pdf files in a given sub folder. Currently I have a section of code that opens a window to choose the folder location.

Code:
'Prompt user to select a directory
Do
Problem = False
Set ShellApp = CreateObject("Shell.Application"). _
Browseforfolder(0, "Please choose a folder", 0, "c:\")

On Error Resume Next

[Code] ........

What I actually want is to not have the window open, but excel automatically choose the sub folder location.

The directory looks like this
Z:ClientProjectDRAWINGS-2 RECORD COPIESPDF

The xlsm file is stored in the DRAWINGS folder, and I need it to point to the PDF folder.

View 9 Replies View Related

Create Folder Location Lookup From Database Values?

Feb 7, 2014

I have a template for information that needs uploaded into a database via CSV. This database is then access via a HTML front end. As part of this there is a 'folder structure' with in the front end. This is displayed in a database table (See attached excel file for example data structure)

Currently I have this feeding into a drop down list which is somewhat cumbersome so want to make it more efficient and easier to use. I had toyed with the idea of adding more columns into the excel template and split the string up to populate however this isnt exactly professional looking.

My current thinking is, is there a way of putting this data into a listbox which is easy to navigate? Ideally in a folder tree navigation structure, I know this is possible for a windows folder structure

Folder Structure.xlsx

View 1 Replies View Related

List Folder Location And Filenames Into A Table And Color?

Apr 14, 2014

i want to use the "Browse for Folder" to select the folder where the files is in eg. E:My DocsGlobal and list the folder location and filenames to table (column I:J), and color them according to every folder location.

I would like the "Browse for Folder" windows to be able to select multiple files instead of just one file a time.

View 1 Replies View Related

List Filename, Location & Attributes Of Files In Folder

May 21, 2008

Sorry that I'm very new in Excel VBA coder. And, for this topic, I don't even know how to start. I want to make a MS Excel database of a numerous files. This database must be consist of Filename, Location, and it's attribute (let's say updated date, size, hidden status)

View 2 Replies View Related

VBA Create New Folder In Current Location And Save Selected Sheets As PDF

Feb 2, 2014

I have the below code that saves selected sheets of my workbook as pdfs in the current file location. What I would like this code to be able to do is to create a new folder (named with todays date), and then save each of the pdfs into this folder.

Code:
Sub SaveWorksheetsAsPDFs()
Dim sFile As String
Dim sPath As String
Dim fPath As String
Dim wks As Worksheet

[Code] ........

View 3 Replies View Related

File Backup To Different Folder Location Automatically Whenever Workbook Closed

Feb 10, 2014

1. A workbook is closed

2. In addition to the original workbook being saved, a copy of the workbook with the current date is also saved to the specified location of my choice.

For example

"C:UsersUSER1DesktopBackup Test as of 02-10-14"

3. If a copy of the workbook is already saved with today's date, then overwrite it automatically without prompting the user.

4. All the above happens without any user interaction.

View 8 Replies View Related

To Change Hyperlinks In An Workbook

Jun 9, 2009

how to do this massively, without going into each cell? Maybe some VBA code. I just need to change the beginning of the path to point to another directory.

View 9 Replies View Related

Create List Of All Files In Folder And Make List Hyperlinks To File?

May 17, 2013

i have many excel workbooks in a folder i want a macro that will get the names of all the files and make the file names so extracted as a hyperlink to open the files.

View 1 Replies View Related

Change Address Of Multiple Hyperlinks

May 1, 2008

We have recently updated our office server the name was Procast-fs8 and is now Procast-fs6. eg old address \Procast-fs8docsQualitysuper secret doc.xlsx. new address \Procast-fs6docsQualitysuper secret doc.xlsx. we have a central quality control document in excel which uses hyperlinks there are around 5000 links in this document and i need to change all of them so they work with the new server address.

View 6 Replies View Related

How To Change Default Row Height

Aug 18, 2006

inability to set a default row height and still allow the occasional row that requires more space (i.e., one of it's cells has multiple lines of wrapped text) to AutoFit if necessary.

Say you have the data shown in NormalSettings.png in an Excel file (see attachments) and you want to have a little more room between the shorter rows, but not have them all set as big as the expanded rows. One way to do this in bulk is to select the entire spreadsheet and set a fixed row height, but this chops off any cells that require more space than your default height (see FixedRowHeight20.png). The only way to fix this is to manually scan through your sheet and individually select all rows with cells that need more room than your preferred row height and AutoFit them (good luck if your spreadsheet is any size...) . If you try selecting the entire sheet and choose Format-Row-Autofit, you're back to the crowded display shown in 'NormalSettings.png'.

My workaround to this annoying problem is this: choose a column that you're not using (I just select the very last column in the sheet by holding down CTRL and pressing the right arrow until the screen stops moving) and highlight the entire column by selecting the column header. Then increase the font size for that column...voila, even your blank rows will now AutoFit to the new font size rather than the font size you are using for your data...effectively increasing your default row height without sacrificing AutoFit capabilities. I find that using 16 as a dummy font size makes my data (which is font size 10, Arial) look nicely spaced out, but experiment and try stuff until you find what you like!

View 1 Replies View Related

Change The Default Settings

Dec 16, 2008

how do i change the default settings in excel, for example when i open excel it shows numbers on both rows and columns and i want it to show letters on the colunms. i know how to change the r1c1 reference style but how do i get it to stay the way i want?

View 4 Replies View Related

Change Default Printer

May 17, 2009

I have got a buttion that changes various layout and borders for the page then shows a printpreview, after printprewiew closes.

Then a msgbox that askes if you would like print. Is there a way to change the defult printer between local printer and adobe distiller(.pdf) as a dropdown option box. Or Yes for Local printer and NO for adobe distiller(.pdf) using vbYesNoCancle.

View 9 Replies View Related

How To Change The Default Module Name

Jan 14, 2007

When I open Visual Basic Editor and insert a module,the default name

is "Module1",How can I change the default as "Mymod1" or others ,and if

I insert another module later,it can be named as "Mymod2" by default?

I have searched the registry and found nothing about the item.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved