We have a simple setup on one server where we had a software mirror.
When we recieved a message that the mirror disk had failed, we replaced the hard drive and restarted.
The original disk is now set as Disk 1 in the Disk Manager, and the new mirror disk is set as Disk 0. This is despite the...
i think the problem was because i did not complete the wizard properly.
my colleague has given me a recorded macro of the entire process which now works.
thanks for your help guys - sorry that i've been so dense
I still get the '1004' error with this code:
Worksheets(1).Activate
ActiveSheet.ChartObjects("Chart 3").Activate
With ActiveChart
.Type = xlLine
.HasTitle = True
.ChartTitle.Text = "Historical Data"
With .SeriesCollection
.Add Source = Worksheets(2).Range("C:C")...
actually - i just tried that, and it failed...
ActiveSheet.ChartObjects("Chart 3").Activate
With ActiveChart.Chart
.Type = xlLine
.HasTitle = True
.ChartTitle.Text = "January Sales"
numRows = Worksheets(2).Rows.Count
With .SeriesCollection...
Geoff,
I did that and the macro recorded was:
ActiveSheet.ChartObjects("Chart 3").Activate
I then put the following code in my vb script:
Worksheets(1).Activate
ActiveWorksheet.ChartObjects("Chart 3").Activate
and now I'm getting an "object required" error on the second line instead...
I getting a "subscript out of range" error when i try and specify my chart as:
ActiveWorkbook.Charts(1).Activate
I only have one chart in the workbook, and cannot find any other way of referencing it.
TIA,
Stuart
Thanks Skip,
As I said in my other question today, I'm not too well-up on VBA, so I'm kinda throwing things from the on-line help together and hoping it sticks :)
Cheers for your help - I got the code working again.
Hi,
I'm having a bit more trouble now.
This code was working about an hour ago, and now it isn't. I didn't change anything (simply closed the workbook and then re-opened it).
I keep getting errors on the Worksheets(2).Columns("A:A").Select command
TIA - Stuart
Private Sub...
Hi - I'm getting a "bad recordlength" error message when I use the GET statement to read from a csv file.
Problem is, I don't know what the length of the line is until I read it.
Any help would be appreciated.
Stuart
I realise that this is a bit of a newbie question, but I haven't much experience with ODBC.
I have an ODBC connection from a third party software package to an Excel file.
When the connection is active, I cannot open the Excel table. Is there a reason for this?
I had opened the file in Access 97 to check the access rights, and the "Admin" owned the database and had complete access to it.
I was hoping for a better answer than just "corruption" because I would like a preventative measure.
I had already imported all the tables into a...
I am experiencing an interesting problem.
I have two Access database files that were created using the 95/97 file format (not too sure, but probably 95).
When I try and open these in Access 2002 I recieve a message saying that the current user does not have access rights to the database, and...
Where is the PATH setting for Windows 2000 Professional?
I have tried several .ini files and search the whole registry, but cannot find anyplace where the PATH parameter is set.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.