Working On Document While It Is Still Inside Flashdisk Or External Hard Disk

Apr 15, 2014

Is it risky for someone to edit an excel document while it is still in the flashdisk or external hard disk? I was told that this habit can lead to loss of data or the data can be affected if someone does this. I was told that I have to copy/cut paste the document onto my desktop, edit/ work on it then move it back to the storage device. Is all that work necessary, or can I simply work on the document while it is still in the flashdisk or external hard disk..

View 6 Replies


Does SSD Hard Disk Or A Faster Chip Improve Excel Performance

Apr 26, 2013

If I want to improve my excel performance like ability to open multiple excel and sheets to perform calculation, should I change to a SSD or a faster intel chip? My current PC sometimes give me a black screen for my excel sheet or is unable to save certain sheets when I open too many sheets.

View 3 Replies View Related

Avoid Hard Coding Control Name Inside Control Event Procedure?

Mar 4, 2014

Is there any way in VBA to refer to a control in its own event procedure without referring to it by name/hard-coding?

It might be clearer to explain by a dummy code example:

[Code] ......

I'm seeking what I would need to replace Line1 with.

View 11 Replies View Related

Changing Formula To Reference Spreadsheet From External Excel Document

Nov 22, 2011

how to change the formula below which is referencing an internal worksheet, to a forumula that will reference an external worksheet that is located in an excel document on the G: Drive.

=SUMPRODUCT(--(1210laradj_v_2009!F2:F65536="HMO-ALT SELECT"),--(ISNUMBER(MATCH(1210laradj_v_2009!AO2:AO65536,{3,5,9,12,37,39,46,47,54,73,74,75,76,77,78},0))))

So what it's doing is totaling the counts in the 1210laradj worksheet that match columns HMO-ALT SELECT as well as the numbers 3,5,9 etc.

Well now these worksheets will be on a seperate excel spreadsheet located on a network drive, so I am trying to figure out how I can fix this.

I tried adding it in like so, but it fails.

