How can i move a macro from one computer to another
i would like to move a macro from one computer to another i Excel
Macros live in excel workbooks.
So you can just copy that workbook with the macro to the other pc and open it
> i would like to move a macro from one computer to another i Excel
Or you could export the module containing the macro as a *.BAS file, email it
to other computer then import to another workbook.
Gord Dibben Excel MVP
On Wed, 08 Sep 2004 07:05:48 -0500, Dave Peterson <firstname.lastname@example.org> wrote:
>Macros live in excel workbooks.
>So ...suggested ways to manipulate XML files in .Net?
I'm going to manipulate some XML files in my next project-- crawl through
the tags, compare if file X has the same nodes as file Y, and if not, what
the differences are and who's missing what. I'll also be comparing values
between nodes in the two files, for when both documents do have the same
named nodes. What .Net classes should I be looking at to accomplish these
tasks? Thanks a bunch.
Steve Hershoff wrote:
> I'm going to manipulate some XML files in my next project-- crawl through
> the tags, compare if file X has the same nodes as file Y, and...Strange behavior when copying formula.
Here is what I'm trying to do. I want to show the summation of the first
two rows' number in the third row. I use the summation function to get the
first result. Then, I copy and paste the result to the other two, but they
show the same results as the first one. I check the formula of all three
results, and they are all correct and referring to the right cells. Why is
1 2 3
1 2 3
2 2 2
Do you have Tools/Options/Calculation set to Manual?
If so, click the Automatic button.
In article <eE#EeXFhDHA.2512@TK2MSFTNGP09.phx.gbl>,
"Leo Leon...Excel 2007 and Word 2007 Hangs when using the File -> Open command
I have a couple users that when they have Excel 2007 or Word 2007 open, and
click the File -> Open option, and choose a file, it either takes about 3
minutes to open the file or the program will crash. If they were to double
click on the documents or spreadsheets, the doc or sheet will open right up.
This is happening on the user's Hard drive as well as network drives.
Once you get a file opened in Word or Excel, however, the next time you go
to File -> Open, it's really fast to open the file.
...Saving chart as an image file
I want to create a pie chart in Microsoft Excel, then
save it as an image file (.jpg or .gif) so I can put it
on a website. How do I do this?
Secondly, as I create my pie chart, how do I set my data
labels? I want to change them from the default (numbers)
to my own description for each slice.
Jon Peltier has some instructions in his Excel Charting FAQ article for
exporting a chart in gif format:
To add your own labels to the chart, you can use Rob Bovey's XY Chart
Labeler. It's a free add-in that yo...Integration Manager--log file name?
Is there any way to know the name of the log file (we're writing our logs to
text file) from within one of the "After" integration events? If we're
successful, we need to send the user an email telling them that the event is
successful. We're currently cycling through the whole folder to find the
latest one, but if there were a variable in the Integration Manager VBScripts
that I could use, that would be much better.
If I recall correctly, IM has a Document Error and Integration Error event
in the integration properties. Rather than looking at the...Soft copy of training material
I have completed the class room training of CRM 3.0 Installatio and
Customization. I also got the printed training material.
But soetimes, searching something in the book becomes very difficult. Can I
have the soft copy of these training manuals?
Does Microsoft provides it?
We are Gold certified partners btw.
If anybody has some idea about this, please let me know.
should find everything from your course in the eLearning Courses (or at
least, I'd presume so). Either way, the online courses are a handy thing ...File Sharing between XP Pro and XP Home
I have a few questions concerning file sharing between XP Pro and XP Home in
a Workgroup environment. I would really appreciate any help.
1)From what I'm gathering on the internet (I've read multiple articles) you
cannot even connect a Windows XP Home computer to a domain. I'm I
interpreting this correctly?
2)I have a new server with XP Pro and 5 other computers with XP Home. I
only have 3 computers (which includes the new XP Pro server) that really
need access to everything (or the main folders) on the server. The other 3
computers need limited access. If I purchase X...PDF file #5
I have Publisher 2002 and would like to insert a .pdf
file into a document I am working on. How do / Can I do
When I open a file it says it is linked to another file. When I check the
links it is linked to a file I no longer have. How do I find where the link
is coming from and get rid of it. Going to the Edit Links doesn't seem to
get rid of the file.
Try Bill Manville's excellent "FindLink" utility ..
It's available at Stephen Bullen's page:
GMT+8, 1� 22' N 103� 45' E
"Charlie 5280" <Charlie email@example.com>...Retrieve .pst files
My PC at work is upgraded from windows NT to Windows 2000.
Before upgrade I backed up all the outlook 2000 .pst files.
Now I have outlook 2003. I unable to retreive .pst files.
viji.pst file is available under C:\Documents and
From outlook menu file -> data file management ->add ->
outlook 97-2002 personal folder.pst -> viji.pst
prompts to enter passwd. Please reply how do I retrieve
the passwd protected .pst file. This are very important
emails. Please reply.
Viji Jayaraman <firstname.lastname@example.org...How can I access a file in Outlook Public Folder by VBscript
It does not have to be VBscript..
I need sync the file with my local harddrive...
> It does not have to be VBscript..
> I need sync the file with my local harddrive...
Why does it need to be a script at all? You can add your public folder to
your PF\Favorites (drag it there) and include it in your send/receive
settings for offline use with your OST file.
...Software copy-protection strategies involving unlock codes
I would like to learn about strategies for protecting my software against
illicit copying, by supplying users with unlock codes which they have to use
to unlock the program's full functionality. Does anyone know of any good
books on this topic, or other sources of information on it.
I don't, although I've done a bit of work in this area myself.
The first issue you need to deal with is how to stop a customer that has the
code from being able to give it to someone else. I simply have the code tied
to the customers name and company, if any. This way, they can st...moving files
How do I move files from publisher 98 to publisher 2000? The programs are
If you are talking about the documents you created, you wouldn't have to.
But if you wanted to - copy and paste.
MVP Microsoft [Publisher]
"dunefarm" <email@example.com> wrote in message
> How do I move files from publisher 98 to publisher 2000? The programs are
> installed separately.
...open excel 2007 refresh query from batch file
I have a simple script saved as "C:\refresh_excel.vbs" that opens an
Excel file, and does a refresh for a query on Sheet 1. I created a
scheduled task to run this every day.
It worked fine for previous versions of Excel, but since I have
upgraded to Excel 2007 it doesn't work. Any help it helping me figure
this out would be appreciated.
/*contents of refresh_excel.vbs*/
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkBook = objExcel.Workbooks.Open("C:\reports\UPS.xls")
objWorkbook.Sheets("...Arrears Help Files
Hello all, I don't seem to have the help file for the Arrears
transactions. I can't find it on my system don't see a reference to it
in the main GP 10 help file. We have GP 10 SP 4. I looked in KB see no
reference to that particular problem anywhere. TIA
On Feb 10, 8:12=A0am, Brian <nixtoo...@hotmail.com> wrote:
> Hello all, I don't seem to have the help file for the Arrears
> transactions. =A0I can't find it on my system don't see a reference to it
> in the main GP 10 help file. =A0We have GP 10 SP 4. =A0I looked in KB see=
no...Can OnPrint output be saved to a file?
Can OnPrint output (icluding fonts,rectangles,brushes...) be saved to a
I am currently writing output in rtf file format for this purpose and it is
more time consuming then producing a report via OnPrint.
How about using standard OnPrint code and mess with the Print to file option
in the Print dialog box?
Available for consulting: http://www.softcircuits.com/jwood/resume.htm
"Charles C." <firstname.lastname@example.org> wrote in message
> Can OnPrint output (icludin...Message-Data file not properly closed???
Upon boot of Outlook, EVERYTIME, I get this message--Data file did not close
properly the last time it was used and is being checked for problems.
Performance might be affected by the check in progress.
When I leave Outlook, I have made sure to close all files and exit properly.
Is there some reason this happens? I even go back to my main screen now.
Is there something more I should be doing.
Did the file checking finish before you closed Outlook?
If not, it will continue/restart the next time you start Outlook.
If it still does this after the checking has completed, the..."Can't Create Backup FIle. Save [filename] Without Backp?
I get the following message every so often when running
Excel 2003 under Win XP:
"Can't create backup file. Save [finename] without backup?"
I respond: "OK"
"Your changes could not be saved to [filename] because of a
sharing violation. Try saving to a different file."
I respond: "OK". It presents me with the standard window
allowing me to enter a new filename, which I do, then press
OK. Then I get:
"Do you want to save the changes you made to [fileename]?
I respond: "Yes"
"Document not saved."
This is VERY annoying. I am t...Money Backup File Security
I regularly take backup of my money file. I secure my money software with a
password also. My question is regarding the security of the backup file.
When I take a backup do I need to remember the password also? Let's say I
took a backup a month ago and after that I changed my money password. And for
reasons unknown I forgot the password which I had set when I took the backup.
In the event of failure when I try to restore it from that backup will it ask
me for a password? If yes, which one? If not - then is it not a security
breach considering the fact that the backup CD might be sto...Mail forwarding to another server
Is there any way to forward all mails for a particular user from exchange
server to another mail server.
Any help would be great.
Thanks and regards,
Create a contact with the external address of the user then on the users
account in Active Directory User & Computers | Exchange General | Delivery
Options | Forward to: click modify and point to your newly created contact.
"SHAMMY" <SHAMMY@discussions.microsoft.com> wrote in message
...Copy Posts from one Public Folder to Another
I have an Exchange 2003 Public folder tree that has multiple levels.
I have a need for users to Post to one public folder and then have a
copy of that Post copied to another public folder automatically. I
have set this up for emails (plain forwarding) and it works fine but I
have yet been able to get the Posts to duplicate to the other folder.
Does anyone have any ideas? Your help is greatly appreciated.
There are two ways to forward email out of a public folder:
1. Used a rule on the public folder. As owner of the public folder go to
properties and to the folder assistant ...Problem with Money finding files after hard drive crash
My hard drive was corrupted and crashed. I was able to preserve data files,
including the Money account file and Money backup file. The hard drive was
replaced, and I copied the Money data files back onto the hard drive, as well
as the Money program.
When I try to set up Money again, it cannot find or connect with the data
files, despite my specifying the drive location of the files. Is there a way
to get that to happen?
I don't know if this is part of the problem, but the description of my data
files calls them Money 2004 files. The recovery version of Money is Money
2005, wh...Copying a sheet fails
I have a line that copies a sheet from one book to another. It works a
number of times in my macro then inexplicably stops working.
The line is:
And I get the error: 1004
"Copy method of worksheet class failed"
It stops when I try to add the 54th sheet in a workbook - I don't know if
that number is significant.
There is no problem with the string: 'NewBookName' or the sheet named 'XXX'
(as I say the line works 52 times)
But suddenly I get an error
Anyone seen this bef...How to: Open *.MSG File from Hard Drive via Code
I need to :
Open *.MSG File from Hard Drive via Code
and extract the file attachment. I have hundreds of these emails that we
need the attachments extracted from. But the .msg files are on a hard drive.
Someone help me out here....
I need the code to open and access the mailitem....
how do I open a .msg file?
Use the CreateItemFromTemplate() method for that.
[MVP - Outlook]
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.