Over 1 million tech questions and answers.

Solved: hyperlink in excel to a specific file in a zip file

Q: Solved: hyperlink in excel to a specific file in a zip file

Is it possible to create a hyperlink in an excel spreadsheet that goes to a SPECIFIC FILE within a zipped file? If so, how do you do it?



Preferred Solution: Solved: hyperlink in excel to a specific file in a zip file

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: hyperlink in excel to a specific file in a zip file

Read other 14 answers

I am trying to create a macro that will look at the contents of a cell and insert it into an address on the server. For example, the contents of the cell is: folder\file

The location to hyperlink to is: \\server\share\folder\file.doc

I need to keep the file extension in the macro so that clicking the link will automatically open the file. I just need to get the contents of the cell to fill in the folder name and file name.

Thanks in advance.

A:Solved: Excel Hyperlink Macro to File

Read other 16 answers


Ive been searching the net for help with this and i just cant find what im looking for.

Im still new at excel macro's so still learning everyday.

I need help to wright a macro that will search in a folder for a file with a specific keyword that can be in the file name.

example: lets say i want to open a file that is in a folder that has "leadership" in the files name.
Because i send the file to people called "leadership.xls" and i recieve files back called "copyofleadership.xls" and different other names but there will always be leadership in the file name.

Can anyone please help me with this.


A:Excel macro to open a file in a folder with a specific keyword in the file names

Read other 6 answers

Hello all. Not a regular user of Excel; but do need help in creating something that would be useful to me and a few others at work. I suppose the best way of explaining what I'm after is by giving an example.

I have a directory C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson
In Cape Nelson are a number of folders named alpha beta charlie delta echo and foxtrot and so on.

I would like to have an excel template in "Cape Nelson" with a macro that when activated names the file as whatever folder name might be in say cell A1 and whatever ever date might be in cell B1. Eg charlie_15-mar-2013.xls
This then is saved in the relevant folder. So in the end I would end up with
C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson\charlie\charlie_15-mar-2013.xls

Also the macro script would ensure that the macro was disabled in the saved file.

Hoping this is achievable and look forward to replies.

A:Solved: Excel 2010 - Macro to name and save file to a specific folder

Read other 16 answers

We have an old MS-DOS program that runs from a batch file. When I try to access the program by clicking on it's hyperlink in an Excel spreadsheet, the program does not load (you can see the command line screen briefly, but it disappears). I can load the problem without any problems from it's network location, so I know the program is working. What is preventing the program from working/loading in Excel?

A:Cant' access batch file via hyperlink in Excel

Can you access the file using a hyperlink on a html?

Read other 2 answers

Hi Guys,

I need a help with excel macro's.

I have a excel file with a set of hyperlink(to open a XML file). I need the data's in all the hyperlink (.XML file) in an excel format.
Could you please help me out? Is this possible to do with VBA macro?

Please advice.

Thank You

A:VBA Code to open a XML Hyperlink and convert to Excel file

I'm a little confused can you post your xl sheet?

Read other 2 answers

clicking on "file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141" in excel redirect to browser but omits "file:///" &"?3/4/3141" portion from the hyperlink thus doesn't open in the browser. how can I let excel redirect file:// protocol without modifying the link
I am cross posting due to time constrains and due to that no one is responding and due to the fact it is a difficult issue to resolve. and I promise when I get it solved I will notify you promptly.

Read other answers

So I havea pdf (hundreds of pages) that is stored online for my company and I am trying to create a hyperlink in excel to take people a page 15 in the document. I've tried adding #page=15 and when I click the link it still takes me to first page in the document (as a result of url losing the #page=15). When I copy and past the link into the browser it obviously retains the page callout and work correctly.

Any thoughts or solutions would be greatly appreciated!

Read other answers

Hi All,

I am trying to create a hyperlink in Excel that will open up a specific page from a .pdf file stored on a network drive. Unfortunately I am only able to get the pdf file to open to the first page. Any help would be greatly appreciated!!!!


A:Hyperlink to specific .pdf page from Excel

