code to delete vba code
I hve found this code to delete all code within a workbook.
As soon the code reach the line If "ThisWorkbook.VBProject.Protection Then
Exit Sub" the code stop and a failure message appear "if without end if "
could you please help me with this issue.
Dim StartLine As Long, LineCount As Long
If ThisWorkbook.VBProject.Protection Then
On Error Resume Next
StartLine = .ProcStartLine("Workbook_Open", 0)
If Sta...Reflecting info between an excel file and a word one or two excel file.
I have an Excel file that I use as a database with the dates of the
time when my company does the maintenance of our electronics tools (we
work in an industry that uses them a lot, we have around 200 in an
So the documents look as follows (the images are copied and edited in
paint, that's why they look kinda weird). They are next to each
other; I divided it here in order to fit it to word's format (it's
in Spanish, there's no need for you to understand what it says
Go to www.caladeamerica.com.ar/1st file.jpg please and see it.
We do the maintenance of...i get error 404 not found when trying to download
I'm trying to download nokia pc suite to windows xp to upload gallery onto
the computer but get error message404 not found - how can i download this pc
Krysy Albutt wrote:
> I'm trying to download nokia pc suite to windows xp to upload gallery
> onto the computer but get error message404 not found - how can i
> download this pc suite please
Care to enlighten us how this pertains to: -
If you're having problems downloading from the *NOKIA* site where do you
think you should be directing your ...How do I import a WORD file into EXCEL? #2
I'd like to import a WORD table to Excel but when I go to "Select Data
Source", only other EXCEL files show, not my WORD files but the Help function
indicates that all files should be showing. I've selected "Text Files" from
the Data Source; I've tried "All File Types" with no luck. Anybody have a
clue for me? ..signed, an Excel Idiot......thanks!
File>open and select all files or copy and paste
"MauiMama" <MauiMama@discussions.microsoft.com> wrote in message
news:27741FDC-23BA-478D-98AC-21760...How to get Calendar to send me reminders
I have changed my e-mail address but for some reason I cannot get Calendar to
send reminders to my new address - I think I have carried out all that is
necessary to effect the changover but I am not getting reminders sent. Can
anyone help please?
Is the Calendar Live ID based and accessible at Calendar.live.com ?
"Dabardevon" wrote in message =
I have changed my e-mail address but for some reason I cannot get =
send reminders to my new address - I think I have...PDF file #9
I have Publisher 2002 and would like to insert a .pdf
file into a document I am working on. How do / Can I do
...isv.config file rollback
I have an issue with the isv.config file. I customized it, adding a couple
of buttons to the toolbar section under quote. Every now and again, the
isv.config file reverts back to an older version of the file, which does not
have my customizations. Has anyone encountered this problem? Is there any
way to prevent this from happening? Is there some setting that I may have
forgotten to set?
The isv.config is just a file so it won't revert on it self.
However if you import an xml customization file this may contain a blank
Patrick Verbeeten (MCSD)
...Some recipients get the attachment, some get winmail.dat
This one has me baffled. We are using Exchange 2000 and Outlook 2000
and have been for 8 months. No previous problems with attachments
(.doc, .xls, .jpg).
About 2 weeks ago, we started hearing from certain recipients that the
attachment wasn't arriving; instead they were getting an unreadable
file called winmail.dat. MS says that this is because the sender is
using Rich Text to format the email. We have changed the senders to
use Plain Text and still have the same problem. If the email is sent
to several recipients, some will get the attachment fine, some will
not. This didn'...Running code when hyperlink clicked
I am definitely baffled. I am trying to run code when a hyperlink is
clicked. I am using Excel 2007, the hyperlink is created in a cell on Sheet
1 using "=hyperlink()", the hyperlink is to a video clip, and events are
definitely enabled. I had tried two things, either of which would be fine:
1. I put the following code in Sheet1, and it did not respond at all. What
am I doing wrong?
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheets("Sheet1").Range("B1") = "It Ran"
2. I put the following...How to get the CScrollBar's Handle in CTreeCtrl?
I thought I have a problem when I trid to get the CScrollBar's handle from
my CTreeCtrl extended handle.
Can anybody tell me whether I can get the handle of the CScrollBar from the
Thanks in advance!
> I thought I have a problem when I trid to get the CScrollBar's handle from
> my CTreeCtrl extended handle.
> Can anybody tell me whether I can get the handle of the CScrollBar from the
> Thanks in advance!
Sorry, it is not that simple. The scroll bars that...Conditional linked files
I have two files (a master and a detail) in which I pull through a
column from the detail to the master, using "=[Detail.xls]Sheet1!$A$2"
However I would like to configure the spreadsheets so that only data
which meets a condition is pulled in the master, in other words using
pseudo code as follows.
If [link] in detail.xls = yes then display in master. I realise that
the condition statement will probably need to sit in the master file
but have no idea how this is done or whether possible at all.
--------------------------------------------------...A Crystal Beginner
I am using Crystal 220.127.116.11 and have loaded the Crystal enhancements.
Now I want to do against the CRM database. What do I do?
I thought I would create a data source to the CRM SQLserver, which I
did, then connect to it through Crystal Reports. That works, but when
I drill down on the AAA_MSCRM database to choose my tables, it shows
me dbo as the only option (where did this come from??) and under
that are just a few generic tables. No CRM tables. Something's not
quite right. What am I missing?
file - log on to aps server
"KBLawson" <email@example.com> wrote in ...Same file exists when I run Optimizer
While I was running the Optimizer to utilize free space I met a error
message during moving the files C:\exchsrvr\imcdata into
D:\exchsrver\imcdata " There is the same file, ...., in the destination.".
But I could see for sure that there was No files in the destination.
Could you let me know how to fix it?
Thanks a lot in advance.
"�̱�ö" <firstname.lastname@example.org> wrote:
>While I was running the Optimizer to utilize free space I met a error
>message during moving the files C:\exchsrvr\imcdata into
>D:\exchsrver\imcdata " There is...file is locked does not appear in Excel if file already open by an
We have shared files on a network drive. When a file is open by one user,
and a second user opens the file we want them to recieve <filename> is locked
for editing message and open the file read only. This works great for some
users, but we have several users that can open the file (even if someone is
already in it) and they do not get the prompt and can edit the workbook. Is
there a setting that would turn this off for some users and not others in
You could try sharing the workbook.
With the Excel workbook open, choose Tools from the menu.
Choose Share W...Cannot get fast forward or fast reverse to work with WMP 11
I am running Vista Home Premium on a HP G 217-EM Notebook which comes
pre-installed with Windows Media Player 11. When I play cds and try to fast
forward or fast reverse by keeping the fast forward or fast reverse buttons
constantly depressed nothing happens.
Why is this, and can anyone come up with a solution?
This doesn't work on my system either, so it's probably just a
limitation of WMP. Fast forward and fast reverse should work fine when
you rip the CD's to MP3 or WMA files, and play these files instead.
Tim De Baets
http://www....I can not open doc file attachments from outlook express 6.0
I can not open doc file attachments in outlook express 6.0
Error message - There is not enough memory to open file
All other attachments eg: jpeg etc are fine
I have already increased my paging memory.
>I can not open doc file attachments in outlook express 6.0
>Error message - There is not enough memory to open file
>All other attachments eg: jpeg etc are fine=20
>I have already increased my paging memory.
These Newsgroups address Office Outlook issues. Outlook
Express gurus hang out here:
http://communities.microsoft.com/newsgroups/def...Get paid while you get online!!
I found a great Internet company - Cashfiesta.com - that has created a
product everyone can benefit from. They pay you while you work or play
on your computer. All you need to do is keep their software - the
FiestaBar=99 - active while you are online. They even pay you when your
friends are using their computers.
Unlike other companies, Cashfiesta gives you control over how much
money you earn. They have an individual payrate based on the number of
Special Offers you sign up for. As some of these offers are free, you
can increase your payrate up to 33 times without spending a penny.
It's...Can't get auto-update (update) to install
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I've been trying to manually check for updates to Word 2008, and I get a "critical update" notice, asking me to install auto-update. When I try to install it, I cannot. It just keeps repeating the attempt, in an "endless loop." What to do? <br>
...Converting Outlook files #2
In a magazine article that I read, it said that when moving from Outlook 2002 or
earlier to Outlook 2003, you should convert the file to the new format that is
found in 2003, but how can I do that
BTW. I don't want to loose all of the documents and setting that are already
associated with the current file
Thank you in Advance
Merci a l'Avance
In Outlook 2003, File->New->Outlook Data File->Type->Personal Folders File.
Do not select the 97-2002 format. Then drag and drop your folders from the
old to the new.
Milly Staples [MVP - Outlook]
Post...Spreadsheet getting corrupted
I have a relatively large spreadsheet.
I am getting errors (see after my signature line). What could be
causing these errors? Is it that the spreadsheet is too large?
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and Settings\deguza\My
The following is a list of repairs:
Global PivotTable report information was repaired due to integrity
Global PivotTable report information was repaired due to integrity
How do I unzip files contained in an email using Windows Office 2000?
You have to download the pkzip app, or an equivalent eg winzip, from one of
the shareware sites
"Rita" <email@example.com> wrote in message
> How do I unzip files contained in an email using Windows Office 2000?
...Increasing the number of files as recent files
When I open file menu, I get the last 4 files I have previously openned.
Is there a way to increase the number of recent files I have openned
Thanks in advance.
You can go up to 9 entries in Excel 2000.
Tools, Options, General, [x] recently used files list: -- 9 -- entries.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Hamed" <firstname.lastname@example.org> wrote ...
> When I op...Intersting issue regarding msg files
I have a client using Outlook 2003.
1. Client creates a message (default format is HTML) and saves it as a
2. Client then drags and drops message from draft folder into a network
location. File has .msg extension.
3. Another user then double clicks on the msg file, and makes some live
changes to it and then clicks SEND
4. Message is sent but none of the changes were made.
The client used to do this with Outlook Express and never had a problem.
Now that they are using Outlook 2003 this problem has surfaced.
...Checking specific text string in excel files stored in a folder
I need to write a code that can do the following:
1) prompt user to select a particular folder
2) search for a particular text string, for e.g., ABCD in all the
excel files in that folder (the number of files in the folder will
vary and so does the names of the files). Is it possible to specify
the string that we want to search on the fly when macro is run?
3) create a simple report that contains the filename in one column and
yes / no in the second column that tell me which file names contain
that keyword (it will be great if the path of the file can be recorded
in the 3rd colum...Reg getting the next IV Document Number field !
I am creating a window in dexterity similar to the item transaction entry
window (Transactions>Inventory> Transaction Entry).
In the Item transaction Entry window, the Document number field defaults to
the next document number when we move the focus to that field.
I wanted to know if there is any function , or table that i can access to
get the next document number in the new window that i am creating.
>In the Item transaction Entry window, the Document number field defaults to
the next document number when we move the focus to that field.<