I have a workbook that has many Pictures created with the Camera command. I have found that VBA macros in any workbook open at the same time as the one with Pictures run very slowly. Is there a way of temporarily turning off the Picture Refresh within the VBA in the same way as you can turn off automatic formula updating.
Keith
I'm working on a dashboard that shows some market developments. One of the problems is that I'm using linked pictures and a combo box to choose the appropriate graph, but sometimes the picture link returns a blank. Apparently this is a bug that can be fixed by running a macro that refreshes the picture link. Unfortunately I'm a real beginner with this kind of stuff.
View 1 Replies View RelatedI have Image tool located at range B1:F36.
I have a simple VBA Code like as following.
Sub test
Sheets("Sheet1").Image1.Picture = LoadPicture("")
Sheets("Sheet1").Image1.Picture = LoadPicture(CFPicPath + CFPic)
Range("A1:G37").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
end sub
I have a problem at
"Range("A1:G37").CopyPicture Appearance:=xlScreen, Format:=xlPicture"
It always copy a blank picture to paste on sheet2.
How can I able to refresh IMAGE tool before copy range as picture ?
I have a query with ODBC connection to a SQL database. This query's parameter is linked to a cell. The resultant data is the source for a pivot table. I want to refresh the pivot table, when the query is run. I've tried using the cell that triggers the query....but the problem is that the query takes about 10 seconds to run. By the time the query returns new data....the pivot has already refreshed. I need it to refresh AFTER the query is complete.
I tried adding a cell that sums up the data from the query...thinking when THAT changes (due to updated data), to trigger the pivot refresh. Problem is that I don't know the trigger for when the sum cell changes (ie....formula change, not typed in.)
i have an excel spreadsheet with 27 or so workeets. it contains sales figures in it.
I want to be able to link mutiple cells of this workbook to another workbook so that it retreives that data, So that when I hit the refresh (!) button it will automatically put the data in. I will recieve new sales figures (new files) on a monthly basis so i want it to be able to update the figures to the new figures.
In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?
View 1 Replies View RelatedI want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice
View 6 Replies View RelatedI have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula
My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.
i have saved some pictures in my excel sheet.
in the next sheet i want that when i write the picture name the picture will appear as vlookup helps in the getting text and nos. can i do this with pictures or i tried to get to much from excel.
I've got a spreadsheet with a few queries to extract data into my sheet. Whenever I open the spreadsheet, I get a "query refresh" dialog box, asking if I want to "Enable automatic refresh". I keep clicking on the "Enable" button but I have to keep answering the question for each open. Isn't there a way to set "yean - ok - refresh the data" so that I don't have to keep saying "yes"?
View 2 Replies View RelatedI am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB
why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?
I have this annoying problem with my excel 2003. And i have no clue at all how to solve this.
Each time i write 2.5 it turns into 02.may. Does any one know how i can fix this?
Will someone please tell me the difference (if there is a difference) between the following 2 lines of ....
View 6 Replies View RelatedI fill out this form everyday and sometimes need to type "S" and every time it fills in "Sampling Rate #1" because that's what it says in the same column higher up. Is it possible to turn this off somehow?
View 3 Replies View RelatedI want to turn on (tick) a check box from within a macro.
I have a sales and prospects spreadsheet. It has information in columns A to O. The last 3 columns M, N and O, require a 'Y' for Yes or 'N' for No entry. If entering N, the background colour of the cell turns grey using conditional formatting, and if entering Y the background colour of the cell turns Gold using conditional formatting. Column O is headed 'Sold', so that column is onviously the final Y. Upon entering Y in column O, ie the sale is made, I's like it that the whole row, so all cells of that row in columns A to and including O turn gold to easily visually differentiate done deals from prospects.
Also what would be cool is if when a deal is done, it not only turns the whole row gold, but moves the row to the top of the sheet, so by dividing done deals from prospects, that is utopia at this stage though, more important is turning the row gold upon a Y entry in column O.
I recently installed Office 2002 onto a new computer and found that whenever I drag-and-drop any amount of data from one cell to another, a loud obnoxious noise plays when I release the drag-and-drop data.
I was using the same version of Office on my old computer and did not have this problem.
I'm guessing it's a clipboard issue, since when I open the Excel clipboard (where I currently have all options as unchecked) and copy something so it is captured there, the same noise plays.
I already have turned off Windows sounds via the Control Panel and have no clue how to turn off this sound.
I'm going through financial statements and I would like to be able to run full blown analysis on them. Most public financial reports are written so that a lot of zero's do not take up the useful space. As such (and there is a ton of this solution out there I've found), many people want to take $1,500,000,000 and turn it into 1.5M
I however, do not. I want to convert it backwards. So when something says 5.19 I would like to format it in such a way that it will read (and I can run calculations against it) as 5,190,000,000 (there are no alpha characters, there are instances where there will be negative numbers). Then I could copy this to the 17 different financial statements I've already got rock'n rolling in Excel right now.
I have the Macro
[Code]....
That starts a timer macro (Recalc) in my excel sheet when the workbook is opened, my issue is that when the work book closes it continues to run.
Will the following macro fix this problem, or is there some command like Workbook_Open() but for closing?
[Code] ....
I have 2 lines with pairs and 3rd with corresponding values, nee to construct a matrix out of it with formulas
Example
Need to turn
AAABBDBCDCDC0.30.20.130.550.840.43
into
ABCDA11-0.31-0.21-0.13B0.311-0.551-0.84C0.20.5510.43D0.130.841-0.431
So the one that stands above in the initial file goes to the top line in the matrix. 2 line -> column in matrix. In case there is no match need to seek reverse in 1,2 and reflect as 1-VALUE in the matrix
Current Tabel:
Sheet1
ABCDEFGHIJKLMNO1EVENT NAME DATEGROUP / LOGOEVENT LOCATION DELIVERY DATEITEMCountMUGSBLK T'SPADSGREY T'S DRIVEBLK PENSCOINSBLK POLOS35Inter.05/01/12ABCShip to ABC04/25/12 60 45 32
This is what I want to do with it:
Sheet1
ABCDEFG1EVENT NAME DATEGROUP / LOGOEVENT LOCATION DELIVERY DATEITEMCount35Inter.05/01/12ABCShip to ABC04/25/12MUGS6036Inter.05/01/12ABCShip to ABC04/25/12BLK T'S 37Inter.05/01/12ABCShip to ABC04/25/12PADS4538Inter.05/01/12ABCShip to ABC04/25/12 DRIVE3239Inter.05/01/12ABCShip to ABC04/25/12GREY T'S 40Inter.05/01/12ABCShip to ABC04/25/12BLK PENS 41Inter.05/01/12ABCShip to ABC04/25/12COINS 42Inter.05/01/12ABCShip to ABC04/25/12BLK POLOS
How to stop my 100% from changing to 1000% after it pastes?
Here's the pc of code that is performing the copy/paste from one sheet to another sheet within the same workbook..
Code:
With Sheets("BOM Worksheet").Range("C" & nr)
.Value = c.Offset(, -16).Value
.Font.FontStyle = "Bold"
.Font.Color = RGB(186, 85, 211)
End With
I have a column of dates and have been asked to turn a cell next to it green, orange or red but I don't think this can be done?
Otherwise is there a way to turn the background of the cell a different colour, am sure there is?
What I need is if for example the date in the column is 01.08.08 then up until 7 days I want it to turn green, between 8-10 days I want it to go orange and over 10 days it needs to go red. Is this possible?
I need to turn a list of information into a true spreadsheet, how do I look up the information to fall under the appropriate headers?
Example:
Instead of...
Invoice # 000
Date Of invoice 01/01/08
Name: Smith/Steve
Invoice # 001
Date of invoice 01/01/08
Name: Smith/Sally
I need...
Invoice Date of invoice Name
000 01/01/08 Smith/Steve
001 01/01/08 Smith/Sally
"Decision Date". It is a numerical date (ex: 1/5/09 indicating January 5th 2009).
I need to turn that date into the week that it falls into within a particular quarter of a year.
1/5/09 would be Week 2 (it is in the second week of January, and 2nd week of the quarter)
2/3/09 would be week 6 (6th week of the quarter).
And then I need the formula to start over once each quarter restarts... for example, April 1st would be week 1 (1st week of the second quarter).
I have this formula:
=IF('2010'!R10C2="y",'2010'!R10C3,"")
And I want to be able to drag it down and have the cells update, but all it does is keep the same values.
Is there something I need to turn on or off.
i would like to know how to turn the word beside into numbers, ie if b=2,e=5,s=60,i=10,d=4,
also can this word be in the one cell or would it have to be entered separately, ie one letter per cell??
how to turn on the Comment Indicator through VBA? The code equivalent of setting Tools / Options / View and then selecting the Comment Indicator Only option.
View 2 Replies View RelatedIs it possible to create a rule that every time I type my name, for my e-mail address to pop up in excel instead?
For example, if I type "purple1686", I want "12purpleexample@domain.com" to show up as a hyperlink to my default e-mail program.
I am also curious if I was to write "my website" is it possible to make it a hyperlink to "www.purple1686example.com"?
Those two first may be easy to answer, so here is the challenging part for me:
Can I make that happen as a rule on every spreadsheet I open?
I don't know if I should make a template, or use a formula? The ideal scenario would be if there was a way to do it through conditional formatting.
I have used conditional formatting to change the color of a word every single time I open a new template and paste the words into it, or even by typing them out.
Is it possible to turn monthly data into daily? Repeating the same data for four sets of five working days to turn a CPI monthly inflation index into daily data, to turn example 1 into example 2.
Example 1.
DATEVALUE
2008-01-01 212.174
2008-02-01 212.687
2008-03-01 213.448
2008-04-01 213.942
2008-05-01 215.208
Example 2:
2008-01-01 212.174
2008-01-02 212.174
2008-01-03 212.174
2008-01-04 212.174