Read other 16 answers

I am using Acrobat 9 and want to set a hyperlink from Excel to a specific page in a PDF. I have tried destinations and links with no success. Any one able to do it. It is on a shared network drive and not a website.

A:Hyperlink from Excel to specific page in PDF

Did you create the pdf file? (do you have the originating .doc?) In some cases, yes.

Does the pdf have existing bookmarks? No, bookmarks

Read other 1 answers

Hi guys,

First time on here! From Dublin, Ireland!

I am trying to work on a spreadsheet whereby I want a specific hyperlink in an excel cell to open a pdf to a specific page.

Now I have managed to work with some code where I am able to do as such, however I am getting stuck at a very simple part.

The code works and opens the required page in the pdf in internet explorer, however I need different pdfs to open through the hyperlinks in different cells. Unfortunately, when I click a hyperlink, it is opening all the pdfs I've specified. Is there a way to assign the code to one singular cell so that only the required pdf opens through that cell, and similarly different pdfs in different cells?

I have to add hyperlinks to about 100 cells and while a few of them will open the same document, the pages will be different.

Basically, when I click a link, I just want the req'd page in the pdf to open, but it is opening all the pages specified, even ones for different cells.

The following is my code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim IE As Object
Dim s As String, sFile As String
Dim iPageNum As Long
If Range("J17").Value <> "" Then
sFile = "C:\Passdowns\Linked Procedures\Startup Guide.pdf" '<- Modify to suit
iPageNum = 12
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate sFile & "#Page=" & iPageNum
IE.Visible = True
End If
P... Read more

A:Open excel hyperlink to specific page on local pdf

You need to loop through the range with a variable and use the value of that to access the cell.
At the moment you are treating the whole array of cells as one.

Read other 1 answers

For several years I've had a shortcut to a specific Excel file pinned to the Windows 7 Taskbar. When I clicked it, it caused Excel to open the file as desired. Somehow the shortcut disappeared from the Taskbar, and I'm now trying to recreate it. I can create a shortcut on the Desktop with the icon that I want that does what I want (i.e., double-clicking causes Excel to open the file).

However when I drag that shortcut to the Taskbar the icon changes to an Excel icon, and clicking the icon causes Excel to open a blank workbook. Right-clicking the Excel icon does open a menu with the subject file listed, but that's not what I want.

As I say, I had it working as desired for several years, so I know what I want can be done, but I can't figure out how I originally did it. Can anyone help?

A:Can't pin a shortcut to a specific Excel file to the Taskbar

Create a new shortcut with a target similar to

explorer "C:\Users\Me\Documents\myspreadsheet.xlsx"
Pin the new shortcut file to the taskbar.

Read other 2 answers

i have Office 2010 installed in my company.
a user edited an Excel workbook and somehow got the sheets to disappear.
if i open a new workbook, they appear fine.
i know the trick about maximizing, but it's not the case.
i also tried the Home>format>visibility>hide/unhide
i managed to unhide a sheet but the sheets bar at bottom is still not visible.

if i open it on another computer with an older version of excel is opens fine.
i tried opening it on another computer with Excel 2010 and it opens without the sheets bar.

is there a way to undo all changes or restore default settings for a file?
edit: as always, when you post your problem you suddenly found a solution:
so the solution is: http://office.microsoft.com/en-us/ex...010278741.aspx


A:Excel Sheets Disapeared on one specific file.

Quote: Originally Posted by Shayx

edit: as always, when you post your problem you suddenly found a solution:
so the solution is: Where are my worksheet tabs? - Excel - Office.com

Well done!

Thanks for posting back.

Read other 1 answers

Hi there,

I am trying to use SQL.REQUEST to pull data from one excel file (a master data file) to another one, and I can't get it to work. I think I don't have the correct connection string specified.

I'm using Excel 2002 on Windows 2000.

