Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXPORT XL MACRO TO VB APP AND RUN THERE

Status
Not open for further replies.
kev777

kev777

Technical User
Joined
Nov 18, 2001
Messages
9
Location
GB
I have written a macro in XL and exported it to a VB app I'm working on. I have copied it into a sub proc in VB but getting errors when it hits the first line of the macro. What am I missing? Sorry - newbie!

Thanks,

Kev.
 
Sort by date Sort by votes
Have you set a reference to the excel object library?

Maybe you could give us more to work on? Like some code?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ken01
  • Question Question
VB classic graphics
Replies
3
Views
516
strongm
strongm
BigTG
  • Locked
  • Question Question
Converting an old XP VB6 program to run on Windows 7 & Windows 10
Replies
5
Views
940
vb5prgrmr
vb5prgrmr
sal21
  • Locked
  • Question Question
via vb 6.0, please split access table
Replies
1
Views
506
strongm
strongm
sal21
  • Locked
  • Question Question
.Bat tu run myapp.exe as amministrator
Replies
7
Views
1K
klima
K
44MARCO
  • Locked
  • Question Question
MACRO SETTINGS - VBA PROJECT OBJECT MODEL
Replies
2
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top