Welcome, Guest. Register Now!
   
Mark Forums Read Mark Forums Read Mark Forums Read


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-17-2007, 02:47 PM
Junior Member
 
Join Date: Dec 2007
Posts: 1
iTrader: (0)
johnnypoi is on a distinguished road
Default Macro Problem in Excel

We are having problems with a Macros in Excel. Specifically, we have individuals who download data from an Oracle DB to an Excel spreadsheet.

After the data is downloaded, a series of four macros are executed to format another spreadsheet and populate it with the raw data from the spreadsheet with the download.

Here is the problem: on some machines the process runs perfectly and on others we have just a blank sheet with no data. The macros don't execute correctly on the latter machines.

This spreadsheet file is shared so the computers that can run the process and those that cannot are all looking at the same file on a shared file server.
-------------------------------------------------------------------------------------------------

What can cause these Excel Macro Problems:

We have looked at the following and found nothing.
1) Macro Security Level (Even on low it would not work for these individuals)
2) In VBA we tried to see if they had the appropriate Libraries installed
(They did, so we ruled that out).

Any suggestions would be greatly appreciated.

Last edited by johnnypoi : 12-17-2007 at 02:49 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



All times are GMT -6. The time now is 03:35 AM.