The task is, I need to build dynamic queries based on other cells in the "output" spreadsheet, such as, get a count of all records in the master file where the date field is equal to [cell reference] and the ID field is equal to [another cell reference] and a third field is equal to [third cell reference]...
So that, if the values in those referenced cells change, the records that match (and get counted up) will be different.
Also, there will be at least 10 different queries (I do a sum on a field that is a time duration, an average on that same field in another, etc) in different places on the spreadsheet.

I was able to get a simple query to work in Microsoft Query if I used static values, ie, I typed them directly into the criteria... however, these need to by dynamic so that when the same spreadsheet (a report template) is "saved-as" and new values for the criteria are input, the queries don't have to be re-created.

So, using MS Query, I can connect to the master data file and get the correct result... but I believe what I really need to use is SQL.REQUEST, so I downloaded the ODBC add-in and installed that.
I just can't seem to figure out what my connection string argument needs to be.
Th... Read more

A:Solved: sql request in excel file, to another excel file - connection string?

Nevermind folks - I googled +excel +"connection string" for probably the 20th time in 4 days... I usually investigate all result about 7 pages deep before giving up, and this morning, all of a sudden a new result popped up right at the top:

at about the same time, my boyfriend finally took a look at it, and he came up with this result: http://www.devlist.com/ConnectionStringsPage.aspx

I used the syntax in this example
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
(I almost got up and danced, I was so happy)

Just thought I'd come back and post the solution, in case anyone else ends up finding this thread in the same position I was in.

Now how do I mark this thing solved?

Read other 1 answers

Hello Everyone, Its my first post here :-)

I have a text file with values printed like these;

Last seen: 14/12/2011 - 16:06:12
Vendor: Cisco Systems
Signal: -91 dBm
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 25
Unique WEP IVs: 0

Last seen: 14/12/2011 - 15:57:27
Signal: -96 dBm
SSID: Misuss
Enc: WEP
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 6, 9, 12, 48, 18, 24, 36, 54,
Packets: 7
Unique WEP IVs: 0

Last seen: 14/12/2011 - 15:56:49
Vendor: Cisco Systems
Signal: -95 dBm
SSID: Mobile
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 2
Unique WEP IVs: 0

I want to export this all to an excel spreadsheet with columns representing BSSID, Last Seen, vendor, Signal, SSID, Enc, Mode etc., and all the values belonging for an BSSID in a single row. Does it look doable? If yes, please let me know how to achieve this, and I will be highly obliged.

Much thanks!


A:Please Help - Data in Text File to be arranged in Excel in a specific

First, two questions: how proficient are you with Word and Excel? Are you comfortable using the REPLACE function in both?

If reasonably proficient and comfortable (understand) with the REPLACE function, it isn't difficult and will take about 15 minutes to accomplish what you seek.

Open the text file in Word.

Turn on the SHOW ALL switch (the paragraph mark icon).

Your post example has MANUAL LINE BREAKS after each line - if the source file has them, replace all of them with PARAGRAPH MARK.

Add a PARAGRAPH MARK (Enter) at the very beginning of the document.

