LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default I Can't Get VBA to Work

I've written an Excel program with extensive VBA macros
for a Federal agency here in the Nation's capital. The agency
network is built around Windows 2000 and uses Excel 2002, and
the Visual Basic module is loaded and its icons are on the toolbar.

When I attempt to run my program, Excel bombs out, issuing
messages that it does not recognize such built-in functions
as CHR( ), RIGHT( ), LEFT( ), MID( ), SPACE( ) (or their
dollar sign versions CHR$, etc.). Excel programs with extensive
VBA macros without these functions run just fine. It appears to
me that some DLL or other critical system component has been
wiped out, but I have no idea which one. I've suggested to the
agency's IT department to do a re-install of the entire operating
system and Excel, but they are reluctant to do this for me
(as I'm the only Excel user in the whole place writing VBA
macros, believe it or not).

Anybody have any ideas or suggestions?

-- Dennis Eisen
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to update a column in a work based on another work sheet WickerMan New Users to Excel 1 December 4th 09 12:58 PM
how can i automatically generate work order numbers from work orde rob h Excel Discussion (Misc queries) 1 July 13th 09 07:59 PM
flash object dont work in my excel work sheet Nitn Excel Discussion (Misc queries) 0 July 4th 09 08:00 AM
Counting dates in multiple work sheets and work books Savage Excel Discussion (Misc queries) 0 December 19th 05 11:41 PM
Is there away to keep "auto save" from jumping to the first work sheet in the work book? Marc New Users to Excel 2 April 21st 05 01:27 AM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"