Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to export chart to a network drive?
I tried to export a chart to a network drive but it appeared an error
said "object variable or withblock variable not set". here is the code: Private Sub Workbook_Deactivate() Application.ActiveWorkbook.ActiveChart.Export Filename:="\\dc\youu \MyChart.gif", _ FilterName:="GIF" End Sub I try to add the codes below at the beginning,but it appeared the same error. ChDir "\\dc\Operation\Store-Department" can anyone tell me the reason? How to solve this problem? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Network drive | Excel Worksheet Functions | |||
Map Network Drive | Excel Discussion (Misc queries) | |||
Using An Add-in On A Network Drive | Excel Programming | |||
Link workbooks-C drive to network drive | Excel Worksheet Functions | |||
Userform Local Drive & Network drive question | Excel Programming |