VBA Opening worksheet, name changes
I have a VBA code - that opens a worksheet, then gets data. The problem is
that the worksheet name can change, then it won't open. Is there anyway to
save the worksheet name as some variable, that can reference the worksheet
name/location + will automatically update?
Use the codename not the Excel name.
This is usually the same, Sheet1, Sheet2, etc, but it doesn't change if the
user changes the Excel name.
You use it like
"Jeff" <Jeff@di...Publishing Form Changes via Web Access
I access CRM 1.2 via the web. In the past I have made changes to forms and
they have appeared when I save and close.
This no longer happens. Our IT support have restarted IIS but to no avail.
Can anyone help please?
Have you published your changes before restarting IIS? In 1.2, only altering
views and picklists showed up dynamically. Any form changes must be pulbished
in the Deployment Mananger first.
A> I access CRM 1.2 via the web. In the past I have made changes to
A> forms and they have...DOS Function in a Macro?
Can I create an Access macro that runs a DOS command. The command is "DIR
Or better yet is there a way to bring up a dialog box and select the
directory I want to run that DOS command on?
Thanks in advance
Perhaps there is a better solution to my dilema. I'd like to have a
function that queries the contents of a selected folder and writes that data
to a table. For example:
This gives me the ability to inventory data that I receive. ...macro run-time dialog box causing integration manager problem in GP9.0
I'm using AutoDim and windows scheduler to run integrations in
integration manager. In GP7.5 it all worked fine but now that I've
upgraded to GP9 there is a macro run-time dailog box that's causing
problems. I see the documentation on how to supress the dialog within a
macro using Logging file '<filename>.txt' but this doesn't work. I'm
thinking it's a timing issue or the fact that the macro starts outside
the scope of the dynamics runtime (AutoDim is calling the macro) so
once dynamics is open and running the logging file command is out of
scope? Is ther...Find a empty cell in next column
Dave helped me with this before, now i need more help.
I use this code to find a column called PoF and the numbers written in the
cells below it. This code work in every row/column (i dont need to name it).
PoFRow = 0
PoFCol = 0
On Error Resume Next
PoFRow = Worksheets(2).Range("PoF").Row
PoFCol = Worksheets(2).Range("PoF").Column
On Error GoTo 0
If PoFRow = 0 Then
MsgBox "No range named PoF on worksheet:" ' & .Name '
Set numberPoF = Nothing
On Error Resume Next
Set num...Run macro in new workbook
I have a programe that exports a csv file and names it dumporders.csv. I
would like to be able to run a macro to format this data. How can I import a
macro into this file without having to recreate it every time?
open the vb editor(alt+F11)
on the left right click the module you want to export then
click export. a save dailog box will apear. give it a name.
it will export as a .bas file extention. remember where
you put it.
open the other file. open the vb editor. on the left right
click the project name. click import. a dialog box will
come up. select the macro you just downloade...stop word 07 from automatic minimizing other apps like calculator
Word 2007 will automatically minimize new apps I open such as Excel or
microsoft calculator. It will briefly display the app, then put it behind the
open document. To use those apps, I have to minimize word, then expand it
when I am done with the app. Is there a way to stop this?
That's nothing to do with Word. It sounds more like an AV bug or a Windows
problem. Maybe you have enabled X-mouse in the Mouse settings?
Terry Farrell - MSWord MVP
"doodlesquat" <email@example.com> wrote in message
news:CF65CCFD-4428-4D3B-AC69-85A7509B0...how to use a cell contents as a graph title
I want to be able to use the contents of a cell to set the title of a chart.
Changing the cell contents would then automatically change the title of the
You can find details here
Andy Pope, Microsoft MVP - Excel
"Carl" <Carl@discussions.microsoft.com> wrote in message
>I want to be able to use the contents of a cell to set the title of a
> Changing the cell contents would then automatically change the ti...Mirroring cells
I'm trying to duplicate cells exactly from one sheet to the next. I'm
using IF commands to get the data entered in a cell in one sheet to
show up in the next, but is there anyway to also mirror the format,
i.e. bolded text, highlights, etc.?
Thanks in advance!
careyc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26064
View this thread: http://www.excelforum.com/showthread.php?threadid=476778
Use Copy / Paste. It will copy both the cell's contents and its forma...Chart scale automatically changing in ppt2007
I have a stacked bar chart that I update daily. Often when I update the
datasheet, it automatically changes the scale of the graph on me. This is a
problem because I have items that are not part of the actual chart but that
I've added to it on the slide, such as carots pointing to the bars at certain
heights. It seems that if I make the bars taller than some undefined
threshold, it makes the chart change size and throws everything off. When I
increase the numbers in the datasheet, I just want the bar to get taller, not
change scale. Any suggestions how to make it stop changin...Highlighting cells
Excel 2007 sp1 with vista 32 business sp1
Background: When you highlight multiple non-contigious cells (i.e. hold the
control key down and select several cells that are not connected) Excel
highlights the selected cells in light blue.
Problem: This light blue does not show at all on many projectors. In some
case you can adjust the color temp and this helps. We do hundreds of
presentation in North America each year and can not control what projection
equipment we will be using.
Requested solution: I would change the light blue background that is applied
to selected cells to some othe...Format colorful for a cell (that has formula)
Formating colorful for a cell that has formula is posible?
For example: = "I'm " & 1 + 1 & "years old"
And the desired result is: "I'm 2 years old"
So, these is any way for me to do this. Please help. Thanks so much.
OverAC's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3239
View this thread: http://www.excelforum.com/showthread.php?threadid=53585
You could write a UDF to test if a cell has a formula
Function IsF...Help with POPing errors due to messsages with suspect files
I'm having difficulty POPing mail from an Exchange 2000 server (using an
Outlook 2003 client). Generally, everything works fine, however,
occasionally, a message that is later confirmed to contain a virus, causes
POPing to grind to a halt. Messages received after the suspect message will
not download to the client!
Both the server and the client are running Symantec anti virus plugins.
What gives? Thanks for any help.
Cut off: yourhead to respond
Dab <noThanks@hotmail.com> wrote:
> I'm having difficulty POPing mail from an Exchange 2000 server (usin...Forms time calculation
I am attempting to create a calculation in a form that will still enter it
into the main table.
I am attempting to calculate total hours of down time from entries in the DT
Months, DT Weeks, DT Days, DT Hours, DT Minutes entry boxes.
My calculation might look something like this:
Down Time=(((DT Months*21)*24)+((DT Weeks*5)*24)+(DT Days*24)+DT Hours+(DT
I would like it to display in the form as well as the table the form updates.
I am a learn by trial and error and asking questions novice at MS Access and
would like to get as much help as I can, please.
Thanks to anyone who...Get/Change Operation on SY_ResourceActivity
I am running Dynamics on SQL. I physically deleted SY00800 & SY008001
manually rather than running the delete query on the tables. Therefore, when
I try to log into Dynamics now and get to choosing which company I want to
use, I get an error message that is a get/change operation error on
SY_ResourceActivity. Does some have the queries to recreate these tables, or
is there another solution to this problem. I cannot find any solution to it
Can you not restore your Dynamics database? That is your best option.
Use at your own risk... this is from GP 8.0
CREATE T...Display progress of a macro
Is there something like a status bar which gives one information about the
progress of a macro
"Sub 1 executing"
"Sub 2 executing - 50 lines processed"
A Msgbox could work, but that halts the process - I do not want to halt the
process. The immediate window could work, but then the VB editor must be
I think I recall seeing something, but cannot find it now.
There is something exactly like a Statusbar. In fact, it's called Statusbar
application.statusbar = "Hi from aaaa"
&...Change address and phonenumber to contacts in "new case" window.
If I am in the middle of creating a new case and talks with the customer on
the phone...I wants to be able to change the customers address, phonenumber,
computername, username....and so on in the New case window. I've got no time
to find the contact and update this information and then back to the New case
window and type in the customers problem. But I want to be able to change
this information in both ways.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree&...Time calculations #3
I want to try to put together a store employee schedule for my son and I am
wondering what is the best way to deal with time calculations.
they do not use a 24 hour format so how can I do calculation (shift times,
Employee availability times, sum of hours......) when the times are AM/PM
Any guidance here will be appreciated.
You can add and subtract times irrespective of the format. 17:00 less 08:00
returns 9:00 the same as 5:00 PM less 8:00 AM returns 9:00.
You will need to use the number format to format answers correctly. When
summing hours that ...Appl crash after Inst. SQLServer2008Express due to new MFC in WinS
Microsoft SQL Server 2008 Express installs a new MFC Version in WinSXS folder
Therefore the previously used MFC 8.0.50727.762 in WinSXS folder is not used
Our Application does NOT crash using MFC 8.0.50727.762, but crashes with MFC
8.0.50727.1833 in CDialog::CreateIndirect
What happens when it crashes in debugger? Is it your application or MFC
which is responsible for this? Debugging will give clues about the problem.
"Wolfgang Kruck" <WolfgangKruck@discussions.microsoft.com> wrote...Outlook 2003: You do not have permission to change the current timezone
Here is my current setup:
OS: Vista Business 32-bit
Server Env.: POP3, no exchange server
When I try to change the current timezone, I get the error "You do not have
permission to change the current timezone". I was able to do that when I
have Windows XP. I've already disabled the user access control but it is
still NOT ok. Can anyone give me some hints? Thanks.
are you changing it within outlook's time zone dialog or vista's? did you
upgrade vista over xp?
are you logged in with a user or admin acct? if a user acct, open the
control pa...changing investment types
I used to use Quicken 99 then changed over Money 2004 (both were Canadian
versions). The trust unit investments I have from the pre Money days are all
classified as mutual funds, as Quicken treated them as such. My new ones are
listed as stocks, and I'm finding that more details (yield, etc) are
downloaded. I can't find a way to simply change the old trust units to
stocks. What would be the best way to do this? Thanks in advance.
In microsoft.public.money, fj wrote:
>I used to use Quicken 99 then changed over Money 2004 (both were Canadian
>versions). The tru...insert row below where the cell data is "Wednesday"
Can someone help me? I checked Excel Help and didn't find insert row
based on data....thanks!!
....Lisa Excel 2003
look in vba help index for FIND if only one or FINDNEXT if more. Good
<firstname.lastname@example.org> wrote in message
> Can someone help me? I checked Excel Help and didn't find insert row
> based on data....thanks!!
> ...Lisa Excel 2003
If you're trying to insert a new row when the values in a column change, may...Cell format
I have a set of cells that show the fraction of #complete/#total. They
are formatted as fractions so that I can custom format them such that
those >=50% turn green and those <50% turn red. The problem is that
for a completion of, say 8/12, excel automatically simplifies to 2/3.
Is is possible for excel to still recognize the cell as a fraction but
You can directly control this by formatting in advance. Let's say you enter
the data in twelths and want it to remain that way:
Format > Cells... > Number > Custom and then enter
Experiment with forma...Slow Code Execution 02-11-10
I have a some code that I am using to read the contents of each cell of the
multiple rows in a 4 columned table.
I am experiencing a slow down when my code gets to a particular line of code
Set myRange = oTable.Rows(i).Cells(j).Range
when the table contains less than 100 rows the macro flies along really
quickly, however when the number of rows is increased to 500 or so, my code
grinds to a snail's pace, but strangely (at least in my eyes) this slowdown
occurs on the very first line in the table.row.count is high (I would've
thought that the cod...Associate a cell with a number ??
i work in a medical center all of my patients have been given
patient ID # Mr Smith = 276
is there a way that all i have to do in column "a" is put "276"
and in the same cell in column "b" Mr. Smith name will show.
Message posted from http://www.ExcelForum.com
have a look at VLOOKUP for this. See:
> i work in a medical center all of my patients have been given
> patient ID # Mr Smith = 276
> is there a w...