Search results

with the definitions i had in my code, when i used the 2 lines of codes u suggested, it returned the the error : object doesn;t suport this property or method..

the code stopped at objExcel.ActiveSheet.Pictures.Insert(ActiveCell.Fo rmulaR1C1). _ Select

but its illogical tat it runs the 1st time, then second time, after it opens the new spreadsheet in Excel, it gives the error on the underlined code with the error. I will then close the opened spreadsheet. When i run it the next time, it works again. tats y i suspected its got to do with the...

Sub Export() Dim objExcel As Excel.Application Set objExcel = CreateObject("Excel.Application") DoCmd.OutputTo acOutputQuery, langName & " Q", acFormatXLS, tbFile, False 'export the query OpenFile (tbFile) 'using shellexecute to open tbFIle, file tat was exported to excel Call Convert 'a...

i tried, but under this code "ActiveSheets.Pictures.Insert(ActiveCell.FormulaR1C1).Select", the error is given as compile error, variable not defined, same error as the one i got previously... this code is found inside my convert() function. previously, the error i encountered was Method ' ' of...

Hi all, below is a sample of my code Sub Export() Dim objExcel As Excel.Application Set objExcel = CreateObject("Excel.Application") DoCmd.OutputTo acOutputQuery, langName & " Q", acFormatXLS, tbFile, False 'export the query OpenFile (tbFile) 'using shellexecute to open tbFIle, file tat was...

Hi all, below is a sample of my code Sub Export() Dim objExcel As Excel.Application Set objExcel = CreateObject("Excel.Application") DoCmd.OutputTo acOutputQuery, langName & " Q", acFormatXLS, tbFile, False 'export the query OpenFile (tbFile) 'using shellexecute to open tbFIle, file...

Hi all, When i put my codes in the following sub, Private Sub Workbook_Open() , into my spreadsheet, the codes in this sub will be executed whenever this worksheet is loaded. However, I need to pass in an argument into this sub, isit possible to be done? Thks FT :)

thks robert :p

Hi all, I want to open a form everytime MS Access loads this DB. Can pls guide me how it shld be done? Thks FT :)

Thks for the sample, i actually generated a new file, eg, NEW.xls from access, then i will export n open the NEW.xls in Excel. I wan the macro to run automatically once the file opens in Excel. Since this file is newly generated, I cant possibly have codes written in it.. I can onli call macros...

Hi, what do you mean by putting the excel code to run on open? do i put the above codes inside my VBA for access? As for the <code>, it shld be the lines of macros codes that i need to run? Thks for ur reply

Hi all, From my MS Access Form, i used shell command to open a file in MS Excel. however now, i want to run a macro in the MS excel file tat i have opened.. Any specific commands to execute macros? Thks FT :)

thks brothers, it works..:)

I read from VB help file that to replace question mark, "?", we enclose it in brackets since "?" is a special character. However, i tried (?) or [?] but it cant work? Anyone can help?? Thks FT:)

thks, i will chk it out.. u been of great help FT:)

After exporting an EXCEL file from MS access, how can i call MS EXCEL to open up automatically and execute a macro to be run on the file tat i exported? I have done the "export" part of the codes in MS Access. I need help on how to open MS excel n run the macro.. thks.. Eg. I export test.xls...

Hi all, From MS Access, I want to export my files to MS excel. However, i want to allow the user to open up windows file browser to select the folder n filename. Any advice on how can i go about coding this? Thks FT :)

can u give an example of how to name the objects using the cell references as suffix for each name? thks

thks brothers for providing such wonderful solution.. it works as wat i wanted.. Hope u guys won't mind, I have another question pertaining to the same topic of objects.. For example, i want to select an object that is located in Cell(3,30), anyway i can select the object? or i can only select...