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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting the file name when using OLEEmbeded objects

Status
Not open for further replies.
emnet24

emnet24

Programmer
Jan 21, 2007
1
CA
I created an OLE object to embed an .xls file into the table.
...
OLETable2.OLETypeAllowed = acOLEEmbedded
OLETable2.Action = acOLEInsertObjDlg
...
The code works, but in the same time I want to use the original .xls file name and copy and rename it in the same directory ( I used for this the copy method from kernell32.dll which works well for "Application.FileDialog(msoFileDialogFilePicker)" ).
How can I get the file name when the dialog is not simple "open file" but acOLEInsertObjDlg?

Thanks
 
Status
Not open for further replies.

Similar threads

Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
438
Zyborg
Zyborg
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
707
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
238
combo
combo
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
356
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top