=SUMPRODUCT(--('G:ROC-CLAIMSAudit ResultsProvider infomonthly statsReproc'd claims2011ProductionCounts[0111rpt2235_laradj_v.xls]0111laradj_v_2009'!F2:F65536="HMO-ALT SELECT"),--(ISNUMBER(MATCH(1210laradj_v_2009!AO2:AO65536,{3,5,9,12,37,39,46,47,54,73,74,75,76,77,78},0))))

View 6 Replies View Related

Vlookup Inside IF Function Not Working?

Jan 7, 2014

I have the following formula that has ceased to work in excel. I don't think there are any errors in it so I'm unsure as to why the link no longer works. Neither of the files I'm using has moved location on the server.


I'm not sure if this makes much of a difference but people opening the file use various versions of Microsoft Office.

View 10 Replies View Related

Creating PDF File From Word Document Inside Folder With ID Number And Reference Number?

Jul 31, 2014

I have an excel database where I register cases. I have in it a button that creates a folder with and ID nr that is in column A (I create new ID nr in the next row, when I press the button it will create a folder with that ID nr and inserts a blank word document in it). We have a template that we copy to the folder (depending what type of case). The idea would be that once the template is filled in and ready to print, It would take the values from the ID nr and a reference number a few cells to the right. Is it possible to tell excel to open the word document in the folder and create a PDF version with the ID nr and reference number. (there are only 2 templates, so the macro would have to look for one of the two in the folder) The names of the templates are: "Standard" and "Other". I guess the best way to start maybe this would be that I select the cell with the ID nr and then press a macro button to have this done. One thing that needs to be done, is to put a copy in the same folder and another in a second folder called "Binder" in my documents folder.

View 1 Replies View Related

Absolute $ Or INDIRCET Not Working Inside Formula

Aug 15, 2014

For some reason Absolute $ or INDIRECT is not working inside my formula when I add a row to my chart. Formula keeps adjusting.

Here is my formula...=IFERROR(LARGE(IF($B$5:$B$50=$K108,$A$5:$A$50),1),"")

$B$5:$B$50 goes to $B$6:$B$51 AND $A$5:$A$50 goes to $A$6:$A$51..... it can't do that, throws my counts out, needs to stay in this range B5:B50 and A5:A50 when I add a row to chart

Also when I use INDIRECT


I keep getting a error with =$K108, which is a cell reference in my formula which the formula needs to look at

So what do I do, or what formula do I need to use to stop this from adjusting as I add rows to a chart to stop formula from adjusting?

View 8 Replies View Related

Conditional Code Not Working Inside A List Box

Feb 24, 2009

The following code worked for me until,I put inside a list box.

View 4 Replies View Related

INDIRECT Function Not Working Inside MATCH With Dynamic Ranges

Mar 25, 2014

I am getting a #REF error when using an INDIRECT function within a MATCH function to check against a dynamic named range. Basically, I am trying to get the row reference so that I can go back and extract other data from the row (in a table contained in another sheet) into the current worksheet.

I attach an example file for reference. The issue arises when a Dynamic Named Range is used. In the example file, if a value from a static range is chosen, the match with indirect function works, but it fails with the dynamic range.

Dynamic Ranges INDIRECT v2.xlsb

View 3 Replies View Related

Excel 2010 :: VBA Save AS (word Document) Not Working

Nov 8, 2012

I have a long bit of code that at one point saves a Word document and then saves it again with a new name and the old (legacy) .doc extension.

This all works find when the user is running Office 2007. However, it errors out for using Office 2010. The reference libraries are all correct (as far as I know).


Dim myDoc As Word.Document
Dim saveAsName as String

saveAsName = "some text here" + ".doc"


myDoc.SaveAs fileName:=(saveAsName), FileFormat:=wdFormatDocument

View 9 Replies View Related

Detecting If Floppy Disk Is In Drive

Aug 11, 2007

I'm trying to make it so that a backup copy of my file is written to floppy when the file is saved (but not with SaveAs). So far, I have the following code, which if the floppy is in the drive works fine, and doesn't error out if the disk is not in the drive. But it doesn't make sure that a backup copy actually got made. How would I check to see if the disk is in the drive and loop somehow until it was so that the file got saved to floppy?

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
On Error Resume Next
Application.DisplayAlerts = False
If Not (SaveAsUI) Then
MsgBox "Please Insert Floppy Disk in Drive A:"
ThisWorkbook.SaveCopyAs "A:" & ThisWorkbook.Name
End If
Application.DisplayAlerts = True
End Sub

View 9 Replies View Related

Save Just A Variable From Workbook To Disk

Apr 11, 2008

I have a workbook with a field that contains the users name in cell B1. The first time the user opens the workbook, they put their name in this cell. Is there a way that that name can be saved to disk outside of the workbook in the same directory as the workbook is saved and a formula be put in so that it will go get this name variable and insert it in B1 so the user doesn't have to enter their name each time.

I now have them putting their name in and saving the workbook which works until I send out an upgrade. Then they have to type in their name again.

View 9 Replies View Related

Saving Worksheets In Less Disk Space

Apr 27, 2007

I have a huge workbook that takes up a lot of memory. The user saves her work every day by saving the entire workbook. Hence, we are using up a lot of hard drive space. I have been trying to find a way to save the relevant worksheets in a format that consumes less disk space. I find that if I save a single worksheet as a web page without the option of interactivity the file is only about 50k. But I need to save three worksheets, not just one. Is there any way to do this? If not, is there any other SAVE AS method that allows one to save three worksheets at a reduced file size? I do not need interactivity, I simply need for the user to be able to go back and view the relevant information in each file.

View 7 Replies View Related

Excel 2010 :: Save Embedded PDF File To Disk?

Mar 4, 2014

Using Excel 2010, I have a workbook containing a variable number of PDF files captured as embedded OLE Objects. I wish to save each of the embedded PDF files to disk and assign the filename based on the contents of column 1 of the row containing the OLE Object.

View 1 Replies View Related

Searching For Mistakes In Document While Using Another Document As Reference

Feb 2, 2014

I am processing a fair few Invoices, which are being sent to me via e-mail as excel documents, very often they contain mistakes, a decent amount of mistakes. Usually the prices are wrong.

I keep track of every single entry on the invoice on my own document - Tracker, which I consider to be the superior/more correct document to the Invoice presented to me by my contractor.

Both of the documents have a reference number, which is a specific docket number, and horizontally, in the invoice, there is going to be a price for this docket. In my document, there is going to be a separate column for the total price.

Is it possible (I guess with VBA) to check for mistakes in the Invoice, but use the Tracker as a reference for this check.

Tracker has
A - Name
B - Department
C - Date
D - Docket No.
C - Total price for the docket (calculation of E to Z)
E to Z - all smaller entries

Invoice has
A - Date
B - Docket No.
C to E price for that docket, but it is spread, because departments are separated out, so each VAT account can be charged accordingly. I guess it is possible to do a separate column for the price, if it is easier to do a script that way.

Basically, I need to check if in the Invoice document, the price (C to E) for Docket No. (B) is the same as the price (C) for the Docket No. (D) in the Tracker.

I would like the wrong entries to be highlighted on the Invoice Document, so I can see straight away, that this needs attention.

Not always the price is wrong, sometimes the Docket No. is spelled incorrectly (Dyslexic contractor), hence the highlighting.

View 3 Replies View Related

Script That Will Turn Excel Document Into A Txt Document

Feb 17, 2009

I need a script that will turn a excel doc into a txt doc. Thats the easy part. The hard part (at least I think it is), is I need it to be in a certain format and I'll do my best to explain that fomat below.

View 9 Replies View Related

Hard Lag At The End Of One Sheet?

Jul 2, 2014

I am having a problem with excel, specifically a formatting/lag issue. I believe I know what the problem is, but I do not know how to solve it.

The file was too large to upload here, so you can find it in my dropbox.

The issue sheet is labeled Chain. Scroll down to the bottom to see the lag and delay.

After formatting many rows and columns of cells, all of the rows below the useful information has been formatted in different ways as well. This means thousands and hundreds of thousands of cells are formatted and doing nothing.

Just hiding the cells (which they are right now) takes forever, and you can clearly see the lag when selecting cells in the bottom row.

View 4 Replies View Related

Hard Find And Copy

Nov 2, 2008

I have a web query which updates regulaly, however, a lot of information is prodcued which i dont need or want. I know that the information I do want will always be in a single column, usually A or C.

The problem is further complicated. If I have the following search list on sheet1 column A:

Search List (sheet1) Web Query results (Sheet2) Known bad data (sheet1)

I need to be able to search through the information returned by the web-query, and find the first exact match in the returned data that exists in the lsearch ist, so in the above table the first exact match would be row 2 which contains only an E. Row 1 with AB is not a match as it does not exist in the search list.

So, having identfied where the first entry I am interested in (E) is, we need to copy all the cells below it until we find the first entry which then exists as an exact match in Known bad data column.

If all goes to plan, running the macro on the above data would output the following to sheet 1:

View 9 Replies View Related

Converting Worksheets To Hard Numbers

Feb 27, 2009

Has anyone created a marcro that will convert all the worksheets to Hard number, changing the formula results, (by Copying and paste, special, value). all at once?

View 10 Replies View Related

Column That Is Seperated By Hard Returns

Oct 17, 2007

i have a column that is seperated by hard returns how can i seperate them into new columns.

can i find replace a hard return and then text to columns.

View 9 Replies View Related

Replace Comma With Hard Return

Nov 14, 2006

I have a string in a cell which is essentially comma separated and want it in the same cell but with enters instead of commas. Cell info to start with would look like this

Bob, The, Builder

And the result I am looking for is


All within the same cell so I can create a label which uses this information on a user form. I have attached a small example.

View 4 Replies View Related

Hard Coded Number Range Into A Function

Apr 10, 2009

All I need is to use the forecast function =FORECAST(I902,F832:F901,I832:I901) but want to substitute a hard coded from and to value list, such as something like =forecast(71,F832:f901,{1-70})

That is, forecast case 71 given a range of 1 through 70. What is the correct syntax to give a from and to value? Curly brackets don't seem to work, and I don't want to do a list like {1,2,3,4,5,6,7...} which would be a pain.

View 9 Replies View Related

Hard Code Fill Color Of A Cell?

Dec 18, 2012

How to "hard code" a cell's fill color? I want to assign a cell's fill color to yellow. While setting the fill color is easily done, my problem is that as soon as I paste data into that cell, it looses its fill color. Is there a way to tell the cell to never change the fill color?

View 1 Replies View Related

Transferring An Image From Webcam To Hard Drive

Feb 16, 2009

Need macro that automate our QC department. What the macro does is it looks up the item number based on the barcode that the scanner reads and brings up the item number, the item description, total of units in a case, how much a single box of the item will weigh and how many units in the inner box may be sold at one time. The trouble is that not all items have an image available so that the person who is doing the checking knows what the item looks like.

There is a Logitech webcam setup to take pictures of the items. The following code allows us to import the image of the item into excel in a given cell:

View 5 Replies View Related

Inserting A Hard Return In A Textbox From A Userform

Aug 7, 2009

I have a userform that contains a textbox. How can I insert a "hard return" in the text portion to include a blank line between paragraphs?

View 2 Replies View Related

VBA Download Emails From Outlook To Hard Drive

Jul 3, 2014

code they have in use for saving emails and attachments to hard drive using VBA. I have found the attached- which is close although it only [URL]downloads attachments. I would like to go through the inbox and download files received on a specific date, from the inbox subfolders to sub folders on the harddrive

View 4 Replies View Related

Forcing A User To Hard Enter Into A Cell

Apr 8, 2009

Is it possible to lock a cell so that the user must enter the number manually as opposed to using a formula.

There is a cell on one of our spreadsheets that the user should be hand entering the numbers from the general ledger this is done to ensure that the general ledger balance is the same as the spreadsheets totals. However most of the user insert a formula that just copies the number from above into this cell that should be hand entered.

View 9 Replies View Related

Avoid Hard Coding Range Reference

Oct 5, 2006

I now can open all the workbooks in a filefolder and look at each of the sheets in each file and build an array to consolidate a range from one sheet to another. The problem is that the one range is hardcoded in the script (because that is what I was using to test.) I have written code to build an array of 66 rows and 5 columns that are stored in a worksheet in a named range.

how arrays work so I can use both of these arrays - one array ConsolParams(), to identify the range in the Sources part of the consolidate statement. The other array MyArray() stores the sheet names. Actually ConsolParams also stores "to" range now hardcoded as "J11".

Option Explicit

Private Sub cbConsolidateToRollups_Click()
Dim MyArray() As Variant
Dim Source As Variant
Dim sToPath As String
Dim sRollUpWB As String
Dim sRollUpToWs As String
Dim sRollUpFromWS As String
Dim sShtName As String
Dim sSourceWS As String
Dim nShts As Integer
Dim lCount As Long
Dim wbResults As Workbook
Dim wbCodeBook As Workbook
Dim WB As Workbook
Dim i As Integer
Dim r, c, p As Integer
Dim ConsolParams(5) As Variant
Dim CostType, RangeName, FromRange, TargetCell, TargetReport
Application. ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False.......................

View 6 Replies View Related

Hard Code Criteria In Database Functions

Oct 2, 2007

Cell A1 is HEAT_CODE
Cell A2 is W5H

In cell
=DMIN(Database,"Cost",A1:A2) return the proper value

I need something like the following so I can use fill down.

the above returns #VALUE! error.

View 6 Replies View Related

How To Populate Combobox With List Of Directories On Hard Drive

Aug 17, 2012

Is there an easy way to populate a combobox with a list of directories on the hard drive?

I want to create a way for a user to specify a file without having to type in the full address by hand.

I would like to start in the c:/ root and list the directories in one combobox and the excel files in another combobox. Then if they select say "desktop" it displayes the directories in "c:/desktop" and the excel files contained there in. Then if they click test it does directories in "c:/desktop/test" and so on.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved