i have made a form with about 15 fields.
And now i want to make a button, wich copi the text in one of my fields.
is it posible, maybe made with "visual basic"???
hope someone can help me.
...VBA: Paste in a range
I am using the following code to paste the value of the given selected cell
to another sheet with the following VBA function. I have used a function to
get the row number for the given criteria in column "J".
For i = 0 To 5
If Cells(2 + i, 11) = 1 Then
myrow = Sheets("Sheet1").Cells(2 + i, 12).value
ThisWorkbook.Sheets("Sheet1").Cells(2 + i, 11).Copy
ThisWorkbook.Sheets("Sheet2").Range("f" & myrow).Paste
While execution ...Using Acces To Paste Visio Drawing Into Power Point Issue
I am using VBA (with MS Access) to copy a Visio file and paste it into power
point. When I do this using Access 2003, Power Point 2003, and Visio 2003
and power point slide has the ability to open the drawing as Visio by double
clicking the drawing. Everything is sharp looking too.
Now when I tried it using MS Access 2007, Power Point 2007, and Visio 2003,
the power point slide has only an image of the drawing and it looks likes its
out of focus too (not sharp looking).
Any suggestions ??? Below is my VBA Code
Set AppVisio = CreateObject("...FS: SQL Programming Database Management Books CHEAP!
I am selling these books in a lot. I am not selling them individually.
Most of the books are in NEW or LIKE NEW condition. A small minority are
older and may have some shelfwear. There may be remainder marks. There is
no highlighting or writing in the books.
If you are intereseted, please contact me at NOgymarquezHAM@sbcglobal.net.
You can get rid of the NO and the HAM in order to reach me at the proper
Please include the subject heading so that I will know which books your are
interested in as I am selling multiple groupings of books.
Understanding the New SQL: A Com...How to set program to view hyperlink?
When I make a hyperlink in Excel 2000, I cannot change which program opens
Where is the set file associations setting? I am hyperlinking to jpgs. It
opens my paint program (PSP) instead of my clipart viewer (ACDSee).
I have disassociated PSP with jpg - jpeg.
Associated ACDSee with jpg -jpeg.
Set Windows Explorer\Tools\Folder Options\File Types to open jpg - jpeg
extensions with ACDSee.
This was working, now all a sudden it has changed.
any chance your Windows settings have been changed?.
>When I make a hyperlink in Excel 2...Copy formulas in Office 2007
A customer can't use "Copy Special" in Office 2007.
He has upgradede Office 2007 from 2003.
When he copy cells to another workbook, the formulas aren't copied.
And when he tries the "Copy Special" a windows comes with questions about
He want's to be able to copy cells without formulas but with nubmer formats.
I'm able to do so on several PC's. Not on his.
Because of the upgrade?
My first guess is that the different workbooks are open in different instances
Close one workbook and that instance of exce...Trouble Pasting HTML table
I have been copying and pasting tables from web-pages
directly into excel for years. Now, all of a sudden I
can't. When I paste, the first cell clears out and no
data is pasted.
If I paste special as text only, the data appears all in
one cell. I'd like to post as HTML to maintain table
structure in excel. Any suggestions?
...Copy and Paste.
Hello Folks, Hope you are all well.
What I have tried to do is select every object on a page and paste it into a
new publication. Sounds simple?
However, when I try to do this on a page which has a table in it and then
try to paste that, the size of the table goes haywire. It then becomes a
manual task again to have to resize it / put text back to where it belongs
Please can someone tell me why this is happening and if there is a way to
fix to make it a simple copy and paste. Am using Win Xp and Publisher 03.
Your help is and always has been very much appreciated.
Thanking you in ...Copying Modified Invoices
We currently use SOP Short Invoice and I want to copy the report to the SOP
Other Invoice in report writer. The invoice layout is totally different, and
I am trying not to spend days recreating it. I could not locate any type of
copy functionality from one modified invoice to another. Any ideas out
there. We are on version 7.0
1.export the modified Short Invoice report as a package file.
2. open the Package file in notepad and change the Component name and Report
SOP Other Invoice and save
3. import the package file
"Zach Morgan" <ZachMorgan@discussions....copying non adjancent cells
sorry Ms. debra dalagliesh I missed your reply to my query. I got it later
through google groups search. thank you very much for clarifying my doubts.
I am repeating your message for the sake of readers seeing only this
copy of Ms. Dalgleish's message
from: Debra Dalgleish (dsd@contexturesXSPAM.com)
Subject: Re: copying non adjacent cells
If you want to copy multiple ranges, the selections must match in rows
In each column, the same rows must be selected, or nothing is selected
In each row, the same columns must be selected, or nothing is selected
For example, you...Modal form opens on startup
I hope this doesn't come across as stupid, but I'm almost completely
unfamiliar with Access. A client of mine has an Access 2000 database
containing some business information, and he'd like to have me import
it into Quickbooks. The problem I have is that I cannot get to the
information to export it from Access.
When the file is opened, I get a (I presume) modal form, configured as
a 'splash screen' type of thing. Has my client's logo, and the name of
the fellow who wrote the Access app.
Click that, and it closes, then opens another form for...Copy contents of a cell into a blank cell
How do I copy the contents of cell B2 into cell D2 only if D2 is empty
It cannot be done with a formula - only with VBA.
The following code should achieve what you described
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$D$2" Then
If Range("D2") = "" Then Range("D2") = Range("B2").Value
Copy Code above
Right click on sheet tab>View Code
Paste code into white pane that appears
Alt+F11 to return to Excel
"fire9...copying outlook express contact list
Anybody have an idea as to how I can bring an old contact
list into the same program again?
My old computer motherboard crashed. I purchased a new
computer and reloaded all the programs including Outlook.
I did manage to have the old hard drive put back into the
computer as a secondary drive (d) and maintained all the
With the outlook reinstalled to run off of the new c:
drive, there are of course no contacts. Is there a way to
find the outlook contact information on the old drive and
replace it into the reinstalled program on the c: drive?
This n...how do i print colour-seperated copy in publisher
am doing an exam in publisher shortly and need to know
What is meant by "colour-seperated"?
This is a new term for this ol Yank.
"caz" <firstname.lastname@example.org> wrote in message
> am doing an exam in publisher shortly and need to know
What version Publisher are you using? Look at the Commercial Printing in the
Print separations of your publication
Mary Saue...Process does not contain any programs (???)
A fascinating new bug in VS2003. Anyone seen this little gem?
I just converted a project from VS6 to VS.NET 2003. Added a bunch of new features. Built
it. New feature didn't work. Wanted to set a breakpoint. Breakpoint did not occur.
OK, finally add ASSERT(FALSE) to get into the debugger, can single-step. Found problem
Add another new feature. Make similar silly error. This one puts it into an infinite
loop. I see the problem instantly. Do Debug>Break All to enter debugger, get strange
"Unable to break execution. The process does not c...Exchange 2003 send multiple copies of same email to clients!
I have just finished the the basic setup of Echange 2003.
It only manages about 75 email acounts. I have noticed 2
things and think they are related. Firts if there is no
subject for email being recieved it will hang on that
email and never download to client using OutLook or
Outlook Express. I can go in and through the Web based
mail and remove the problem email all goes back to normal.
Secondly sometimes my clients will get multiple copies of
the same email. I have one now that has four copies and
everytime she opens her Outlook it gives her another copy.
Any help as always appreci..."Copy" isn't available now Error
I have a command button on my Main Form that is supposed to, on the OnClick
Event, set focus to a control on a subform and copy its contents and then
close the entire form but I am getting an error that "The command or action
"Copy" isn't available now." Any ideas about how to work around this?? The
OnGotFocus event of the text box to be copied runs it's own code that
concatenates text from all over the form. This box does have a tab stop but
I have it coded so that focus doesn't go to it directly for the user - only
for the purpose of copying h...What does Excel do when copying sheets containing a lot of Charts?
When I was copying some worksheets from one workbook to another, which
contains a lot of Charts. I found out that I can only copy 7 sheets with
Charts, the 8th one was copied but no chart was copied over.
And if I save the workbook that I just added several sheets with Charts, I
can't reopen it within the same excel. I have to close Excel and reopen
another one to open it without causing serious error.
My question is, what exactly excel does when I was copying worksheets from
one workbook to another?
I took suggestion from Jim Cone to turn off the AutoChartFontScaling. It
doesn...Macro that copy page to page just some filled cells
I want to create a formula (macro ) that helps me. I have in one sheet with
some columns that clientes filled with quantities and i want create fomula (
macro ) that copy just the filled cells and the cell with description (B2
cell is filled with quantities and A2 cell have the descrption product, and
I want a macro that just copy the filled cells to another page.
...Copying a named range with a changing cell reference
I am writing a macro to copy a sheet from a workbook to a new
workbook, it has hiddden rows which i am not copying just values,
however, I also want to copy the named ranges to the new sheet, the
problem being the cell references change as I get rid of hidden rows
and columns. Is there any way to carry over a named range, having it
refering to values or cell content rather than actuall cell
If you only need the values to be copied, you can use "Paste Special" and
select values to be pasted.
<email@example.com> skrev i en med...How to copy a Macro to another PC
How can I find and copy an Excel macro to another PC. As I recall the one I
created also created a file called Personal.xls that automatically opens up.
Not sure if this is the only file that needs to be copied? Also, where does
it get copied to? What location? Same as original PC?
Personal.xls is automatically opened (if it exists) but is hidden; use
Widows | Unhide to see if you have one. Generally it is kept in the XLSTART
folder; find it with a search.
However, some people have Excel open other files automatically; Use Tools |
Options and look on the General tab to see ...Chart Location Impact On Links When Copying To New Workbook
I have a sheet in Excel that contains all of my data. I also have several
charts based on thsi data. If the location for each of these sheets is "As
New Sheet" then if I copy the data sheet and chart sheets to a new workbook
then there are no links back to the original file (the chart source data
references the data sheet in the new file). However, if the chart location
for each of these charts is "As Object In" a worksheet, then when I select
the data sheet and the worksheet that has all of the embedded charts and copy
them to a new workbook, the charts create a ...Disable cut/copy of shape and images in excel 2007
I hope you can help me with this problem (I surfed a lot on the web but I
couldn't find anything about it): I have to disable cut copy and paste in
excel 2007 file expecially for images and shapes objects. for istance, I want
the user to be able to create an arrow, but I do not want him to cut, copy
and paste it.
can it be done?
because office 2007 manages shapes differently from office 2003, and all the
macros I have done so far work well with text but not with shapes.
Moreover, I tried to change the Ribbon with xml and it works fine, but the
problem is tha...writing Great Plains open orders into UPS program
I need to import the open sales order information into the UPS program. Has
anyone done something like this before? This is a one time thing.
ups have an ecommerce group that can help you with mapping the fields into
their system. you can download files fro mtheir website according to your
needs. in our case we upload their files to GP.
"Jack Tundra" wrote:
> I need to import the open sales order information into the UPS program. Has
> anyone done something like this before? This is a one time thing.
&qu...Copy macro enabled button to another file
I set up a macro-enabled button on one file(say A file).
I would like to copy the button to another file(say B file).
I find that I can copy the VBA module from VBA editor.
However, when the button was copied to the B file,
the macro on the button has the name of "A.xls!macro_name".
Then I have to delete "A.xls!" for the macro.
Can I just copy the macro name only, but not the previos file name that the
macro came from?
I would like to use that button to more than 200 files... It would be a lot
of work to change the macro name...