Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default VBA problem with excel 2003

Two things...
1. Define strange warning. What is the actual text of the warning message.
2. Post your code (hard to debug without source code)

--
HTH...

Jim Thomlinson


"Josh" wrote:

We have recently upgraded our office products. I have been use a macro that
goes out to a file on a server and opens the file then populates some cells
prints the sheet and then closes excel. The problem is now with 2003 I get
this strange warning when the macro opens the file.



Any one have any idea how I stop this from happening?

TIA
Josh



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default VBA problem with excel 2003

Please view the atached file.

"Jim Thomlinson" wrote in message
...
Two things...
1. Define strange warning. What is the actual text of the warning message.
2. Post your code (hard to debug without source code)

--
HTH...

Jim Thomlinson


"Josh" wrote:

We have recently upgraded our office products. I have been use a macro
that
goes out to a file on a server and opens the file then populates some
cells
prints the sheet and then closes excel. The problem is now with 2003 I
get
this strange warning when the macro opens the file.



Any one have any idea how I stop this from happening?

TIA
Josh





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default VBA problem with excel 2003

I have found that on my computer it works fine but on the new computer it
does not. here is the code. I feel that it must have to do something with the
security settings? I can prdoduce this error by this code.

Private Sub CommandButton1_Click()
fsindex = "http://xxxxxxxxxxxx:8508/passthru/consumer?name=FS%20-0869-0028"
ActiveWorkbook.FollowHyperlink Address:=fsindex, NewWindow:=True
ActiveWindow.WindowState = xlMaximized
End Sub

"Jim Thomlinson" wrote:

Two things...
1. Define strange warning. What is the actual text of the warning message.
2. Post your code (hard to debug without source code)

--
HTH...

Jim Thomlinson


"Josh" wrote:

We have recently upgraded our office products. I have been use a macro that
goes out to a file on a server and opens the file then populates some cells
prints the sheet and then closes excel. The problem is now with 2003 I get
this strange warning when the macro opens the file.



Any one have any idea how I stop this from happening?

TIA
Josh



Reply
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
Excel 2003 VBA problem BJ&theBear Excel Discussion (Misc queries) 4 May 11th 10 01:09 PM
Excel 2003 problem steelcitymm Setting up and Configuration of Excel 2 February 25th 09 07:52 PM
Copy and paste problem Excel 2003 to Word 2003 [email protected] Excel Discussion (Misc queries) 2 August 28th 07 11:14 AM
XML Problem in Excel 2003 Marilyn Excel Discussion (Misc queries) 0 December 13th 06 02:16 PM
Problem with Excel 2003 and ole and vb Darkwing Excel Programming 0 October 28th 04 08:57 PM


All times are GMT +1. The time now is 12:10 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"