Is there a way to get excel in a macro to put a shortcut to the current file
on to the desktop?
Thanks in advance
Here is some code
Dim oWSH As Object
Dim oShortcut As Object
Dim sPathDeskTop As String
Set oWSH = CreateObject("WScript.Shell")
sPathDeskTop = oWSH.SpecialFolders("Desktop")
Set oShortcut = oWSH.CreateShortCut(sPathDeskTop & "\" & _
ActiveWorkbook.Name & ".lnk")
.TargetPath = ActiveWorkbook.FullName
Set oWSH = Nothing...The Missing Link (jr.)
I am looking for the contact info. for the company who developed this add-on
tool for Dynamics GP.
Microsoft SBF Specialist
1/25/2008 1:20:24 PM
> I am looking for the contact info. for the company who developed this
> add-on tool for Dynamics GP.
> Tarun Dham
How do I disable the creation of the backup copy?
Created in 97, used thru 2000 & 2003.
Deleting file just causes a new one to be created next time I run spreadsheet.
Don't confuse backup with Excel's requirement to maintain
two copies of a file while working on it. If this involves
diskettes you should be aware that you should never access
removeable media directly from Excel or risk loss.
You might wish you didn't stop creating a backup copy (.XLK) for your file, but
Save As (F12 key), then on the Save As Dialog menus: Tools -->
General Options, *uncheck*...Error in copying HTML Table to Excel
I have Excel 97 (english version) installed on my WIN NT
and when I try to COPY a table from IE6.0 (HTML) which
uses Greek encoding, and PASTE into Excel I get undefined
...BROWSE AN IMAGE from hardisk an past to excel
my .xls must be simply a foto and a button "browse".
I want that i can browse a photo from hardisk and, when i selected, it
Can you help me?
Try this Disperso
MyPath = "C:\"
Change this to your path
Dim FName As Variant
Dim wb As Workbook
Dim MyPath As String
Dim SaveDriveDir As String
SaveDriveDir = CurDir
MyPath = "C:\"
FName = Application.GetOpenFilename(filefilter:= _
Can anyone help - Im finding that if i Cut an entire row
which has cells in it that hve Conditional Formatts and
Insert that row elsewhere in a workbook that the
conditional formatts get all messed up, this seems to be a
glich with Excel 2000 - does any one know of any fixes -
it doesnt do the same think in Excel XP. Please email me
if you can help or know how i can ask microsoft direct
without it costing me a fortune
My guess is that the Conditional Formatting is using a formula rather than a
cell value. It may be the relative/absolute cell references in the
formulas. Give de...Copying Graphs to Word
Using Office XL. I am copying graphs from Excel to a Word
document. The copy command does pick-up the graph area
and pastes over to Word. However, consistently it will
drop one or two legends/text boxes in the copying
process. Which one it drops is not consistent. The rest
of the graph will be great and pops right in. Any
suggestions? I can be corresponded to directly at this
newsgroup or e-mail.
Have you tried Edit|Paste Special and specified Picture (Metafile)?
The chart will be static (not linked to Excel workbook).
"Jim" <firstname.lastname@example.org> wrote in me...copy bitmap to Lotus Notes and email
I am trying to copy a range of cells as a bitmap file and copy that
file into Lotus Notes using my macro. Can anyone help me?
This is the offending code:
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
bodytext = ActiveSheet.Paste
At the moment the variable bodytext represents the data I want to
appear in the message. I adapted the code from elsewhere where this was
defined as a string, but i changed it to a variant as string and bitmap
are probably not compatible.
Help help please!
...Text being cut off
Hello - I have a portrait folded card (tent card) that I am using to make
place settings. The name of the person is in a text box at the bottom of the
page as normal, then at the top the text box is rotated so that the name is
upside down -this way when the card is folded in half the name is rightside
up on both sides.
The text in the box that is upside down is being barely cut off when I
print, just as if the top third is being shaved away straight across. Is this
a publisher issue because the text is flipped or could it be my printer?
It is the limitation of your printer...Problem Copying Charts to PowerPoint
I have some Excel code that copies some Excel charts to PowerPoint. It's
giving me an error message that the clipboard is empty. Something in my code
must be emptying the clipboard, but I don't see what it is. The error
message occurs when I try to paste the chart at the last line of the code
Range("Analysis_Left").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Set myAPP = CreateObject("Powerpoint.Application")
myAPP.Visible = True
myAPP.WindowState = ppWindowMinimized
ThisWorkbook.A...Help: I am trying to create buttons in Excel
I am trying to create an expand/collapse button (+/-
button) to group similar cells. For example, if cell A1
has "catch22", cell A2 "catch23", A3 catch24, I am trying
to group them under "catch" and create a button next to
it. How would I do this? Thank you.
Look at Data>Group and Outline.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"fenisol" <email@example.com> wrote in message
news:firstname.lastname@example.org...Copy Security Task , Role from Installation to another In GP10
I had test upgrade from GP 9 to GP 10 on test environment, then I
setup some security roles and tasks,
Now i need to upgrading in live server ..... the question here is:
Is there a way to copy "Security Task ,Security Role and Alternate
Modified/Forms and Reports" from Company to another company?
such as Export All security from company then Import it in other
There are a number of security copy functions that are not provided in v10.
You cannot, for example, copy a user's security to a new user. You can copy
one user's company security to another com...What files to copy
Hi all, I having some problems with my PC. (some type of virus I suspect).
So I want to copy my Money files to a another HDD before I fdisk my boot
drive. My backup copy is old.
What files do I need to copy and where would I find them.
I would go to the Microsoft FAQ's but no apps will actually start on the PC
and I don't have web access here at work.
Hi Mr. InOnly
Do a search for *.mny, and that should find all your money files and then
you can select the ones you want.
"Mr. 1nOnly" <mr_1nonlyNO_SPAM@hotmail.com.remove> wrote in message
news:_ixlb.3...cut & paste with short cut keys (ctrl C V) with absolute cell refe
How do I cut & paste in Excel with short cut keys (ctrl C V) but maintain
absolute cell references rather than it always keeping relative references
use a cell reference such as
"Modeller Dave" <Modeller Dave@discussions.microsoft.com> schrieb im
> How do I cut & paste in Excel with short cut keys (ctrl C V) but
> absolute cell references rather than it always keeping relative
Hello I have a few questions:
1. Is there a version of Publisher that had NO Text Wrap in the Picture
2. Is it possible to send a picture back or forward in Publisher as there
is in Words Drawing Toolbar? Did any version of Publisher have a Drawing
Toolbar like Word?
3. When copying text from the internet, sometimes the text can be inserted
in an existing empty Text Box (like in a brochure template) and other times
it creates it's own Text Box outside in the Work Area. Why?
4. When inserting ClipArt, is there any way to change the background of the
ClipArt's box to..."Delete Record" command button woes
I just added what I thought was going to be a 'Delete Record' cmd button to
my Access form. Here's the VBA the 'wizard' created:
Private Sub Command96_Click()
On Error GoTo Err_Command96_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Apart from making this pronging sound when I click it, it has no other effect.
Anyone know what's going on? I would've ...| appears when I hit shift button
A | pops up when I hit the shift key to long. It will even ||||||||| do this
if I leave it on to long. ANy ideas how to turn this off? I have Office 2003
with Word and Excel etc. Thanks
This sounds like the sticky keys option from Windows accessibilty options.
Turn it off via Windows control panel.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>&...Memo field last line cut off in print preview, not in report view
I have created a report that includes a memo field. Can grow is enabled. In
Report view, it is fine, shows all the memo field info. However, in print
preview, it cuts off the last line.
Any help would be greatly appreciated.
...Cut Paste Pages
how do I cut or copy pages out of one publisher document into another document?
> how do I cut or copy pages out of one publisher document into another
Open both documents, copy from one paste in the other, select whichever
Wisdom and experience come with age, they say, but I do wish I could
remember the darn question
...Paste SPecial #4
I've noticed when I use Paste Special to link cells from
one sheet to another, do the paste and then move the
cursor to another cell, if I hit the Enter key the
contents of the clipboard seem to be pasted into the
sheet. Is this because of the Paste Special being
a "special" operation when it completes the original copt
is still active??
...Cutting and pasting annoyance
I frequently copy large amounts of data in msexcel.
So often I get the warning that the amount on clipbaord is too large to
Is there a way to turn this off in: properties, registry, whatever...
I would be happy if it always assumed that it is ok to dump the clipboard
When are you getting this message--when you're closing the workbook (or closing
If yes, you can hit the escape key to stop that warning. It clears Excel's
> I frequently copy large amounts of data in msexcel.
> So often I get the warning that the amoun...copying messages from Widows Mail to Entourage (Office:mac 2008)
Email Client: pop How do I import messages from Vista Windows Mail
(eml file) into Entourage? (Office:mac 2008)
On 2/2/10 3:54 PM, mikeyb wrote:
> Email Client: pop How do I import messages from Vista Windows Mail
> (eml file) into Entourage? (Office:mac 2008)
If these are indeed .eml files then you should be able to drag them
directly into Entourage into whatever folder you choose.
Hope this helps!
Entourage Help Page <http://entourage.mvps.org/>
Entourage Help Blog <http://blog.entourage.mvps.org/>
YouTalk <http://nine.pairlist.net/mail...Copying and pasting ???
Im working with a .iif file from quickbooks inside excel and have
question regarding copying and pasting.
Lets say for example cell A1 Says "AUTO". Well Cells A2 throught A43
need to have "AUTO:" before the part number so it shows up as a su
category in quickbooks.
Auto: 1235 and so on.
Is there a way to copy/paste "AUTO:" into the column without going int
each cell and pasting "AUTO:"....just tryin to save a little time that
NorcalT...How to not copy the numbering from numbered list in Word ?
I want to copy a numbered list in Word and paste to a text file.
The numbers show up. How do I not copy the numbers preceding the
Thanks very much in advanced.
By temporarily disabling the numbers and bullets in word before
you copy and paste the text. Then you can simply close the word
document (without saving it) so that no changes in the word file
That one time call girl may suggest that you should use Tipex on
the screen to remove the numbers!!! You have been warned.
> Hi !
> I want to co...Missing CD/DVD Drive
I have an Acer machine running Vista Home Premium with SP2. The machine is
now two years old has been working fine until recently. I am finding that
the DVD drive does not appear in My Computer or Device Manager when the
machine is restarted after being in Sleep mode. The drive can be restored by
doing a Shut Down.
I have found a few similar problems in this forum but the reports were not
exactly the same so I am reluctant to follow the suggested solution of
editing the Registry in case it does more harm than good.
Any ideas please?
See the following