473,322 Members | 1,806 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Graphs in userform

i have an activex graph working in my user form, when i move the file to another directory the userform still works but the graph no longer updates it stays as the last instance.
any ideas?
help would be greatfully appreciated.
Jan 15 '08 #1
4 1635
kadghar
1,295 Expert 1GB
i have an activex graph working in my user form, when i move the file to another directory the userform still works but the graph no longer updates it stays as the last instance.
any ideas?
help would be greatfully appreciated.
Have you checked the paths where the information is retrieved?, may be some paths aren't full names, so VB search them in the current file directory.
Jan 15 '08 #2
Killer42
8,435 Expert 8TB
i have an activex graph working in my user form, when i move the file to another directory the userform still works but the graph no longer updates it stays as the last instance.
any ideas?
help would be greatfully appreciated.
Can you give us some idea of the sort of environment we're talking about? For instance, the expression "user form" sounds as though it may relate to VBA in either Excel or Word?
Jan 16 '08 #3
the vb is in excel, the data path does relate to current directory but there is a copy of the data there so everything is the same.
Jan 16 '08 #4
kadghar
1,295 Expert 1GB
the vb is in excel, the data path does relate to current directory but there is a copy of the data there so everything is the same.
Since you're working with VBA in Excel, the code should say something like

activeworkbook.path & "\sourceFile.ext"

all you have to do is put the sourcefiles in the same dir as de activeworkbook (the excel file with the macro), ro rewrite that path:

"c:\mypath\sourceFile.ext"

HTH
Jan 16 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Marknanh | last post by:
Simple question. I'm a VBA programmer who has just switched to VB .net. I'm using a UserForm called Form1 with a text box called TextBox1. I'd like to reference the number in the text box in...
0
by: szymon_k | last post by:
Hi. How to set the userform as subform of some access form? What I need to do is to insert some userform into the form, so that it will be under the same conditions of resize, move and other...
3
by: gw.boswell | last post by:
I have created a userform with textboxes for data entry. I also have a command button that calls a second useform. A user enters certain information in the first useform but if he/she wants to do...
2
by: williamyeow | last post by:
Hi i am new to excel VB. can anyone tell me how to link userform to another userform? My concept for my program I have set up a userform with a couple of option. after the user has chose the...
2
by: golf32902 | last post by:
i have a button on sheet 1 and i would like the userform to insert the text i input into sheet 2. And if there is a way the next time i access the userform that is inserts wha i have in the cell...
2
by: hapnendad | last post by:
I am using a selection_change event on a worksheet to launch a userform that will populate the cell when a selection is made from a drop down list box on the form. Selection_change shows form if cell...
3
by: fcgp1985 | last post by:
Hi, I have created a command button that validates information on the userform. For example: While textbox1.Text = "" MsgBox "Please enter the reference of the document.",...
1
by: brenty66 | last post by:
I have a userform that is used as an interface for information stored on excel spreadsheets. The user enters bits of information into fields on the userform which are place on the corresponding...
3
pod
by: pod | last post by:
Hello What I want to do is: from this workbook (thisWB), I want to access a userform's properties that are in another Workbook (toolWB) I can do this for worksheets, but I want to do it as...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.