Replace DOUBLE PARAGRAPH MARKS with PARAGRAPH MARK, hash mark (#) - makes it easier to see what you are doing next - and PARAGRAPH MARK like this:

Find what: ^p^p
Replace with: ^p#^p

Now add the tilde (~) in front of each line:

Find what: ^pBSSID:
Replace with: ^p~BSSID:

Repeat for each line of a record (total of 11 times).

Delete all of the hash marks (#):

Find what: ^p#^p
Replace with: ^p

Now your records are:
> Separated by a carriage return (paragraph mark)
> Fields are separated by the tilde (~)
> The first imported column will be EMPTY

Save the txt file and close Word.

Open Excel.
Open file type: All Files (*.*)

Select your text file.

In the import steps:
Step 1: Delimited
Step 2: deselect Tab and select Other, set to ~


Insert a header row and label each column.

Select each colum one at a time and delete the corresponding record field leaders. Be... Read more

Read other 2 answers

Hi Gurus,

I have many excel files containing similar data.

1. I want to copy specific columns (columns A to U) from all files and paste the consolidated data into another excel file.

2. I also want to copy specific columns (columns C,D,E,G,H,K,L,T,V,W,X,Y) and paste the consolidated data in a different excel.

Please help.

A:Excel macro - copy specific columns from different files to one file

Are all of these source Excel files stored in the same directory? Do they need to be opened and consolidated in any particular order? More details please. If possible please try to provide a sample file with any sensitive data removed.


Read other 1 answers


Starting from row 4:
I need the code to copy down the first name,
then starting from column g to cd in that row, it should copy down the mark for a subject (if there is a mark under that subject heading), otherwise skip that that subject.
also copy down that subject's, subject code, which is in the second worksheet.

In summary, If mark under subject for that person, look at subject, compare against code list, copy subject's code, then copy the mark.

Copy down any comment for that person.
Further details in the attached file.

Maybe a loop function or something?
Im very unfamiliar with VB so all i can really do is copy and paste code.

Any help at all would be appreciated.



NOTE: I have also cross-posted in another forum, so any updates should also be checked there:





A:Excel - How to export only non-empty cells within a specific range to notepad file?

Read other 6 answers

This problem is on excel 2003. This is the error that occurs and I have no idea how to correct it. I create a hyperlink in excel and then click on it and get this error:

Hyperlink unable to open. No program is registered to open this file


Read other answers

I have 2 files.
File A- Flash file
File B-html file
They are in the same folder

I want to hyperlink a button in the flash animation to open up a html page in internet explorer. How do i go abt doing it without specifing "c:/folder_name/file b"? They are in the same folder, so i just put in the name "file b" in the hyperlink entry box.

I am not sure if i used the wrong hyperlink to do it or not. And i am not sure of what the help file says. Can someone tell mi how is it done?

Thankx a lotz

Read other answers

I am using windows 7 with office 2010.

I am trying to use the text in an adjacent cell, a movie title, search a folder to find a shortcut to that movie title, and have it appear next to the title. I have been searching using Google, using small precise search terms such as "excel macro file" or "excel macro search for file". I have gotten kind of close to what I'm looking for, but not quite there.

Hopefully the code below will give the reader of this post a better idea of what I'm trying to do. I was initially thinking a search routine, but then realized that the path was always the same (all of these shortcuts are in the same folder), so why not just copy the text from the adjacent cell and "build" my own link. That's what the following routine does and it does work ... provided all the movies are the same format, i.e., .wmv, .avi, .mkv, etc., which they are not. As a result the only two choices I have would be to convert all the movies to the same format, which would take for ever, or use a search routine, which I haven't mastered, and where I need some help.
Here is the build your own link routine:
Sub Insert_Hyperlink2()
Dim Hold As String
' Macro1 Macro

Dim wsM As Worksheet, wsA As Worksheet
Dim isPresent As Boolean
Application.ScreenUpdating = False
' Relate the sheets to the variables
Set wsM = Sheets("Movie Info")

Hold = wsM.Cells(10, 4)
Range("E10")... Read more

A:Find file, hyperlink to found file

Read other 10 answers

I have two separate files...one is an Inventory List, and the other is a Parts Code List. The Inventory List displays each automobile part along with a parts code. The table of parts codes and their corresponding details are found in the Parts Code List. How can I get the Inventory List to display the Parts List details on the Inventory List?

A:Solved: EXCEL--Matching a table on one file with another file

Read other 16 answers

While in excel, I would like to open another excel file and read some information.

The file I am reading from, will have a row with "Avg." in Col A with data in Col B through L in that row that I want to extract. The data line will be in a different place in all excel files and there may be 2 lines to read.

At this time, I have used the Open command successfully to find the file but do not know how to proceed (?the open structure may be wrong?).

I am familiar with loops and variables but can can not figure out the rest unique to excel.

Any help would be appreciated.

A:Solved: Read excel file B while in excel file A

Read other 16 answers

I need a script to add multiple hyperlinks to multiple files.

I have a Word document, with multiple rows and columns. Each 'cell' has 50 titles. I need to add a hyperlink for each title, to each respective video file in a particular folder.


The entire line can be the link. How do I define each cell, and each item in each cell?

How will each target file be defined in succession?

Looks like Windows will do this task for 1 item at a time, with a GUI dialogue. Is this a job for Open Office, with open source?

A:Solved: Script file for multiple hyperlink insertion? Hello Outcaste?

Read other 16 answers

Dear All,

I need to create a batch file which can read the size of file(e.g. 1kb, 2kb...etc) from specific folder and detect 0kb file and convert it to text file (showing 0kb file size) with alarm.

I am not really sure how to write command for this batch file. Please help :-(

A:How to create a batch file to read size of file on specific folder path

Read other 10 answers

I have Windows XP-Pro SP2 installed on a P4 1.8GHz CPU with 768MB RAM

I would like a script that opens a commamd window and calls for a file (icon file) to be copied to a specific folder on 5 different drives. I would like to be able to either paste in the file path or drag and drop the file onto the command window. The icon file will always come from the same folder "C:\WINDOWS\system32\00 ICONS\System Folders" and be copied, sometimes replacing a file with the same name, to these 5 folders:

"W:\WINDOWS\system32\00 ICONS\System Folders"

"X:\0 aAPPS\00 a Install First\00 ICONS\System Folders"

"W:\WINDOWS\system32\00 ICONS\System Folders"

"N:\0 aAPPS\00 a Install First\00 ICONS\System Folders"

"D:\0 aAPPS\00 a Install First\00 ICONS\System Folders"

I apologize if I am using incorrect terms. I don't know if a batch file could do this or if it would have to be done with vbs. I would appreciate the help. I know nothing about writng vbs script and only a little about writing batch files.
Thank you.

A:Script to call for a file then copy file to specific folders

My question was answered on a different site.

Here is the link:


Read other 1 answers

Please, can someone help out an old sailor?

I wand to direct the following button link to a specific FRAME location like the link below
<input type="button" value="Go Skyliners"

<A HREF="http://www.google.com/" TARGET="Frame13503">Google</A>


A:Solved: direct hyperlink to a specific frame

This is a web development issue. Click report on your post and ask a moderator to move it to the Web Development category.

Read other 1 answers

Hi guys1
I'm about to create a .reg file that will set path in registry to my own icon for specific file extensions. E.g. I want my own icon as a default icon for .ini extension. And not only for one extension but for more of them, in a single .reg file. As always I don't want to mess it up,so I'm looking for some basic assistance on how to fill a notepad. And I know this is the best place to look at

P.S. I do use a Default Program Editor and File Types Manager, but I wanted a single .reg that will do the job for multiple modifications in a single click, something like backup of icon-registry-modifications, as I like to format my PC every year to ensure clean working environment. Setting things up de novo is a lot of fun but time consuming... I made a backup of registry and a Restore Point, just in case.

For any idea, thanks in advance!!

A:.reg file to set default icon for specific file extensions


If changing the icon worked with the tools you mention, use Process Monitor or Regshot to track down specific changes in the registry for .ini that change the icon. Then create similar registry entries for other extensions in your REG-file.


Read other 7 answers

Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

A:Excel cannot open the file 'file.xlsx' because the file format

Older versions of Microsoft Office can't open the newer office formats,try updating and installing Microsofts file format converters. http://www.microsoft.com/en-gb/download/details.aspx?id=3

Read other 2 answers

I have been using this same Excel file for many years. I viewed on my new home laptop 2 days ago, using a 2010 Excel Version. It was created on 2007.

I opened it on my work computer, version 2003, and now get the above error message on both machines. The file can no longer be opened.

I have tried emailing it, still won't open.

I have chenged the file type to both .xls and .xlxs neither open.

I downloaded the program on the home page of this site, and it said no file issues, no known problems for this file.

When I click Open File, it still shows where I had the file opened (the file name in lighter gray font - but cannot open.) The original file is in black, and I can open. But, get that message.

I also tried to open and fix - and I tried both options, with formulas, and without formulas, and all it opened was foreign characters.

Any other suggestions? Or is this file gone? Unfortunately, my most recent back up is 3-4 months old...

Thank you for your help,

A:Excel File now says File Format or File Extension is not valid...

Read other 6 answers

I need to exclude an HP .tmp file from disk cleaners such as Cleanup4!, crap cleaner,

Will ATF cleaner permit me to exclude specific files / folders?


A:Solved: cleanup - exclude specific .tmp file

Read other 15 answers

Hello all!
So I work tech support at my company and recently had one of our secretaries run into a virus. It was an email containing a fake resume in .doc format that once opened, attempted to direct the computer to download a trojan. AVG detected it right off the bat and quarantined it. I then ran a full system scan with AVG, Malwarebytes, and Spybot and everything came back clean.  I had assumed AVG along with Word being macro-disabled by default kept anything from actually happening.
However, at the time of the download she was running our company bookkeeping software (eClub for those interested) and it crashed once she tried to use it again. I check it out and see that the .exe to run eClub had been removed from the eClub folder (let's call it eclub.exe). Weird! So I go ahead and completely uninstall the program and reinstall, only to find eclub.exe was not reinstalled with it. I copy eclub.exe from another computer and try to paste it into the folder, and I'm told I don't have permission to do so. Then things get weird:
1. I uninstalled eClub completely again, removed the eClub folder and every possible saved setting for it.
2. I created a blank eClub folder (ex. C:\Program Files\eClub)
3. I can put anything I want into this folder, including .exes, EXCEPT for eclub.exe, getting the insufficient permission error.
4. I can put eclub.exe in subfolders of C:\Program Files\eClub without a problem
I checked all my permission levels and have fu... Read more

A:Virus Preventing Specific File from Being Created in Specific Folder

Please post the Malwarebytes Antimalware log in your topic.
To find your Malwarebytes log,download mbam-check.exe from here and save it to your desktop.
To open the log double click on mbam-check.exe on your desktop.  Copy and paste the log in your topic.
 Please run TDSSKiller.
Please download TDSSKiller from here and save it to your Desktop.
The log for the TDSSKiller can be very long.  If you go to the bottom of the log to where you find Scan finished you will see the results of the scan.  If it shows Detected object count: 0 and Actual detected object count: 0, this means that nothing malicious was found and you will not need to post the log.
1.  Doubleclick on TDSSKiller.exe to run the application, then click on Change parameters.
2.  Check Loaded Modules, Verify Driver Digital Signature, and Detect TDLFS file system.
If you are asked to reboot because an "Extended Monitoring Driver is required" please click Reboot now.
3.  Click Start Scan and allow the scan process to run.
4.  If threats are detected select Cure (if available) for all of them unless otherwise instructed.
 ***Do NOT select Delete!
Click on Continue.
 Emsisoft Emergency Kit
Please download Emsisoft Emergency Kit and save it to your desktop. Double click on the EmsisoftEmergencyKit file you downloaded to extract ... Read more

Read other 1 answers

I have a file on my desktop which keeps making windows explorer crash and restart in a continuous loop. The file is an MKV file from my new HD camera (cheap one off ebay which I am now suspicious is dodgy) which is sitting on my desktop.

Explorer crashes when I log on to MY username almost instantly when it loads up. I'v booted it up in safe mode and explorer is fine but I can't delete the file. Everything (time remaining ect) still says calculating on wont delete it.

I can log on as another user and explorer is fine until I touch that file. I can rename, delete or do hatever to any other file on my desktop (on someone elses account) but as soon as I do something to this file, explorer crashes and restarts so I assume that file is infected. Iv scanned with AVG and malwarebytes and also used F-secure and onecare's online scanner, not finding anything except a few tracking cookies (F-secure was my first scan which removed them).

I'm currently uploading the file to VirusTotal so I'll see what that says.

Any other ideas on how to delete the file? It's useless anyway.

Thank you.

A:Solved: Windows Explorer keeps crashing with a specific file

Read other 9 answers


I was wondering if there was a piece of software or a script that could monitor a folder for changes. Specifically, when a new file is created in that folder, it would be able to move all of the older files to a different folder.

I have found ways to do this based on how old a file is, but I just need to be able to move all of the old files in a specific folder once a new file is created there.

A:Solved: Can A Specific Event Trigger A File Move?

Read other 16 answers


When the file is in the desktop or any other folder it is 3:25 long, but when i put it on an specific folder it gets shorter to 1:40, this happens only with 2 files.

Appreciate the help.

A:Solved: MP3 file gets shorter (length) in an specific destination

If i change the name of the file it gets to the original length, also if i move the folder where the file is to another location. So the problem seem to be the specific URL with the specific name of the file, that makes it shorter.

Read other 14 answers

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers

Created a worksheet with formulas, in Excel 97, and saved it on floppy and hard drive. Can open worksheet from floppy and hard drive in Excel 97 but not Excel 2003. Formula cells become #NAME?

Sample of formula:
='C:\blp\api\dde\Blp.xla'!BLP(C190&" equity","ask",,,RTD("BLOOMBERG.RTD","","IZU+UV Equity","ASK"))

How can I resolve? Thanks.

A:Solved: Can't Open Excel 97 File in Excel 2003

Read other 7 answers


I am looking to create some code to move a sheet from one file to a new excel file. SO the code needs to open a new excel workbook and place the required sheet in the resultant new file.

I have managed to do this with an existing file "Moved Pivot" per the code below. This is ok but other people will be using my sheet so the location needs to be chosen by them. A new file seems to be the only solution?

Workbooks.Open Filename:="C:\desktop\Optegra Installer\Moved Pivot.xls"

Dim oTargetSheet As Worksheet
Set oTargetSheet = Workbooks("Moved Pivot.xls").Worksheets(1)
Call ThisWorkbook.Worksheets("PIVOT_TB").Copy(oTargetSheet)
Set oTargetSheet = Nothing

Any help much appreciated. Thanks


A:Solved: Excel VBA to move worksheet to new excel file

Read other 8 answers


I have the following PDF file whereby I am unable to open the links below. Chapter 10 Option 1 etc.

Qualitative Considerations

It is also important to take into consideration the non-financial elements of

replacing the equipment. New equipment and technology may allow CM2 to

operate more efficiently, but a consequence may be layoffs of skilled labor.

Layoffs could lead to decreased employee morale, which may lead to

employees being disgruntled and as a result, less productive. Analyzing

the effects of such a qualitative factor is an important consideration along

with the quantitative effects of replacing the equipment.

Refer to Excel File Solutions:

Chapter 10 Option 1

Chapter 10 Option 2

Chapter 10 Option 3

Chapter 10 Option 4

A:Hyperlink not working in PDF file

Read other 12 answers

I have a data base of PFD drawings and I would like them to be accessible in a master schedule in excel.

As of now we type in a part # and a cell finds the part description and inserts it in the adjacent cell.

I worked out a way to make a hyperlink in a separate file that links to a folder holding the drawings (FYI, that's 800 hyperlinks !). My schedule sheet then uses a vlookup to find the hyperlink associated with the part number cell. The friendly name of the hyperlink in the intermediate spreadsheet is the same as the actual hyperlink, so the Schedule sheet shows a hyperlink in the cell and will open the drawing.

I'm not a programer but I can fudge my way threw such things. I woudl like to keep it simple:
Can I create a hyperlink in the Schedule that would reference a cell (part number) and find that PDF file (named the same as the part #) in a file folder and be able to hit that cell and open the drawing when needed.

I don't know VB, but I do use macros on occasion.

I hope this is clean. Any suggestions?


A:Finding a file using a hyperlink

As long as your naming and placement of the files in a directory is consistent you can just append the file name into a hyperlink path. I think there are controls that will open Windows seach as well.

Read other 2 answers

Please help me,
How to copy data from last row used of excel file to new excel file using vbscript?

Read other answers

I need convert/save Excel files into the ASCII comma delimited text files. It needs to be in this format in order to upload healthcare data to the CDC (NHSN).

Thank you.

A:How to convert/save an Excel file to ASCII comma delimited text file

File - Save As. Change Save as type option at the bottom...

Read other 3 answers

Well, where to put this strange problem? XP, Office or Network Forum. All three seem to be involved somehow.

What gives?

I have a few large Excel files on
a) a share on a Win XP SP2 desktop
b) a share on a WIn Vista desktop
c) a share on a Ubuntu 6.06 desktop

When i mean large, i mean ~75Mb

When i work on my laptop (Win Xp SP2, 1Gb Ram, 1,86 GHz), i can access all shares just fine. But when i right click such a large Excel file on the XP or Vista computer and click 'Properties', my laptop becomes unresponsive for about a minute. Then, at last, the properties are shown. In the Taskmanager, on the LAN tab, it shows that my LAN connection is swamped at 70% for a whole minute. Sniffing the network traffic learns that the entire contents of the file is being transferred through the network to my laptop!
Just to see the properties...

However, when i right click the same file on a Ubuntu share, the properties come up instantly.

When i right click other large files on the XP/Vista shares (like *.iso of *.avi files), bingo, properties pop up instantly.

When i right click the large Excel files on the Xp/Vista share from a Win 2003 server (without office installed), voila, properties show up instantly.

So why is the whole Excel file transferred by just right clicking it for properties?
I'm convinced this behaviour adds to slow file share performance in general. For example, if i want to copy such a large excel file form the XP or Vista share, it takes 10... Read more

A:Right clicking a large Excel file in a network share makes the entire file being sent

sounds to me like your computer doesn't have much ram.

how much ram does your computer have?

Christian Dude

Read other 13 answers

I'm trying to open in Excel 2010 a file with .exf extension that is always a pipe delimited text file. I have set, using Windows file associations, to open this type of file with Excel. But, I would like for it to recognize that it is pipe delimited, so that I don't have to click on Delimited, Other, "|" to import the file. Any ideas? I also thought about using a macro to save some steps as well. Thanks for your help!

A:Excel import pipe delimited file based on file extension

Hi, welcome tothe forum
Macro is the solution, just start the macro recorder, give it a name and do what you do, stop the recorder and you have the macro.
Simple as pie

Read other 3 answers

Hi Tech Guys,

I needed support for corrupted and excel files, do you know any best word and excel corrupted recovery software? i recovered a deleted word and excel file, but when i opened it some are okay and some are corrupted.

Please i really need help.. thanks in advance

Read other answers

SharePoint and other hyperlink .Jpg file opening in IE browser instead of Windows Photo Viewer.
So I want to avoid open .Jpg file in IE browser.
Any body have some solution for this.

Rahi Padariya

Read other answers

I've got Excel 2000. (Win98)
The PC froze / hung-up while in excel. Could only power off to restart.
Now when you access the file you get a message that the "file is in use" and can only be opened in read only mode.

"When you open a file that is in use, you'll get a message that tells you the file must be opened in read-only mode. In some cases, you may get this message even though the file is definitely not in use. This can be caused by an Excel crash, in which the file was not released."

The file was being accessed on another PC via a basic household network.
Our work around at present was to access the file in Read-only mode and save it as a new file. The old file still exists. I can't delete it as I get the same file in use message.

But, I'm still working on the older file to see if I can unlock it some how.
Tried the following:
1) Check/deleted temp files on the editing PC.
2) Checked the file attributes on the file (Note: the file did not have the "Read-only" attribute ticked)
3) Now checking the source PC for temp files.

Any direction greatly appreciated.

A:Error caused excel file to file in Use and read-only

Save yourself some time.
Open the old file.
Right-click a sheet tab and hit Select all sheets.
Right-click again and hit Move or Copy.
Choose the create a copy box, and from the dropdown, choose New book.
Save the new book. Make sure all is well. Delete the old book.

Read other 3 answers