By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Graphs in userform

P: 9
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
Share this Question
Share on Google+
4 Replies


kadghar
Expert 100+
P: 1,295
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

Expert 5K+
P: 8,434
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

P: 9
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
Expert 100+
P: 1,295
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

Post your reply

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