Macro problem - stops after the hyperlink is downloaded

**RBI** · 10-26-2008, 05:05 PM

Hello,

Please find attached worksheet. There is a macro that u can activate using CTRL +SHIFT+ Q. The macro is to follow a hyperlink that will download stock price history, copy it to the workbook and close the window of the original data.

For some reason the macro stops after the hyperlink is downloaded... it doesn't state an error it just neglects all code after the hyperlink. Can anyone help me out with this.

**rylo** · 10-26-2008, 10:00 PM

Hi

Had to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and make sure there was a workbook called book2 open, but it seemed to run through. Can you use the debug, step through the code and see just where it is not actioning???

rylo

**stanleydgromjr** · 10-27-2008, 06:45 PM

RBI,

Please Login or Register  to view this content.

[LIST=1]When I stepped thru the code in the VB Editor, I noticed that after finishing that the VB "Design Mode" icon was active.

When I ran your original code, with CTRL+SHIFT+Q it failed.

If you run the macro "History_D":
Tolls, Macros, Macros..., and pick the "History_D" macro, and click on the "Run" button.

The attached workbook has a command button, please use this button to activate the macro.

And, have "Book2.xls" open!!!!

Please Login or Register  to view this content.

Have a great day,
Stan

**RBI** · 10-30-2008, 08:44 AM

Thanks Stanley Huge Help!!!

Can you (Or anyone for that manor) Explain tho what how that "LC&" Variable
Works, I fairly new to VBA and I just wanted to know how that trick works.. What is the * represent??

I know it is retreiving the last cell cell of the data range but i don't understand how..

Thanks

**stanleydgromjr** · 10-30-2008, 08:27 PM

RBI,

Explain tho what how that "LC&" Variable

"LC&" is a short way to define a variable in a macro.

You could use:
Dim LastColumn As Long
or
Din lngLastColumn As Long
or
LC&

The "&" stands for the Long data type.

' Dim x% ' As Integer
' Dim LR& ' As Long
' Dim Dollars# ' As Double
' Dim Test$ ' As String

Have a great day,
Stan

Macro problem - stops after the hyperlink is downloaded

LinkBack

Thread Tools

Rate This Thread

Display

Macro problem - stops after the hyperlink is downloaded

Thanks

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions